protected void btnPrint_Click(object sender, EventArgs e)
{
// log the print activity
RunStoredProcedure rsp = new RunStoredProcedure();
try
{
rsp.Log(3, Int32.Parse(Session["LinkRId"].ToString()));
}
catch { }
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "var Mleft = (screen.width/2)-(760/2);var Mtop = (screen.height/2)-(700/2);window.open( '/Web_Forms/PrintReport.aspx?LinkReport=1&ReportName=" + Request.QueryString["ReportName"].ToString() + "&Version=" + Request.QueryString["Version"].ToString() + "', null, 'height=2,width=2,status=yes,toolbar=no,scrollbars=yes,menubar=no,location=no,top=\'+Mtop+\', left=\'+Mleft+\'' );", true);
if (!string.IsNullOrEmpty(Session["LinkAuditVersion"].ToString()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "closeWindow", "closeWindow();", true);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SearchReport.CreateReportReset(); // takes off the selected report in ddlCreateReport
// get the last Report ID
string query = "SELECT MAX(ReportId) AS ReportId FROM dbo.Report_MerrylandsRSLReception";
int lastRId, result, returnFlag = 2;
DateTime temp, date = DateTime.Parse(DateTime.Now.ToShortDateString());
Report.ErrorMessage = "";
con.Open();
SqlCommand getRId = new SqlCommand(query, con);
try
{
lastRId = (int)getRId.ExecuteScalar();
// add plus one to the current report id to be used in this report
lastRId += 1;
}
catch
{
lastRId = 6000001;
}
con.Close();
Report.LastReportId = lastRId.ToString();
if (txtDatePicker.Text == "")
{
Report.ErrorMessage = Report.ErrorMessage + "\\n* Shift Date shouldn't be empty.";
txtDatePicker.Focus();
returnFlag = 1;
}
else if (!DateTime.TryParse(txtDatePicker.Text, out temp))
{
Report.ErrorMessage = Report.ErrorMessage + "\\n* Shifts Date entry is not in date format please select an appropriate date.";
txtDatePicker.Focus();
returnFlag = 1;
}
else if (DateTime.TryParse(txtDatePicker.Text, out temp))
{
// compare selected date to current date
result = DateTime.Compare(DateTime.Parse(DateTime.Parse(txtDatePicker.Text).ToShortDateString()), date);
if (result > 0)
{
Report.ErrorMessage = Report.ErrorMessage + "\\n* DATE MUST BE BEFORE CURRENT DATE.";
txtDatePicker.Focus();
returnFlag = 1;
}
}
//if (txtSpecialComments.Text == "")
//{
// Report.ErrorMessage = Report.ErrorMessage + "\\n* COVID-19 section shouldn't be empty.";
// txtSpecialComments.Focus();
// returnFlag = 1;
//}
if (returnFlag == 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", "alert(\"" + Report.ErrorMessage + "\");", true);
return;
}
// change the format of the shift date to timestamp format
DateTime shift_date = DateTime.Parse(txtDatePicker.Text);
string shift_tDate = shift_date.ToString("yyyyMMdd");
// separate the shift date day of week value
string shift_DOW = shift_date.DayOfWeek.ToString();
// change the format of the entry date to timestamp format
DateTime entry_date = DateTime.Now;
// pop a message if shift is unchanged
if (ddlShift.SelectedItem.Value == "-1")
{
showAlert("Please select Shift.");
ddlShift.Focus();
return;
}
// get staff's id
string cmdText = "SELECT StaffId FROM Staff WHERE Username = '******'",
variable = "getStaff";
readFiles(cmdText, variable);
// insert data to table
using (DataClassesDataContext dc = new DataClassesDataContext())
{
Report_MerrylandsRSLReception dm = new Report_MerrylandsRSLReception();
dm.ReportId = Int32.Parse(Report.LastReportId);
dm.RCatId = 6; // MR Reception Category
dm.StaffId = Int32.Parse(Session["currentStaffId"].ToString());
dm.StaffName = UserCredentials.DisplayName;
dm.ShiftId = Int32.Parse(ddlShift.SelectedItem.Value);
dm.ShiftDate = shift_date.Date;
dm.ShiftDOW = shift_DOW;
dm.EntryDate = entry_date;
dm.Report_Table = "Report_MerrylandsRSLReception";
dm.AuditVersion = 1;
dm.ReportStat = "Awaiting Completion";
dm.Report_Version = 2; // current version
dm.ReadByList = "," + UserCredentials.StaffId + ",";
dm.SignInSlip = txtSignInSlip.Text.Replace("\n", "<br />").Replace("'", "^");
dm.Refusals = txtRefusals.Text.Replace("\n", "<br />").Replace("'", "^");
dm.EventsField = txtEventsField.Text.Replace("\n", "<br />").Replace("'", "^");
dm.GeneralComments = txtGeneralComms.Text.Replace("\n", "<br />").Replace("'", "^");
dm.SpecialComments = txtSpecialComments.Text.Replace("\n", "<br />").Replace("'", "^");
dc.Report_MerrylandsRSLReceptions.InsertOnSubmit(dm);
dc.SubmitChanges();
}
//log the create activity
RunStoredProcedure rsp = new RunStoredProcedure();
try
{
rsp.Log(4, Int32.Parse(Report.LastReportId));
}
catch { }
//showAlert("Report Submitted.");
//Response.Redirect("Default.aspx", false);
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect",
"alert('Report Submitted.'); window.location='" +
Request.ApplicationPath + "Default.aspx';", true);
SearchReport.SetAccordion = "1";
SearchReport.RunOnStart = true;
SearchReport.FromCreateReport = true;
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string groups, displayName;
string[] groupArray;
StringBuilder groupsList = new StringBuilder();
AuthenticateUser authUser = new AuthenticateUser("LDAP://MRSLGROUP");
try
{
using (HostingEnvironment.Impersonate())
{
if (true == authUser.IsAuthenticated("MRSLGROUP", txtUsername.Text, txtPassword.Text)) // check if login details are valid - checking from Active Directory User Account details
{
groups = authUser.GetGroups(txtUsername.Text); // retrieve user groups + display name
groupArray = groups.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
Session["Username"] = txtUsername.Text;
UserCredentials.Username = txtUsername.Text; // record username
displayName = groupArray[groupArray.Length - 1];
Session["DisplayName"] = displayName;
UserCredentials.DisplayName = displayName;
groupArray = groupArray.Take(groupArray.Count() - 1).ToArray(); // delete the last array item (display name), to keep this array variable set to usr groups only
for (int i = 0; i < groupArray.Length; i++)
{
groupsList.Append(groupArray[i]); // store group name
groupsList.Append("|"); // add a back slash delimeter
}
groups = groupsList.ToString(); // set user groups
UserCredentials.Groups = groups;
SqlQuery sqlQuery = new SqlQuery();
string query = "SELECT * FROM Staff WHERE Username = '******'",
data = "CheckStaffExist";
sqlQuery.RetrieveData(query, data); // check if staff is registered in the database
sqlQuery.RetrieveData(query, data); // run this method again just in case the Staff Name has just been created
RunStoredProcedure rsp = new RunStoredProcedure();
// encrypt password
string encryptedPassword = rsp.EncryptPassword(txtPassword.Text);
// update password stored in the database
rsp.UpdatePassword(txtUsername.Text, encryptedPassword);
// log the login activity
try
{
rsp.Log();
}
catch { }
bool isCookiePersistent = false; // Create the ticket, and add the groups.
// set expiration of the authentication ticket - current set: 720 minutes / 12 hours
FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(1, txtUsername.Text, DateTime.Now, DateTime.Now.AddMinutes(720), isCookiePersistent, groups);
string encryptedTicket = FormsAuthentication.Encrypt(authTicket); //Encrypt the ticket.
HttpCookie authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket); //Create a cookie, and then add the encrypted ticket to the cookie as data.
if (true == isCookiePersistent)
{
authCookie.Expires = authTicket.Expiration;
}
Response.Cookies.Add(authCookie); //Add the cookie to the outgoing cookies collection.
Response.Redirect(FormsAuthentication.GetRedirectUrl(txtUsername.Text, false), false); //You can redirect now.
}
else
{
bool passwordGiven = CheckIfPasswordIsGiven();
if (!passwordGiven)
{
errorLabel.Text = "Invalid details. Please check your username and password.";
}
}
}
}
catch (Exception ex)
{
bool passwordGiven = CheckIfPasswordIsGiven();
if (!passwordGiven)
{
errorLabel.Text = "Error logging in user. " + ex.Message;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SearchReport.CreateReportReset(); // takes off the selected report in ddlCreateReport
// get the last Report ID
string query = "SELECT MAX(ReportId) AS ReportId FROM dbo.Report_MerrylandsRSLCaretaker";
int lastRId, result, returnFlag = 2;
DateTime temp, date = DateTime.Parse(DateTime.Now.ToShortDateString());
Report.ErrorMessage = "";
con.Open();
SqlCommand getRId = new SqlCommand(query, con);
try
{
lastRId = (int)getRId.ExecuteScalar();
// add plus one to the current report id to be used in this report
lastRId += 1;
}
catch
{
lastRId = 13000001;
}
con.Close();
Report.LastReportId = lastRId.ToString();
if (txtDatePicker.Text == "")
{
Report.ErrorMessage = Report.ErrorMessage + "\\n* Shift Date shouldn't be empty.";
txtDatePicker.Focus();
returnFlag = 1;
}
else if (!DateTime.TryParse(txtDatePicker.Text, out temp))
{
Report.ErrorMessage = Report.ErrorMessage + "\\n* Shifts Date entry is not in date format please select an appropriate date.";
txtDatePicker.Focus();
returnFlag = 1;
}
else if (DateTime.TryParse(txtDatePicker.Text, out temp))
{
// compare selected date to current date
result = DateTime.Compare(DateTime.Parse(DateTime.Parse(txtDatePicker.Text).ToShortDateString()), date);
if (result > 0)
{
Report.ErrorMessage = Report.ErrorMessage + "\\n* DATE MUST BE BEFORE CURRENT DATE.";
txtDatePicker.Focus();
returnFlag = 1;
}
}
if (returnFlag == 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", "alert(\"" + Report.ErrorMessage + "\");", true);
return;
}
// change the format of the shift date to timestamp format
DateTime shift_date = DateTime.Parse(txtDatePicker.Text);
string shift_tDate = shift_date.ToString("yyyyMMdd");
// separate the shift date day of week value
string shift_DOW = shift_date.DayOfWeek.ToString();
// change the format of the entry date to timestamp format
DateTime entry_date = DateTime.Now;
// pop a message if shift is unchanged
//if (ddlShift.SelectedItem.Value == "-1")
//{
// showAlert("Please select Shift.");
// ddlShift.Focus();
// return;
//}
// get staff's id
string cmdText = "SELECT StaffId FROM Staff WHERE Username = '******'",
variable = "getStaff";
readFiles(cmdText, variable);
// store in a string all the selected item in the checkboxlist
// Create the list to store.
List <String> YrStrList1 = new List <string>();
// Loop through each item.
foreach (ListItem item in List_Location.Items)
{
if (item.Selected)
{
// If the item is selected, add the value to the list.
YrStrList1.Add(item.Value);
}
}
// Join the string together using the ; delimiter.
string Location = String.Join(",", YrStrList1.ToArray());
if (!Location.Equals(""))
{
Location += ",";
}
// insert data to table
using (DataClassesDataContext dc = new DataClassesDataContext())
{
Report_MerrylandsRSLCaretaker dm = new Report_MerrylandsRSLCaretaker();
dm.ReportId = Int32.Parse(Report.LastReportId);
dm.RCatId = 13; // Customer Relations Officer Category
dm.StaffId = Int32.Parse(Session["currentStaffId"].ToString());
//dm.ShiftId = Int32.Parse(ddlShift.SelectedItem.Value);
dm.StaffName = UserCredentials.DisplayName;
dm.ShiftDate = shift_date.Date;
dm.ShiftDOW = shift_DOW;
dm.EntryDate = entry_date;
dm.Report_Table = "Report_MerrylandsRSLCaretaker";
dm.AuditVersion = 1;
dm.ReportStat = "Awaiting Completion";
dm.Report_Version = 1; // current version
dm.ReadByList = "," + UserCredentials.StaffId + ",";
dm.Spare1 = Location;
dm.Occupancy = txtOccupancy.Text.Replace("\n", "<br />").Replace("'", "^");
dm.Maintenance = txtMaintenance.Text.Replace("\n", "<br />").Replace("'", "^");
dm.GeneralComments = txtGeneralComments.Text.Replace("\n", "<br />").Replace("'", "^");
dc.Report_MerrylandsRSLCaretakers.InsertOnSubmit(dm);
dc.SubmitChanges();
}
//log the create activity
RunStoredProcedure rsp = new RunStoredProcedure();
try
{
rsp.Log(4, Int32.Parse(Report.LastReportId));
}
catch { }
//showAlert("Report Submitted.");
//Response.Redirect("Default.aspx", false);
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect",
"alert('Report Submitted.'); window.location='" +
Request.ApplicationPath + "Default.aspx';", true);
SearchReport.SetAccordion = "1";
SearchReport.RunOnStart = true;
SearchReport.FromCreateReport = true;
}