public void update_sms_return_id(int sms_inout_id, string sms_return_id)
{
Root_Gen root_obj_in = new Root_Gen();
string sql8 = "update cc.sms_inout set delivery_status='D',message_id='" + sms_return_id + "',status='N' where sms_inout_id='" + sms_inout_id + "'";
root_obj_in.db_InsertUpdateDelete_Operations(sql8);
}
public void select_sf_update_sms_fn(string date, int priority)
{
Root_Gen root_obj_in = new Root_Gen();
string ret;
string sql7 = "select sf_update_sms('" + date + "','" + priority + "') sf_update_sms";
ret = root_obj_in.db_select_operation(sql7, "sf_update_sms");
return_integer = Convert.ToInt16(ret);
}
public DataTable get_sms_history()
{
Root_Gen root_obj_in = new Root_Gen();
try
{
DataTable DT_Obj = new DataTable();
string sql11 = "select 0+number(*) SlNo,mobile_no Mobile_Number,messages Messages,in_out InOut,status Status from cc.sms_inout where in_out='O' order by sms_inout_id desc";
DT_Obj = (DataTable)root_obj_in.db_select_operation_smsHistory(sql11);
return(DT_Obj);
}
catch (Exception ex)
{
trcker_obj.Text_Tracker(Convert.ToString(ex));
return(null);
}
}
public DataTable get_messages_to_send()
{
Root_Gen root_obj_in = new Root_Gen();
try
{
DataTable DT_Obj = new DataTable();
string sql10 = "select mobile_no,messages,sms_inout_id,status from cc.sms_inout where in_out='O' and status ='Y' ";
DT_Obj = (DataTable)root_obj_in.db_select_operation_table(sql10);
return(DT_Obj);
}
catch (Exception ex)
{
trcker_obj.Text_Tracker(Convert.ToString(ex));
return(null);
}
}
public string get_bussiness_date()
{
Root_Gen root_obj_in = new Root_Gen();
string ret;
string sql6 = "select dateformat(max(bank_date),'yyyy-MM-dd') BussinessDay from cc.day_details where closed_by is null";
ret = root_obj_in.db_select_operation(sql6, "BussinessDay");
if (ret != null)
{
return_string = ret.ToString();
}
else
{
return_string = null;
}
return(return_string);
}