public void Start()
{
try
{
ChangeOfferingBusiness.Common.Writelog = ConfigurationManager.AppSettings["Writelog"].ToString() == "1" ? true : false;
ControlService = ConfigurationManager.AppSettings["ControlService"];
if (ControlService == "1")
{
ChangeOfferingBusiness.Common MyCo = new ChangeOfferingBusiness.Common();
MyCo.Download();
}
}
catch (Exception ex)
{
MyLogEvent(ex.Message);
}
}
public void Download()
{
try
{
DBHandlerMySQL DH = new DBHandlerMySQL();
ChangeOfferingBusiness.Common CommonObj = new ChangeOfferingBusiness.Common();
ChangePrimaryBusList ChangePrimaryBuslst = new ChangePrimaryBusList();
string SQLinsert = string.Empty;
string msg = "Choose offer by enter \nCO(space)number\n---------";
string Offers = "";
int i = 1;
DataTable dtRequest = DH.ExecuteDataTable("select * from SmsServer.Messages where CustomField1=0 and (lower(body)='co' or lower(body)like 'co %')");
foreach (DataRow dr in dtRequest.Rows)
{
ChangePrimaryBus ChangePrimaryBusObj = new ChangePrimaryBus();
ChangePrimaryBusObj.MSISDN = dr["FromAddress"].ToString().Substring(3);
ChangePrimaryBusObj.SMS_content = dr["Body"].ToString();
int Option = 0;
if (dr["Body"].ToString().ToLower().Equals("co"))
{
ChangePrimaryBusObj.status = 0;
ChangePrimaryBusObj.request_type = 0;
DataTable dt = CommonObj.GetMappingPrimaryOffer(ChangePrimaryBusObj.MSISDN);
if (dt.Rows.Count > 0)
{
foreach (DataRow drr in dt.Rows)
{
msg += "\n" + i++.ToString() + "-" + drr["offer_name"];
Offers += ",[" + (i - 1) + "]:" + drr["offer_id"];
}
CommonObj.SendSMS(msg, ChangePrimaryBusObj.MSISDN);
}
ChangePrimaryBusObj.SMS_Options = Offers == ""?"":Offers.Substring(1);
ChangePrimaryBuslst.Add(ChangePrimaryBusObj);
}
else if (dr["Body"].ToString().Split(' ').Length == 2)
{
if (dr["Body"].ToString().Split(' ')[0].ToLower() == "co")
{
bool res = int.TryParse(dr["Body"].ToString().Split(' ')[1], out Option);
if (res == true)
{
ChangePrimaryBusObj = ChangePrimaryBuslst.Get("MSISDN='" + ChangePrimaryBusObj.MSISDN + "' and status=0 and request_type=0 order by receive_date desc limit 1");
if (ChangePrimaryBusObj.SMS_Options == null)
{
CommonObj.SendSMS("send co to see the available offers\n then reply with co number", dr["FromAddress"].ToString().Substring(3));
}
else
{
string offer_ID = "";
ChangePrimaryBusObj.Reply_Option = dr["Body"].ToString().Split(' ')[1].ToString();
foreach (string s in ChangePrimaryBusObj.SMS_Options.Split(','))
{
if (s.IndexOf("[" + ChangePrimaryBusObj.Reply_Option + "]:") >= 0)
{
offer_ID = s.Split(':')[1];
}
}
if (offer_ID.Equals(""))
{
ChangePrimaryBusObj.status = -1;
ChangePrimaryBusObj.request_type = -1;
}
else
{
ChangePrimaryBusObj.status = 1;
ChangePrimaryBusObj.request_type = 1;
string result = CommonObj.ChangeOffering(ChangePrimaryBusObj.MSISDN, offer_ID);
ChangePrimaryBusObj.request_type = int.Parse(CommonObj.GetValueFromXmlTag(result, "com:ReturnCode"));
ChangePrimaryBusObj.error_desc = CommonObj.GetValueFromXmlTag(result, "com:ReturnMsg");
CommonObj.SendSMS("Your change offer result is \n" + ChangePrimaryBusObj.error_desc, ChangePrimaryBusObj.MSISDN);
ChangePrimaryBuslst.Update(ChangePrimaryBusObj);
}
}
}
}
}
else
{
ChangePrimaryBusObj.status = -1;
ChangePrimaryBusObj.error_desc = "Invalid request";
CommonObj.SendSMS("Invalid reply", ChangePrimaryBusObj.MSISDN);
}
DH.ExecuteNonQuery("update SmsServer.Messages set CustomField1=2 where ID=" + dr["ID"].ToString());
} //end for loop
}
catch (Exception e)
{
MyLogEvent(e);
}
}
