protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
Utilities.SetNoCache(Response);
}
HideErrorMessage();
if (!IsPostBack)
{
PagePermissions.EnforcePermissions_RequireAny(Session, Response, true, true, true, false, false, false);
string displayData = SmsAndEmailBirthdayMessages.Run(true, false, DateTime.Now.Date);
htmlOutput.Text = displayData;
}
}
catch (CustomMessageException ex)
{
if (IsPostBack)
{
SetErrorMessage(ex.Message);
}
else
{
HideTableAndSetErrorMessage(ex.Message);
}
}
catch (Exception ex)
{
if (IsPostBack)
{
SetErrorMessage("", ex.ToString());
}
else
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
}
// http://localhost:2524/SMS/RunBirthdayReminders.aspx?pwd=mah_sms_reminder
// http://localhost:2524/SMS/RunBirthdayReminders.aspx?pwd=mah_sms_reminder&inc_sending=false
// http://portal.mediclinic.com.au:803/SMS/RunBirthdayReminders.aspx?pwd=mah_sms_reminder
// http://portal.mediclinic.com.au:803/SMS/RunBirthdayReminders.aspx?pwd=mah_sms_reminder&inc_sending=false
// can upload and let marcus add booking, view, mobile nbr, view, then try send to his nbr in aus...
#region Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Utilities.SetNoCache(Response);
}
try
{
string pwd = Request.Form["pwd"];
if (pwd != null) // sent by http post
{
if (pwd == null || pwd != System.Configuration.ConfigurationManager.AppSettings["SMSRunRemindersPwd"])
{
throw new CustomMessageException("Incorrect password");
}
string exceptionOutput = string.Empty;
if (Session != null && Session["DB"] != null)
{
SmsAndEmailBirthdayMessages.Run(false, true, DateTime.Now.Date);
}
else
{
if (Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["UseConfigDB"]))
{
Session["DB"] = System.Configuration.ConfigurationManager.AppSettings["Database"];
Session["SystemVariables"] = SystemVariableDB.GetAll();
SmsAndEmailBirthdayMessages.Run(false, true, DateTime.Now.Date);
Session.Remove("DB");
Session.Remove("SystemVariables");
}
else // Get all DB's and run it on all of them
{
System.Data.DataTable tbl = DBBase.ExecuteQuery("EXEC sp_databases;", "master").Tables[0];
for (int i = 0; i < tbl.Rows.Count; i++)
{
string databaseName = tbl.Rows[i][0].ToString();
if (!Regex.IsMatch(databaseName, @"Mediclinic_\d{4}"))
{
continue;
}
try
{
Session["DB"] = databaseName;
Session["SystemVariables"] = SystemVariableDB.GetAll();
SmsAndEmailBirthdayMessages.Run(false, true, DateTime.Now.Date);
}
catch (Exception ex)
{
exceptionOutput += Environment.NewLine + DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss") + " " + "DB: " + databaseName;
exceptionOutput += Environment.NewLine + ex.ToString();
}
finally
{
Session.Remove("DB");
Session.Remove("SystemVariables");
}
}
}
}
if (exceptionOutput.Length > 0)
{
Response.Write("Run Completed But With Errors!");
Response.Write(Environment.NewLine + exceptionOutput);
}
else
{
Response.Write("Run Completed!");
}
}
else // send in url by http get
{
pwd = Request.QueryString["pwd"];
if (pwd == null || pwd != System.Configuration.ConfigurationManager.AppSettings["SMSRunRemindersPwd"])
{
throw new CustomMessageException("Incorrect password");
}
string inc_sending = Request.QueryString["inc_sending"];
if (inc_sending != null && inc_sending != "true" && inc_sending != "false")
{
throw new CustomMessageException("Incorrect inc_sending value");
}
bool incSending = inc_sending != null && inc_sending == "true";
if (Session != null && Session["DB"] != null)
{
string displayData = SmsAndEmailBirthdayMessages.Run(true, incSending, DateTime.Now.Date);
Response.Write(displayData);
}
else
{
if (!Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["UseConfigDB"]))
{
throw new CustomMessageException("Can not run for logged out user where UseConfigDB = false");
}
else
{
Session["DB"] = System.Configuration.ConfigurationManager.AppSettings["Database"];
Session["SystemVariables"] = SystemVariableDB.GetAll();
string displayData = SmsAndEmailBirthdayMessages.Run(true, incSending, DateTime.Now.Date);
Response.Write(displayData);
Session.Remove("DB");
Session.Remove("SystemVariables");
}
}
}
}
catch (CustomMessageException ex)
{
Response.Write(ex.Message);
}
catch (Exception ex)
{
Response.Write("Exception: " + (ex.ToString()));
}
}