Execute a function on a particular Date

Hello Sir,

I need your help.

I am in function of sms sending on Booking date and on 2 days before of consultation.

Here the function of sending sms:-

private void SendSmS()

{

SqlDataReader rdr = null;

int Day = 2;

try

{

string cnn = ConfigurationManager.ConnectionStrings["MSCon"].ToString();

SqlConnection cn = new SqlConnection(cnn);

cn.Open();

SqlCommand cmd = new SqlCommand("Get_PatientPhoneNo", cn);

cmd.CommandType = CommandType.StoredProcedure;

rdr = cmd.ExecuteReader();

while (rdr.Read())

{

Phone = rdr["PHONE"].ToString();

DoctorName = rdr["DOCTOR"].ToString();

patientName = rdr["PATIENT"].ToString();

bookingDate =Convert.ToDateTime(rdr["DATE"].ToString());

string msgLine = "Dear " + patientName + ",\nYour Consultation with Dr." + DoctorName + " is fixed for " + bookingDate + ".Please ascertain the exact time in advance";

if (VerifyPhoneNumber(Phone))

{

string strCount = SMS(userID, Pswrd, Phone, msgLine, DoctorName, bookingDate, patientName);

if (strCount == "1")

{

UpdatePhoneNo();

}

Reminder = bookingDate.AddDays(-2);

}

catch (Exception ex)

{

MessageBox.Show(ex + "SMS03", "SMS", MessageBoxButtons.OK, MessageBoxIcon.Warning);

}

I just saved the booking date - 2 days into Reminder. And when the reminder value become true, i want to execute the function of sms

Please help me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naveed Zaman12y ago
please check my article
http://www.c-sharpcorner.com/UploadFile/e881fb/send-sms-using-gsm-modem-with-C-Sharp/
Mukesh Nayak12y ago
I think , there should be service running( or worker role) which should check the data from database everyday . We can use quartz scheduler to fire the event once a day. And in that event we can get all the record having Consultation Day - 2 Day is today's day and than we can fire SMS Sending function for all.

Further we can have a column where we can mark weather we have processed the record or not. In that way we can filter the data more.