private void ReplySendSMS() { string URL; DataTable MtIncomingSMS = new DataTable(); WebClient oWeb = new WebClient(); Byte[] bytHeaders; SMSView smsview = new SMSView(); DataTable dtinsms = new DataTable(); DataTable dtqstatus = new DataTable(); DataTable flagupdate = new DataTable(); SMSController smscontroller = new SMSController(); dtinsms = smscontroller.GetIncomingSMS(smsview); if (dtinsms.Rows.Count > 0) { foreach (DataRow dr in dtinsms.Rows) { string PhoneNumber = (Convert.ToString(dr["sms_phoneno"].ToString())); smsview.MySms = (Convert.ToString(dr["sms_content"].ToString())); string SmsStatusMsg = string.Empty; string SmsDeliveryStatus = string.Empty; dtqstatus = smscontroller.GetQueueStatus(smsview); DataTable dtWcount = new DataTable(); smsview.QueueStatusID = Convert.ToInt32(dtqstatus.Rows[0][0]); if (dtqstatus.Rows.Count > 0) { if (smsview.QueueStatusID == 1) { try { // SMSWaitingQueueCount DataTable dttnx = new DataTable(); dttnx = smscontroller.Getvisittnxidbyusingrepliedsms(smsview); foreach (DataRow drtnx in dttnx.Rows) { smsview.QueueTransaction = (Convert.ToInt32(drtnx["visit_tnx_id"].ToString())); // SMSWaitingQueueCount DataTable dttab = new DataTable(); dttab = smscontroller.GetDeptid(smsview); foreach (DataRow dttb in dttab.Rows) { smsview.DepartmentID = (Convert.ToInt32(dttb["queue_department_id"].ToString())); DataTable dtcount = new DataTable(); dtcount = smscontroller.GetStatusCount(smsview); foreach (DataRow c in dtcount.Rows) { QueueToken = (c["visit_queue_no_show"].ToString()); for (int i = 0; i < dtcount.Rows.Count; i++) { int pos = 0; if (dtcount != null && dtcount.Rows.Count > 0 && Convert.ToString(dtcount.Rows[i]["visit_queue_no_show"]).Equals(QueueToken)) // if (dt.Rows[i]["visit_queue_no_show"] == QueueToken) { pos = i; if (pos > 0) { int t = pos * 5; TimeSpan span = TimeSpan.FromMinutes(t); string aptime = span.ToString(@"hh\:mm"); DataTable dtcid = new DataTable(); dtcid = smscontroller.GetCustIDByUsingQueueno(smsview); foreach (DataRow drcid in dtcid.Rows) { smsview.CustId = (Convert.ToInt32(drcid["visit_customer_id"].ToString())); string str1 = "Your Queue NO:" + QueueToken + " is in waiting state.\r\nYou have " + pos + " person yet to be served.Approximate waiting time " + aptime + " Hours.\r\nYour will be called Shortly.\r\nplease proceed to the waiting area."; //URL = "http://sms.proactivesms.in/sendsms.jsp?user=attsystm&password=attsystm&mobiles=" + PhoneNumber + "&sms=" + strmsg1 + "&senderid=ATTIPL"; //URL = "https://api.aussiesms.com.au/?sendsms&mobileID=61422889101&password=att0424&to=" + PhoneNumber + "&text=" + strmsg1 + "&from=QSoft&msg_type=SMS_TEXT"; // URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&from=Qsoft&to=" + PhoneNumber + "&text=" + strmsg1 + ""; //bytHeaders = System.Text.ASCIIEncoding.UTF8.GetBytes("*****@*****.**" + ":" + "EqMs2015"); //oWeb.Headers.Add("Authorization", "Basic " + Convert.ToBase64String(bytHeaders)); //oWeb.Headers.Add("Content-Type", "text/plain;charset=utf-8"); ////string URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&api=1&to=" + MissedPhoneNo + "&text=" + strmsg1 + ""; //URL = "https://tim.telstra.com/cgphttp/servlet/[email protected]&Password=Qsoft123&destination=" + PhoneNumber + "&text=" + strmsg1 + ""; // SmsStatusMsg = client.DownloadString(URL); //SmsStatusMsg = SmsStatusMsg.Replace("\r\n", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\t", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\n", ""); //XmlDocument xml = new XmlDocument(); //xml.LoadXml(SmsStatusMsg); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); //XmlNodeList xnList = xml.SelectNodes("smslist"); //foreach (XmlNode xn in xnList) //{ // XmlNode example = xn.SelectSingleNode("sms"); // if (example != null) // { // string na = example["messageid"].InnerText; // string no = example["smsclientid"].InnerText; // string mobileno = example["mobile-no"].InnerText; // string URL1 = "http://sms.proactivesms.in/getDLR.jsp?userid=attsystm&password=attsystm&messageid=" + na + "redownload=yes&responce type=xml"; // SmsDeliveryStatus = client.DownloadString(URL1); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\r\n", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\t", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\n", ""); // XmlDocument xml1 = new XmlDocument(); // xml.LoadXml(SmsDeliveryStatus); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); // //XmlNodeList xnList1 = xml.SelectNodes("response"); // //foreach (XmlNode xn1 in xnList1) // //{ // XmlNode example1 = xml.SelectSingleNode("response"); // if (example1 != null) // { // //string rscode = example1["responsecode"].InnerText; // smsview.DeliveryReport = example1["resposedescription"].InnerText; // //string dlrcount = example1["dlristcount"].InnerText; // //string pendingcount = example1["pendingdrcount"].InnerText; // } // } //} #region Samsung SMS gateway //SMS for Samsung gateway // Set the username of the account holder. Messaging.MessageController.UserAccount.User = "******"; // Set the password of the account holder. Messaging.MessageController.UserAccount.Password = "******"; // Set the first name of the account holder (optional). Messaging.MessageController.UserAccount.ContactFirstName = "David"; // Set the last name of the account holder (optional). Messaging.MessageController.UserAccount.ContactLastName = "Smith"; // Set the mobile phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactPhone = "0423612367"; // Set the landline phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactLandLine = "0338901234"; // Set the contact email of the account holder (optional). Messaging.MessageController.UserAccount.ContactEmail = "*****@*****.**"; // Set the country of origin of the account holder (optional). Messaging.MessageController.UserAccount.Country = Countries.Australia; bool testOK = false; try { // Test the user account settings. Account testAccount = Messaging.MessageController.UserAccount; testOK = Messaging.MessageController.TestAccount(testAccount); } catch (Exception ex) { // An exception was thrown. Display the details of the exception and return. string message = "There was an error testing the connection details:\n" + ex.Message; // MessageBox.Show(this, message, "Connection Failed", MessageBoxButtons.OK); return; } if (testOK) { // The user account settings were valid. Display a success message // box with the number of credits. int balance = Messaging.MessageController.UserAccount.Balance; string message = string.Format("You have {0} message credits available.", balance); // MessageBox.Show(this, message, "Connection Succeeded", MessageBoxButtons.OK); } else { // The username or password were incorrect. Display a failed message box. // MessageBox.Show(this, "The username or password you entered were incorrect.", // "Connection Failed", MessageBoxButtons.OK); } Messaging.MessageController.Settings.TimeOut = 60; // Set the batch size (number of messages to be sent at once) to 200. Messaging.MessageController.Settings.BatchSize = 200; //string strmsg = "To confirm an appointment with the Samsung Experience Store,\r\nyou will need 4 characters password. The password is " + strrandom + ""; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi" + " " + Cname + ",Your ticket number is:" + QueueTokenGenerationSMS + " . Thanks"; //"Hi Kara, your ticket number is 040, Approximate waiting time is 00:40 minutes/hours” Messaging.MessageController.Settings.DeliveryReport = true; // SMSMessage smsobj = new SMSMessage(smsview.QueueStatusID, str1); // Messaging.MessageController.AddToQueue(smsobj); Messaging.MessageController.SendMessages(); //end of Samsung SMS #endregion Samsung SMS gateway if (SmsStatusMsg.Contains("<br>")) { SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", "); } smsview.QueueNo = QueueToken; DateTime dattime = System.DateTime.Now; smsview.SMSDateTime = dattime; smsview.SMSStatusFlag = "R"; smsview.Message = str1; smsview.PhoneNo = PhoneNumber; smscontroller.GetInsertReplySMS(smsview); } } else { int t = 5; TimeSpan span = TimeSpan.FromMinutes(t); string aptime = span.ToString(@"hh\:mm"); DataTable dtcid = new DataTable(); dtcid = smscontroller.GetCustIDByUsingQueueno(smsview); foreach (DataRow drcid in dtcid.Rows) { smsview.CustId = (Convert.ToInt32(drcid["visit_customer_id"].ToString())); string strmsg1 = "Your Queue NO:" + QueueToken + " is in waiting state.\r\nYou are the next person to be served.Approximate waiting time " + aptime + " Hours\r\nplease proceed to the waiting area."; //URL = "http://sms.proactivesms.in/sendsms.jsp?user=attsystm&password=attsystm&mobiles=" + PhoneNumber + "&sms=" + strmsg1 + "&senderid=ATTIPL"; //URL = "https://api.aussiesms.com.au/?sendsms&mobileID=61422889101&password=att0424&to=" + PhoneNumber + "&text=" + strmsg1 + "&from=QSoft&msg_type=SMS_TEXT"; // URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&from=Qsoft&to=" + PhoneNumber + "&text=" + strmsg1 + ""; //bytHeaders = System.Text.ASCIIEncoding.UTF8.GetBytes("*****@*****.**" + ":" + "EqMs2015"); //oWeb.Headers.Add("Authorization", "Basic " + Convert.ToBase64String(bytHeaders)); //oWeb.Headers.Add("Content-Type", "text/plain;charset=utf-8"); ////string URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&api=1&to=" + MissedPhoneNo + "&text=" + strmsg1 + ""; //URL = "https://tim.telstra.com/cgphttp/servlet/[email protected]&Password=Qsoft123&destination=" + PhoneNumber + "&text=" + strmsg1 + ""; //SmsStatusMsg = client.DownloadString(URL); //SmsStatusMsg = SmsStatusMsg.Replace("\r\n", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\t", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\n", ""); //XmlDocument xml = new XmlDocument(); //xml.LoadXml(SmsStatusMsg); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); //XmlNodeList xnList = xml.SelectNodes("smslist"); //foreach (XmlNode xn in xnList) //{ // XmlNode example = xn.SelectSingleNode("sms"); // if (example != null) // { // string na = example["messageid"].InnerText; // string no = example["smsclientid"].InnerText; // string mobileno = example["mobile-no"].InnerText; // string URL1 = "http://sms.proactivesms.in/getDLR.jsp?userid=attsystm&password=attsystm&messageid=" + na + "redownload=yes&responce type=xml"; // SmsDeliveryStatus = client.DownloadString(URL1); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\r\n", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\t", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\n", ""); // XmlDocument xml1 = new XmlDocument(); // xml.LoadXml(SmsDeliveryStatus); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); // //XmlNodeList xnList1 = xml.SelectNodes("response"); // //foreach (XmlNode xn1 in xnList1) // //{ // XmlNode example1 = xml.SelectSingleNode("response"); // if (example1 != null) // { // //string rscode = example1["responsecode"].InnerText; // smsview.DeliveryReport = example1["resposedescription"].InnerText; // //string dlrcount = example1["dlristcount"].InnerText; // //string pendingcount = example1["pendingdrcount"].InnerText; // } // } //} #region Samsung SMS gateway //SMS for Samsung gateway // Set the username of the account holder. Messaging.MessageController.UserAccount.User = "******"; // Set the password of the account holder. Messaging.MessageController.UserAccount.Password = "******"; // Set the first name of the account holder (optional). Messaging.MessageController.UserAccount.ContactFirstName = "David"; // Set the last name of the account holder (optional). Messaging.MessageController.UserAccount.ContactLastName = "Smith"; // Set the mobile phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactPhone = "0423612367"; // Set the landline phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactLandLine = "0338901234"; // Set the contact email of the account holder (optional). Messaging.MessageController.UserAccount.ContactEmail = "*****@*****.**"; // Set the country of origin of the account holder (optional). Messaging.MessageController.UserAccount.Country = Countries.Australia; bool testOK = false; try { // Test the user account settings. Account testAccount = Messaging.MessageController.UserAccount; testOK = Messaging.MessageController.TestAccount(testAccount); } catch (Exception ex) { // An exception was thrown. Display the details of the exception and return. string message = "There was an error testing the connection details:\n" + ex.Message; // MessageBox.Show(this, message, "Connection Failed", MessageBoxButtons.OK); return; } if (testOK) { // The user account settings were valid. Display a success message // box with the number of credits. int balance = Messaging.MessageController.UserAccount.Balance; string message = string.Format("You have {0} message credits available.", balance); // MessageBox.Show(this, message, "Connection Succeeded", MessageBoxButtons.OK); } else { // The username or password were incorrect. Display a failed message box. // MessageBox.Show(this, "The username or password you entered were incorrect.", // "Connection Failed", MessageBoxButtons.OK); } Messaging.MessageController.Settings.TimeOut = 60; // Set the batch size (number of messages to be sent at once) to 200. Messaging.MessageController.Settings.BatchSize = 200; //string strmsg = "To confirm an appointment with the Samsung Experience Store,\r\nyou will need 4 characters password. The password is " + strrandom + ""; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi" + " " + Cname + ",Your ticket number is:" + QueueTokenGenerationSMS + " . Thanks"; //"Hi Kara, your ticket number is 040, Approximate waiting time is 00:40 minutes/hours” Messaging.MessageController.Settings.DeliveryReport = true; //SMSMessage smsobj = new SMSMessage(MissedPhoneNo, strmsg); //Messaging.MessageController.AddToQueue(smsobj); Messaging.MessageController.SendMessages(); //end of Samsung SMS #endregion Samsung SMS gateway if (SmsStatusMsg.Contains("<br>")) { SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", "); } smsview.QueueNo = QueueToken; DateTime dattime = System.DateTime.Now; smsview.SMSDateTime = dattime; smsview.SMSStatusFlag = "R"; smsview.Message = strmsg1; smsview.PhoneNo = PhoneNumber; smscontroller.GetInsertReplySMS(smsview); } } } } } } } } catch (WebException e1) { SmsStatusMsg = e1.Message; } catch (Exception e2) { SmsStatusMsg = e2.Message; } //smsview.InsmsStatus = "S"; //dtinsms = smscontroller.GetIncomingSMS(smsview); //smsview.MySms = (Convert.ToString(dr["incomingsms"].ToString())); //flagupdate = smscontroller.GetsmsStatusFlag(smsview); } else if (smsview.QueueStatusID == 2) { try { DataTable dtcid = new DataTable(); dtcid = smscontroller.GetCustIDByUsingQueueno(smsview); foreach (DataRow drcid in dtcid.Rows) { smsview.CustId = (Convert.ToInt32(drcid["visit_customer_id"].ToString())); string strmsg1 = "Thank you for asking your Q status...\r\nYour Queue NO:" + QueueToken + " is Serving"; //URL = "http://sms.proactivesms.in/sendsms.jsp?user=attsystm&password=attsystm&mobiles=" + PhoneNumber + "&sms=" + strmsg1 + "&senderid=ATTIPL"; //URL = "https://api.aussiesms.com.au/?sendsms&mobileID=61422889101&password=att0424&to=" + PhoneNumber + "&text=" + strmsg1 + "&from=QSoft&msg_type=SMS_TEXT"; // URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&from=Qsoft&to=" + PhoneNumber + "&text=" + strmsg1 + ""; //bytHeaders = System.Text.ASCIIEncoding.UTF8.GetBytes("*****@*****.**" + ":" + "EqMs2015"); //oWeb.Headers.Add("Authorization", "Basic " + Convert.ToBase64String(bytHeaders)); //oWeb.Headers.Add("Content-Type", "text/plain;charset=utf-8"); ////string URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&api=1&to=" + MissedPhoneNo + "&text=" + strmsg1 + ""; //URL = "https://tim.telstra.com/cgphttp/servlet/[email protected]&Password=Qsoft123&destination=" + PhoneNumber + "&text=" + strmsg1 + ""; // SmsStatusMsg = client.DownloadString(URL); //SmsStatusMsg = SmsStatusMsg.Replace("\r\n", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\t", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\n", ""); //XmlDocument xml = new XmlDocument(); //xml.LoadXml(SmsStatusMsg); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); //XmlNodeList xnList = xml.SelectNodes("smslist"); //foreach (XmlNode xn in xnList) //{ // XmlNode example = xn.SelectSingleNode("sms"); // if (example != null) // { // string na = example["messageid"].InnerText; // string no = example["smsclientid"].InnerText; // string mobileno = example["mobile-no"].InnerText; // string URL1 = "http://sms.proactivesms.in/getDLR.jsp?userid=attsystm&password=attsystm&messageid=" + na + "redownload=yes&responce type=xml"; // SmsDeliveryStatus = client.DownloadString(URL1); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\r\n", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\t", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\n", ""); // XmlDocument xml1 = new XmlDocument(); // xml.LoadXml(SmsDeliveryStatus); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); // //XmlNodeList xnList1 = xml.SelectNodes("response"); // //foreach (XmlNode xn1 in xnList1) // //{ // XmlNode example1 = xml.SelectSingleNode("response"); // if (example1 != null) // { // //string rscode = example1["responsecode"].InnerText; // smsview.DeliveryReport = example1["resposedescription"].InnerText; // //string dlrcount = example1["dlristcount"].InnerText; // //string pendingcount = example1["pendingdrcount"].InnerText; // } // } // } #region Samsung SMS gateway //SMS for Samsung gateway // Set the username of the account holder. Messaging.MessageController.UserAccount.User = "******"; // Set the password of the account holder. Messaging.MessageController.UserAccount.Password = "******"; // Set the first name of the account holder (optional). Messaging.MessageController.UserAccount.ContactFirstName = "David"; // Set the last name of the account holder (optional). Messaging.MessageController.UserAccount.ContactLastName = "Smith"; // Set the mobile phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactPhone = "0423612367"; // Set the landline phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactLandLine = "0338901234"; // Set the contact email of the account holder (optional). Messaging.MessageController.UserAccount.ContactEmail = "*****@*****.**"; // Set the country of origin of the account holder (optional). Messaging.MessageController.UserAccount.Country = Countries.Australia; bool testOK = false; try { // Test the user account settings. Account testAccount = Messaging.MessageController.UserAccount; testOK = Messaging.MessageController.TestAccount(testAccount); } catch (Exception ex) { // An exception was thrown. Display the details of the exception and return. string message = "There was an error testing the connection details:\n" + ex.Message; // MessageBox.Show(this, message, "Connection Failed", MessageBoxButtons.OK); return; } if (testOK) { // The user account settings were valid. Display a success message // box with the number of credits. int balance = Messaging.MessageController.UserAccount.Balance; string message = string.Format("You have {0} message credits available.", balance); // MessageBox.Show(this, message, "Connection Succeeded", MessageBoxButtons.OK); } else { // The username or password were incorrect. Display a failed message box. // MessageBox.Show(this, "The username or password you entered were incorrect.", // "Connection Failed", MessageBoxButtons.OK); } Messaging.MessageController.Settings.TimeOut = 60; // Set the batch size (number of messages to be sent at once) to 200. Messaging.MessageController.Settings.BatchSize = 200; //string strmsg = "To confirm an appointment with the Samsung Experience Store,\r\nyou will need 4 characters password. The password is " + strrandom + ""; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi" + " " + Cname + ",Your ticket number is:" + QueueTokenGenerationSMS + " . Thanks"; //"Hi Kara, your ticket number is 040, Approximate waiting time is 00:40 minutes/hours” Messaging.MessageController.Settings.DeliveryReport = true; //SMSMessage smsobj = new SMSMessage(MissedPhoneNo, strmsg); //Messaging.MessageController.AddToQueue(smsobj); Messaging.MessageController.SendMessages(); //end of Samsung SMS #endregion Samsung SMS gateway if (SmsStatusMsg.Contains("<br>")) { SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", "); } smsview.QueueNo = QueueToken; DateTime dattime = System.DateTime.Now; smsview.SMSDateTime = dattime; smsview.SMSStatusFlag = "R"; smsview.Message = strmsg1; smsview.PhoneNo = PhoneNumber; smscontroller.GetInsertReplySMS(smsview); } } catch (WebException e1) { SmsStatusMsg = e1.Message; } catch (Exception e2) { SmsStatusMsg = e2.Message; } //smsview.InsmsStatus = "S"; //dtinsms = smscontroller.GetIncomingSMS(smsview); //smsview.MySms = (Convert.ToString(dr["incomingsms"].ToString())); //flagupdate = smscontroller.GetsmsStatusFlag(smsview); } else if (smsview.QueueStatusID == 3) { try { DataTable dtcid = new DataTable(); dtcid = smscontroller.GetCustIDByUsingQueueno(smsview); foreach (DataRow drcid in dtcid.Rows) { string strmsg1 = "Thank you for asking your Q status...\r\nYour Queue NO:" + QueueToken + " is Ended\r\nThank you, Please visit again"; //URL = "http://sms.proactivesms.in/sendsms.jsp?user=attsystm&password=attsystm&mobiles=" + PhoneNumber + "&sms=" + strmsg1 + "&senderid=ATTIPL"; //URL = "https://api.aussiesms.com.au/?sendsms&mobileID=61422889101&password=att0424&to=" + PhoneNumber + "&text=" + strmsg1 + "&from=QSoft&msg_type=SMS_TEXT"; // URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&from=Qsoft&to=" + PhoneNumber + "&text=" + strmsg1 + ""; //bytHeaders = System.Text.ASCIIEncoding.UTF8.GetBytes("*****@*****.**" + ":" + "EqMs2015"); //oWeb.Headers.Add("Authorization", "Basic " + Convert.ToBase64String(bytHeaders)); //oWeb.Headers.Add("Content-Type", "text/plain;charset=utf-8"); ////string URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&api=1&to=" + MissedPhoneNo + "&text=" + strmsg1 + ""; //URL = "https://tim.telstra.com/cgphttp/servlet/[email protected]&Password=Qsoft123&destination=" + PhoneNumber + "&text=" + strmsg1 + ""; // SmsStatusMsg = client.DownloadString(URL); //SmsStatusMsg = SmsStatusMsg.Replace("\r\n", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\t", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\n", ""); //XmlDocument xml = new XmlDocument(); //xml.LoadXml(SmsStatusMsg); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); //XmlNodeList xnList = xml.SelectNodes("smslist"); //foreach (XmlNode xn in xnList) //{ // XmlNode example = xn.SelectSingleNode("sms"); // if (example != null) // { // string na = example["messageid"].InnerText; // string no = example["smsclientid"].InnerText; // string mobileno = example["mobile-no"].InnerText; // string URL1 = "http://sms.proactivesms.in/getDLR.jsp?userid=attsystm&password=attsystm&messageid=" + na + "redownload=yes&responce type=xml"; // SmsDeliveryStatus = client.DownloadString(URL1); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\r\n", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\t", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\n", ""); // XmlDocument xml1 = new XmlDocument(); // xml.LoadXml(SmsDeliveryStatus); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); // //XmlNodeList xnList1 = xml.SelectNodes("response"); // //foreach (XmlNode xn1 in xnList1) // //{ // XmlNode example1 = xml.SelectSingleNode("response"); // if (example1 != null) // { // //string rscode = example1["responsecode"].InnerText; // smsview.DeliveryReport = example1["resposedescription"].InnerText; // //string dlrcount = example1["dlristcount"].InnerText; // //string pendingcount = example1["pendingdrcount"].InnerText; // } // } //} #region Samsung SMS gateway //SMS for Samsung gateway // Set the username of the account holder. Messaging.MessageController.UserAccount.User = "******"; // Set the password of the account holder. Messaging.MessageController.UserAccount.Password = "******"; // Set the first name of the account holder (optional). Messaging.MessageController.UserAccount.ContactFirstName = "David"; // Set the last name of the account holder (optional). Messaging.MessageController.UserAccount.ContactLastName = "Smith"; // Set the mobile phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactPhone = "0423612367"; // Set the landline phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactLandLine = "0338901234"; // Set the contact email of the account holder (optional). Messaging.MessageController.UserAccount.ContactEmail = "*****@*****.**"; // Set the country of origin of the account holder (optional). Messaging.MessageController.UserAccount.Country = Countries.Australia; bool testOK = false; try { // Test the user account settings. Account testAccount = Messaging.MessageController.UserAccount; testOK = Messaging.MessageController.TestAccount(testAccount); } catch (Exception ex) { // An exception was thrown. Display the details of the exception and return. string message = "There was an error testing the connection details:\n" + ex.Message; // MessageBox.Show(this, message, "Connection Failed", MessageBoxButtons.OK); return; } if (testOK) { // The user account settings were valid. Display a success message // box with the number of credits. int balance = Messaging.MessageController.UserAccount.Balance; string message = string.Format("You have {0} message credits available.", balance); // MessageBox.Show(this, message, "Connection Succeeded", MessageBoxButtons.OK); } else { // The username or password were incorrect. Display a failed message box. // MessageBox.Show(this, "The username or password you entered were incorrect.", // "Connection Failed", MessageBoxButtons.OK); } Messaging.MessageController.Settings.TimeOut = 60; // Set the batch size (number of messages to be sent at once) to 200. Messaging.MessageController.Settings.BatchSize = 200; //string strmsg = "To confirm an appointment with the Samsung Experience Store,\r\nyou will need 4 characters password. The password is " + strrandom + ""; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi" + " " + Cname + ",Your ticket number is:" + QueueTokenGenerationSMS + " . Thanks"; //"Hi Kara, your ticket number is 040, Approximate waiting time is 00:40 minutes/hours” Messaging.MessageController.Settings.DeliveryReport = true; //SMSMessage smsobj = new SMSMessage(MissedPhoneNo, strmsg); //Messaging.MessageController.AddToQueue(smsobj); Messaging.MessageController.SendMessages(); //end of Samsung SMS #endregion Samsung SMS gateway if (SmsStatusMsg.Contains("<br>")) { SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", "); } smsview.QueueNo = QueueToken; DateTime dattime = System.DateTime.Now; smsview.SMSDateTime = dattime; smsview.SMSStatusFlag = "R"; smsview.Message = strmsg1; smsview.PhoneNo = PhoneNumber; smscontroller.GetInsertReplySMS(smsview); } } catch (WebException e1) { SmsStatusMsg = e1.Message; } catch (Exception e2) { SmsStatusMsg = e2.Message; } //smsview.InsmsStatus = "S"; //dtinsms = smscontroller.GetIncomingSMS(smsview); //smsview.MySms = (Convert.ToString(dr["incomingsms"].ToString())); //flagupdate = smscontroller.GetsmsStatusFlag(smsview); } else if (smsview.QueueStatusID == 4) { try { DataTable dtcid = new DataTable(); dtcid = smscontroller.GetCustIDByUsingQueueno(smsview); foreach (DataRow drcid in dtcid.Rows) { string strmsg1 = "Thank you for asking your Q status...\r\nYour Queue is missed. Please contact reception for assistance."; //URL = "http://sms.proactivesms.in/sendsms.jsp?user=attsystm&password=attsystm&mobiles=" + PhoneNumber + "&sms=" + strmsg1 + "&senderid=ATTIPL"; //URL = "https://api.aussiesms.com.au/?sendsms&mobileID=61422889101&password=att0424&to=" + PhoneNumber + "&text=" + strmsg1 + "&from=QSoft&msg_type=SMS_TEXT"; //URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&from=Qsoft&to=" + PhoneNumber + "&text=" + strmsg1 + ""; //bytHeaders = System.Text.ASCIIEncoding.UTF8.GetBytes("*****@*****.**" + ":" + "EqMs2015"); //oWeb.Headers.Add("Authorization", "Basic " + Convert.ToBase64String(bytHeaders)); //oWeb.Headers.Add("Content-Type", "text/plain;charset=utf-8"); ////string URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&api=1&to=" + MissedPhoneNo + "&text=" + strmsg1 + ""; //URL = "https://tim.telstra.com/cgphttp/servlet/[email protected]&Password=Qsoft123&destination=" + PhoneNumber + "&text=" + strmsg1 + ""; // SmsStatusMsg = client.DownloadString(URL); //SmsStatusMsg = SmsStatusMsg.Replace("\r\n", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\t", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\n", ""); //XmlDocument xml = new XmlDocument(); //xml.LoadXml(SmsStatusMsg); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); //XmlNodeList xnList = xml.SelectNodes("smslist"); //foreach (XmlNode xn in xnList) //{ // XmlNode example = xn.SelectSingleNode("sms"); // if (example != null) // { // string na = example["messageid"].InnerText; // string no = example["smsclientid"].InnerText; // string mobileno = example["mobile-no"].InnerText; // string URL1 = "http://sms.proactivesms.in/getDLR.jsp?userid=attsystm&password=attsystm&messageid=" + na + "redownload=yes&responce type=xml"; // SmsDeliveryStatus = client.DownloadString(URL1); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\r\n", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\t", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\n", ""); // XmlDocument xml1 = new XmlDocument(); // xml.LoadXml(SmsDeliveryStatus); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); // //XmlNodeList xnList1 = xml.SelectNodes("response"); // //foreach (XmlNode xn1 in xnList1) // //{ // XmlNode example1 = xml.SelectSingleNode("response"); // if (example1 != null) // { // //string rscode = example1["responsecode"].InnerText; // smsview.DeliveryReport = example1["resposedescription"].InnerText; // //string dlrcount = example1["dlristcount"].InnerText; // //string pendingcount = example1["pendingdrcount"].InnerText; // } // } //} #region Samsung SMS gateway //SMS for Samsung gateway // Set the username of the account holder. Messaging.MessageController.UserAccount.User = "******"; // Set the password of the account holder. Messaging.MessageController.UserAccount.Password = "******"; // Set the first name of the account holder (optional). Messaging.MessageController.UserAccount.ContactFirstName = "David"; // Set the last name of the account holder (optional). Messaging.MessageController.UserAccount.ContactLastName = "Smith"; // Set the mobile phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactPhone = "0423612367"; // Set the landline phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactLandLine = "0338901234"; // Set the contact email of the account holder (optional). Messaging.MessageController.UserAccount.ContactEmail = "*****@*****.**"; // Set the country of origin of the account holder (optional). Messaging.MessageController.UserAccount.Country = Countries.Australia; bool testOK = false; try { // Test the user account settings. Account testAccount = Messaging.MessageController.UserAccount; testOK = Messaging.MessageController.TestAccount(testAccount); } catch (Exception ex) { // An exception was thrown. Display the details of the exception and return. string message = "There was an error testing the connection details:\n" + ex.Message; // MessageBox.Show(this, message, "Connection Failed", MessageBoxButtons.OK); return; } if (testOK) { // The user account settings were valid. Display a success message // box with the number of credits. int balance = Messaging.MessageController.UserAccount.Balance; string message = string.Format("You have {0} message credits available.", balance); // MessageBox.Show(this, message, "Connection Succeeded", MessageBoxButtons.OK); } else { // The username or password were incorrect. Display a failed message box. // MessageBox.Show(this, "The username or password you entered were incorrect.", // "Connection Failed", MessageBoxButtons.OK); } Messaging.MessageController.Settings.TimeOut = 60; // Set the batch size (number of messages to be sent at once) to 200. Messaging.MessageController.Settings.BatchSize = 200; //string strmsg = "To confirm an appointment with the Samsung Experience Store,\r\nyou will need 4 characters password. The password is " + strrandom + ""; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi" + " " + Cname + ",Your ticket number is:" + QueueTokenGenerationSMS + " . Thanks"; //"Hi Kara, your ticket number is 040, Approximate waiting time is 00:40 minutes/hours” Messaging.MessageController.Settings.DeliveryReport = true; //SMSMessage smsobj = new SMSMessage(MissedPhoneNo, strmsg); //Messaging.MessageController.AddToQueue(smsobj); Messaging.MessageController.SendMessages(); //end of Samsung SMS #endregion Samsung SMS gateway if (SmsStatusMsg.Contains("<br>")) { SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", "); } smsview.QueueNo = QueueToken; DateTime dattime = System.DateTime.Now; smsview.SMSDateTime = dattime; smsview.SMSStatusFlag = "R"; smsview.Message = strmsg1; smsview.PhoneNo = PhoneNumber; smscontroller.GetInsertReplySMS(smsview); } } catch (WebException e1) { SmsStatusMsg = e1.Message; } catch (Exception e2) { SmsStatusMsg = e2.Message; } //smsview.InsmsStatus = "S"; //dtinsms = smscontroller.GetIncomingSMS(smsview); //smsview.MySms = (Convert.ToString(dr["incomingsms"].ToString())); //flagupdate = smscontroller.GetsmsStatusFlag(smsview); } else if (smsview.QueueStatusID == 5) { try { DataTable dtcid = new DataTable(); dtcid = smscontroller.GetCustIDByUsingQueueno(smsview); foreach (DataRow drcid in dtcid.Rows) { string strmsg1 = "Thank you for asking your Q status...\r\nYour Queue is On hold"; //URL = "http://sms.proactivesms.in/sendsms.jsp?user=attsystm&password=attsystm&mobiles=" + PhoneNumber + "&sms=" + strmsg1 + "&senderid=ATTIPL"; //URL = "https://api.aussiesms.com.au/?sendsms&mobileID=61422889101&password=att0424&to=" + PhoneNumber + "&text=" + strmsg1 + "&from=QSoft&msg_type=SMS_TEXT"; // URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&from=Qsoft&to=" + PhoneNumber + "&text=" + strmsg1 + ""; //bytHeaders = System.Text.ASCIIEncoding.UTF8.GetBytes("*****@*****.**" + ":" + "EqMs2015"); //oWeb.Headers.Add("Authorization", "Basic " + Convert.ToBase64String(bytHeaders)); //oWeb.Headers.Add("Content-Type", "text/plain;charset=utf-8"); ////string URL = "http://www.smsglobal.com/http-api.php?action=sendsms&user=yahtz6o2&password=46yAfp0i&api=1&to=" + MissedPhoneNo + "&text=" + strmsg1 + ""; //URL = "https://tim.telstra.com/cgphttp/servlet/[email protected]&Password=Qsoft123&destination=" + PhoneNumber + "&text=" + strmsg1 + ""; // SmsStatusMsg = client.DownloadString(URL); //SmsStatusMsg = SmsStatusMsg.Replace("\r\n", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\t", ""); //SmsStatusMsg = SmsStatusMsg.Replace("\n", ""); //XmlDocument xml = new XmlDocument(); //xml.LoadXml(SmsStatusMsg); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); //XmlNodeList xnList = xml.SelectNodes("smslist"); //foreach (XmlNode xn in xnList) //{ // XmlNode example = xn.SelectSingleNode("sms"); // if (example != null) // { // string na = example["messageid"].InnerText; // string no = example["smsclientid"].InnerText; // string mobileno = example["mobile-no"].InnerText; // string URL1 = "http://sms.proactivesms.in/getDLR.jsp?userid=attsystm&password=attsystm&messageid=" + na + "redownload=yes&responce type=xml"; // SmsDeliveryStatus = client.DownloadString(URL1); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\r\n", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\t", ""); // SmsDeliveryStatus = SmsDeliveryStatus.Replace("\n", ""); // XmlDocument xml1 = new XmlDocument(); // xml.LoadXml(SmsDeliveryStatus); //myXmlString is the xml file in string //copying xml to string: string myXmlString = xmldoc.OuterXml.ToString(); // //XmlNodeList xnList1 = xml.SelectNodes("response"); // //foreach (XmlNode xn1 in xnList1) // //{ // XmlNode example1 = xml.SelectSingleNode("response"); // if (example1 != null) // { // //string rscode = example1["responsecode"].InnerText; // smsview.DeliveryReport = example1["resposedescription"].InnerText; // //string dlrcount = example1["dlristcount"].InnerText; // //string pendingcount = example1["pendingdrcount"].InnerText; // } // } //} #region Samsung SMS gateway //SMS for Samsung gateway // Set the username of the account holder. Messaging.MessageController.UserAccount.User = "******"; // Set the password of the account holder. Messaging.MessageController.UserAccount.Password = "******"; // Set the first name of the account holder (optional). Messaging.MessageController.UserAccount.ContactFirstName = "David"; // Set the last name of the account holder (optional). Messaging.MessageController.UserAccount.ContactLastName = "Smith"; // Set the mobile phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactPhone = "0423612367"; // Set the landline phone number of the account holder (optional). Messaging.MessageController.UserAccount.ContactLandLine = "0338901234"; // Set the contact email of the account holder (optional). Messaging.MessageController.UserAccount.ContactEmail = "*****@*****.**"; // Set the country of origin of the account holder (optional). Messaging.MessageController.UserAccount.Country = Countries.Australia; bool testOK = false; try { // Test the user account settings. Account testAccount = Messaging.MessageController.UserAccount; testOK = Messaging.MessageController.TestAccount(testAccount); } catch (Exception ex) { // An exception was thrown. Display the details of the exception and return. string message = "There was an error testing the connection details:\n" + ex.Message; // MessageBox.Show(this, message, "Connection Failed", MessageBoxButtons.OK); return; } if (testOK) { // The user account settings were valid. Display a success message // box with the number of credits. int balance = Messaging.MessageController.UserAccount.Balance; string message = string.Format("You have {0} message credits available.", balance); // MessageBox.Show(this, message, "Connection Succeeded", MessageBoxButtons.OK); } else { // The username or password were incorrect. Display a failed message box. // MessageBox.Show(this, "The username or password you entered were incorrect.", // "Connection Failed", MessageBoxButtons.OK); } Messaging.MessageController.Settings.TimeOut = 60; // Set the batch size (number of messages to be sent at once) to 200. Messaging.MessageController.Settings.BatchSize = 200; //string strmsg = "To confirm an appointment with the Samsung Experience Store,\r\nyou will need 4 characters password. The password is " + strrandom + ""; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi " + " " + Cname + ", To finalize your appointment with the Samsung Experience Store at Sydney Central Plaza,\r\nplease enter these 4 characters" + strrandom + "password on the Confirmation screen. Thank you"; //string strmsg = "Hi" + " " + Cname + ",Your ticket number is:" + QueueTokenGenerationSMS + " . Thanks"; //"Hi Kara, your ticket number is 040, Approximate waiting time is 00:40 minutes/hours” Messaging.MessageController.Settings.DeliveryReport = true; //SMSMessage smsobj = new SMSMessage(MissedPhoneNo, strmsg); //Messaging.MessageController.AddToQueue(smsobj); Messaging.MessageController.SendMessages(); //end of Samsung SMS #endregion Samsung SMS gateway if (SmsStatusMsg.Contains("<br>")) { SmsStatusMsg = SmsStatusMsg.Replace("<br>", ", "); } smsview.QueueNo = QueueToken; DateTime dattime = System.DateTime.Now; smsview.SMSDateTime = dattime; smsview.SMSStatusFlag = "R"; smsview.Message = strmsg1; smsview.PhoneNo = PhoneNumber; smscontroller.GetInsertReplySMS(smsview); } } catch (WebException e1) { SmsStatusMsg = e1.Message; } catch (Exception e2) { SmsStatusMsg = e2.Message; } //smsview.InsmsStatus = "S"; //dtinsms = smscontroller.GetIncomingSMS(smsview); //smsview.MySms = (Convert.ToString(dr["incomingsms"].ToString())); //flagupdate = smscontroller.GetsmsStatusFlag(smsview); } } } } }