public void AppRemender()
{
try
{
DataTable Appdetails = new DataTable();
SMSController smscont = new SMSController();
Appdetails = smscont.AppRemender();
DateTime re = Convert.ToDateTime("07:00");//Every Day at 7:00 AUS Time
//DateTime re = Convert.ToDateTime("23:10");
String ret = re.ToString("hh:mm");
DateTime syst = DateTime.Now;
string systime = syst.ToString("hh:mm");
if (ret == systime)
{
foreach (DataRow dr in Appdetails.Rows)
{
SMSView smsview = new SMSView();
int appid = Convert.ToInt32(dr["appointment_id"].ToString());
int custid = Convert.ToInt32(dr["appointment_customer_id"].ToString());
string cname = dr["customer_firstname"].ToString();
string appt = dr["appointment_time"].ToString();
int centreid = Convert.ToInt32(dr["appointment_centre_id"].ToString());
DateTime apt = Convert.ToDateTime(appt);
string cappt = apt.ToString("HH:mm");
string custaptime = apt.ToShortTimeString();
string mobnum = "61"+ dr["customer_mobile"].ToString();
string centrename;
if (centreid==1)
{
centrename = "Sydney";
}
else if (centreid == 58)
{
centrename = "Melbourne central";
}
else
{
centrename = "Highpoint";
}
string strmsg = "Dear " + cname + ",\r\nReminder your appointment with the Samsung Experience Store, " + centrename + " is at " + cappt + " today.\r\nPlease bring a copy of your purchase invoice and back-up your data before your appointment to avoid data loss, Looking forward to seeing you.";
//“Hi Kara, Reminder your appointment with the Samsung Experience Store, Sydney is at 11:15 today. Please bring a copy of your purchase invoice and back-up your data before your appointment to avoid data loss. Look forward to seeing you.”
smsview.SmsDesc = strmsg;
#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 = true;
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(mobnum, strmsg);
Messaging.MessageController.AddToQueue(smsobj);
Messaging.MessageController.SendMessages();
//end of Samsung SMS
//smsview.SmsUpdatedDateTime = System.DateTime.Now;
//smsview.SmsActive = 'Y';
//smsview.SMSContentTypeId = 1;
//smsview.SmsAlert = 1;
//smsview.SmsUpdatedBy="Admin";
//string i;
//i = smscontroller.getInsertAppointmentAlertSms(smsview);
#endregion Samsung SMS gateway
#region Update SMS_Alert statsus flag
smsview.AppointmentID = appid;
smsview.SMSalert = 'B';
smscont.updatesmsalert(smsview);
#endregion Update SMS_Alert statsus flag
#region inserting to tbl_sms_tnx
smsview.CustId = custid;
smsview.SmsDesc = strmsg;
smsview.PhoneNo = mobnum;
smsview.DeliveryReport = "y";
smsview.SmsDesc = strmsg;
smsview.IncomingsmsFlag = "M";
smsview.SmsVisittnxId = 2;
smsview.SMSDateTime = System.DateTime.Now;
smsview.SMSStatusFlag = "M";
smsview.QueueNo = Convert.ToString("1");
smsview.CentreId = "";
smsview.SMSDateTime = System.DateTime.Now;
string i;
i = smscontroller.getInsertAppointmentAlertSms(smsview);
#endregion into tbl_sms_tnx
}
}
}
catch (Exception ex)
{
throw ex;
}
}