use smartsmsrouter;
DELIMITER //
CREATE PROCEDURE get_username (IN musername varchar(60), Out musername_out varchar(60))
BEGIN
SET musername_out = '0';
select username INTO musername_out from userlogin where username = musername;
END//
DELIMITER ;



DELIMITER //
CREATE PROCEDURE get_StatusCode(IN statecode varchar(50), Out myResponse varchar(100))
BEGIN
SET myResponse = '0';
select description INTO myResponse from messagestate where code = statecode;
END//
DELIMITER ;


DELIMITER //
CREATE PROCEDURE get_NetworkCode(IN networkcode varchar(50), Out myResponse varchar(100))
BEGIN
SET myResponse = '0';
select description INTO myResponse from status where code = networkcode;
END//
DELIMITER ;



DELIMITER //
CREATE PROCEDURE update_Messagesent(

IN mstatus varchar(100), 
IN mfailurereason varchar(100),
IN messageID varchar(100))

BEGIN
   
   UPDATE messagesent SET status =mstatus,failurereason=mfailurereason ,track ='2'   where messageID = messageID;
 
END//
DELIMITER ;

Call update_Messagesent("Delivered","No Error","854656720504258390",@response);





DELIMITER //
CREATE PROCEDURE update_Messagestatus(

IN serial  varchar(100))

BEGIN
   UPDATE messagestatus set status ='1' where sn = serial order by sn;
 
END//
DELIMITER ;