Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
            }
        }
Ejemplo n.º 4
0
        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);
            }
        }
Ejemplo n.º 5
0
        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);
        }