protected void Page_Load(object sender, EventArgs e) { try { //redirect if not logged in if (Session["Admin"] == null && Session["SuperUser"] == null && Session["User"] == null) { Response.Redirect("~/Login.aspx"); } //Only SuperUser and admin has access to validate if ((Session["SuperUser"] == null && Session["Admin"] == null) || (Session["User"].ToString().StartsWith("SUP") || Session["User"].ToString().StartsWith("ADM"))) { ValidateButton.Visible = false; ReadOnly(); StatusLabel.CssClass = "error paraNormal"; StatusLabel.ForeColor = System.Drawing.Color.Black; if (Session["SuperUser"] == null && Session["Admin"] == null) { StatusLabel.Text = "Note: Meet the system administrator to make modifications"; } else { StatusLabel.Text = "Note: This user cannot be validated here.<br/>Meet the super user for modification."; } } else { ValidateButton.Visible = true; } if (Session["User"].ToString().StartsWith("PAT")) { EduRefTable.Visible = false; //remove eduucation and referee table for patients } if (Session["User"].ToString().StartsWith("DC") || Session["User"].ToString().StartsWith("ST")) { OtherInfoLabel.Text = "About yourself"; } //populate form controls if (!IsPostBack) { string infoQuery = DataProvider.UpdateRegistration.getInfo //get user information from the database (HospitalClass.getTableName(Session["User"].ToString().Substring(0, 2)), Session["User"].ToString()); DataTable dt = HospitalClass.getDataTable(infoQuery); UserIdBox.Text = Session["User"].ToString(); //1 FirstNameBox.Text = DBNull.Value.Equals(dt.Rows[0]["FIRST_NAME"]) ? "" : (string)dt.Rows[0]["FIRST_NAME"]; if (!DBNull.Value.Equals(dt.Rows[0]["LAST_NAME"])) { LastNameBox.Text = (string)dt.Rows[0]["LAST_NAME"]; } if (!DBNull.Value.Equals(dt.Rows[0]["OTHER_NAME"])) { OtherNameBox.Text = (string)dt.Rows[0]["OTHER_NAME"]; } if (!DBNull.Value.Equals(dt.Rows[0]["GENDER"])) { if ((string)dt.Rows[0]["GENDER"] == "Male") { GenderList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["GENDER"] == "Female") { GenderList.SelectedIndex = 2; } else { GenderList.SelectedIndex = 3; } } if (!DBNull.Value.Equals(dt.Rows[0]["DOB"])) //6 { DateTime dob = (DateTime)dt.Rows[0]["DOB"]; DobBox.Text = dob.ToString("dd/MM/yyyy"); } if (!DBNull.Value.Equals(dt.Rows[0]["MARITAL_STAT"])) { if ((string)dt.Rows[0]["MARITAL_STAT"] == "Single") { MaritalList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["MARITAL_STAT"] == "Married") { MaritalList.SelectedIndex = 2; } else { MaritalList.SelectedIndex = 3; } } if (!DBNull.Value.Equals(dt.Rows[0]["COUNTRY_ORI"])) { CountryOriBox.Text = (string)dt.Rows[0]["COUNTRY_ORI"]; } if (!DBNull.Value.Equals(dt.Rows[0]["STATE_ORI"])) { StateOriBox.Text = (string)dt.Rows[0]["STATE_ORI"]; } if (!DBNull.Value.Equals(dt.Rows[0]["LGA_ORI"])) { LocalOriBox.Text = (string)dt.Rows[0]["LGA_ORI"]; } if (!DBNull.Value.Equals(dt.Rows[0]["PHONE_NO"])) { PhoneBox.Text = (string)dt.Rows[0]["PHONE_NO"]; //11 } if (!DBNull.Value.Equals(dt.Rows[0]["EMAIL"])) { EmailBox.Text = (string)dt.Rows[0]["EMAIL"]; } if (!DBNull.Value.Equals(dt.Rows[0]["COUNTRY_RES"])) { CountryResBox.Text = (string)dt.Rows[0]["COUNTRY_RES"]; } if (!DBNull.Value.Equals(dt.Rows[0]["STATE_RES"])) { StateResBox.Text = (string)dt.Rows[0]["STATE_RES"]; } if (!DBNull.Value.Equals(dt.Rows[0]["LGA_RES"])) { LocalResBox.Text = (string)dt.Rows[0]["LGA_RES"]; } if (!DBNull.Value.Equals(dt.Rows[0]["HOME_ADR"])) { HomeAdrBox.Text = (string)dt.Rows[0]["HOME_ADR"]; //16 } if (!DBNull.Value.Equals(dt.Rows[0]["ID_TYPE"])) { if ((string)dt.Rows[0]["ID_TYPE"] == "National Id") { IdTypeList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["ID_TYPE"] == "School Id") { IdTypeList.SelectedIndex = 2; } else if ((string)dt.Rows[0]["ID_TYPE"] == "Voters Card") { IdTypeList.SelectedIndex = 3; } else { IdTypeList.SelectedIndex = 4; } } if (!DBNull.Value.Equals(dt.Rows[0]["ID_NO"])) { IdNoBox.Text = (string)dt.Rows[0]["ID_NO"]; } if (!DBNull.Value.Equals(dt.Rows[0]["NEXT_OF_KIN"])) { NextNameBox.Text = (string)dt.Rows[0]["NEXT_OF_KIN"]; } if (!DBNull.Value.Equals(dt.Rows[0]["NXT_OF_KIN_REL"])) { NextRelBox.Text = (string)dt.Rows[0]["NXT_OF_KIN_REL"]; } if (!DBNull.Value.Equals(dt.Rows[0]["NXT_PHONE_NO"])) { NextPhoneBox.Text = (string)dt.Rows[0]["NXT_PHONE_NO"]; //21 } if (!DBNull.Value.Equals(dt.Rows[0]["NXT_EMAIL"])) { NextEmailBox.Text = (string)dt.Rows[0]["NXT_EMAIL"]; } if (!DBNull.Value.Equals(dt.Rows[0]["NXT_ADR"])) { NextAdrBox.Text = (string)dt.Rows[0]["NXT_ADR"]; } if (!DBNull.Value.Equals(dt.Rows[0]["GENOTYPE"])) { if ((string)dt.Rows[0]["GENOTYPE"] == "AA") { TypeList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["GENOTYPE"] == "AS") { TypeList.SelectedIndex = 2; } else if ((string)dt.Rows[0]["GENOTYPE"] == "SS") { TypeList.SelectedIndex = 3; } else { TypeList.SelectedIndex = 4; } } if (!DBNull.Value.Equals(dt.Rows[0]["BLOOD_GRP"])) { if ((string)dt.Rows[0]["BLOOD_GRP"] == "A") { GroupList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["BLOOD_GRP"] == "B") { GroupList.SelectedIndex = 2; } else if ((string)dt.Rows[0]["BLOOD_GRP"] == "AB") { GroupList.SelectedIndex = 3; } else if ((string)dt.Rows[0]["BLOOD_GRP"] == "O") { GroupList.SelectedIndex = 4; } else { TypeList.SelectedIndex = 5; } } if (!DBNull.Value.Equals(dt.Rows[0]["OTHER_INFO"])) { OtherInfoBox.Text = (string)dt.Rows[0]["OTHER_INFO"]; //26 } if (Session["User"].ToString().StartsWith("PAT")) //for patients { if (!DBNull.Value.Equals(dt.Rows[0]["MATRIC_NO"])) { SchoolIdBox.Text = (string)dt.Rows[0]["MATRIC_NO"]; //27 } } else //for other users { if (!DBNull.Value.Equals(dt.Rows[0]["SCHL_ID_NO"])) { SchoolIdBox.Text = (string)dt.Rows[0]["SCHL_ID_NO"]; //27 } if (!DBNull.Value.Equals(dt.Rows[0]["PRI_SCHL"])) { PriBox.Text = (string)dt.Rows[0]["PRI_SCHL"]; } if (!DBNull.Value.Equals(dt.Rows[0]["PRI_CERT"])) { if ((string)dt.Rows[0]["PRI_CERT"] == "First School Leaving Certificate (FSLT)") { PriList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["PRI_CERT"] == "None") { PriList.SelectedIndex = 2; } else { PriList.SelectedIndex = 3; } } if (!DBNull.Value.Equals(dt.Rows[0]["SEC_SCHL"])) { SecBox.Text = (string)dt.Rows[0]["SEC_SCHL"]; } if (!DBNull.Value.Equals(dt.Rows[0]["SEC_CERT"])) //31 { if ((string)dt.Rows[0]["SEC_CERT"] == "WASSCE/WAEC") { SecList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["SEC_CERT"] == "GCE") { SecList.SelectedIndex = 2; } else if ((string)dt.Rows[0]["SEC_CERT"] == "NECO") { SecList.SelectedIndex = 3; } else if ((string)dt.Rows[0]["SEC_CERT"] == "None") { SecList.SelectedIndex = 4; } else { SecList.SelectedIndex = 5; } } if (!DBNull.Value.Equals(dt.Rows[0]["UNI"])) { UniBox.Text = (string)dt.Rows[0]["UNI"]; } if (!DBNull.Value.Equals(dt.Rows[0]["UNI_CERT"])) { if ((string)dt.Rows[0]["UNI_CERT"] == "Pass (Doctor)") { UniList.SelectedIndex = 1; } else if ((string)dt.Rows[0]["UNI_CERT"] == "First Class") { UniList.SelectedIndex = 2; } else if ((string)dt.Rows[0]["UNI_CERT"] == "Second class, Upper Division") { UniList.SelectedIndex = 3; } else if ((string)dt.Rows[0]["UNI_CERT"] == "Second class, Lower division") { UniList.SelectedIndex = 4; } else if ((string)dt.Rows[0]["UNI_CERT"] == "Third Class") { UniList.SelectedIndex = 5; } else if ((string)dt.Rows[0]["UNI_CERT"] == "Pass (Staff)") { UniList.SelectedIndex = 6; } else if ((string)dt.Rows[0]["UNI_CERT"] == "None") { UniList.SelectedIndex = 7; } else { UniList.SelectedIndex = 8; } } if (!DBNull.Value.Equals(dt.Rows[0]["OTHER_INST1"])) { OtherBox1.Text = (string)dt.Rows[0]["OTHER_INST1"]; } if (!DBNull.Value.Equals(dt.Rows[0]["OTHER_CERT1"])) { OtherCert1.Text = (string)dt.Rows[0]["OTHER_CERT1"]; } if (!DBNull.Value.Equals(dt.Rows[0]["OTHER_INST2"])) { OtherBox2.Text = (string)dt.Rows[0]["OTHER_INST2"]; //36 } if (!DBNull.Value.Equals(dt.Rows[0]["OTHER_CERT2"])) { OtherCert2.Text = (string)dt.Rows[0]["OTHER_CERT2"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_NAME1"])) { RefNameBox1.Text = (string)dt.Rows[0]["REF_NAME1"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_OF_KIN_REL1"])) { RefRelBox1.Text = (string)dt.Rows[0]["REF_OF_KIN_REL1"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_PHONE_NO1"])) { RefPhoneBox1.Text = (string)dt.Rows[0]["REF_PHONE_NO1"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_EMAIL1"])) { RefEmailBox1.Text = (string)dt.Rows[0]["REF_EMAIL1"]; //41 } if (!DBNull.Value.Equals(dt.Rows[0]["REF_ADR1"])) { RefAdrBox1.Text = (string)dt.Rows[0]["REF_ADR1"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_NAME2"])) { RefNameBox2.Text = (string)dt.Rows[0]["REF_NAME2"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_OF_KIN_REL2"])) { RefRelBox2.Text = (string)dt.Rows[0]["REF_OF_KIN_REL2"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_PHONE_NO2"])) { RefPhoneBox2.Text = (string)dt.Rows[0]["REF_PHONE_NO2"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_EMAIL2"])) { RefEmailBox2.Text = (string)dt.Rows[0]["REF_EMAIL2"]; } if (!DBNull.Value.Equals(dt.Rows[0]["REF_ADR2"])) { RefAdrBox2.Text = (string)dt.Rows[0]["REF_ADR2"]; //47 } } } } catch (Exception ex) { StatusLabel.Text = "Error: " + ex.Message; HospitalClass.Log(ex); } }
protected void SubmitButton_Click(object sender, EventArgs e) { try { if (UnsubscribeCheckBox.Checked && ReasonBox.Text.Trim().Length > 3) { string updateCode = "", updaterId = ""; if (Session["SuperUser"] != null) { updaterId = (string)Session["SuperUser"]; } else { updaterId = (string)Session["Admin"]; } if (UserIdBox.Text.StartsWith("ST")) { updateCode = "UNSB_STF"; } else { updateCode = "UNSB_" + HospitalClass.getTableName(UserIdBox.Text.Substring(0, 2)).Substring(0, 3).ToUpper(); } //delete picture from iis server string picAddressQuery = DataProvider.Unsubscribe.getPicAddress(UserIdBox.Text); System.Data.DataTable dt = HospitalClass.getDataTable(picAddressQuery); if (dt.Rows.Count == 1) { System.IO.File.Delete(Server.MapPath(dt.Rows[0][0].ToString())); } //delete from database and update necessary tables List <string> values = new List <string>(); values.Add(ReasonBox.Text); values.Add(HospitalClass.getTransactionId()); values.Add(updateCode); values.Add(updaterId); values.Add(UserIdBox.Text); values.Add(HospitalClass.getTableName(UserIdBox.Text.Substring(0, 2))); int status = DataConsumer.executeProcedure("unsb_proc", values); //return user privileges if (Session["SuperUser"] != null) { if (Session["SuperUser"].ToString() != Session["User"].ToString()) { Session["User"] = Session["SuperUser"].ToString(); } else { Session["SuperUser"] = null; Session["Admin"] = null; Session["User"] = null; Response.Redirect("~/Login.aspx"); } } else if (Session["Admin"] != null) { if (Session["Admin"].ToString() != Session["User"].ToString()) { Session["User"] = Session["Admin"].ToString(); } else { Session["SuperUser"] = null; Session["Admin"] = null; Session["User"] = null; Response.Redirect("~/Login.aspx"); } } SubmitButton.Visible = false; StatusLabel.CssClass = "success"; StatusLabel.Text = "Successful Unsubscription.<br>User Id: " + UserIdBox.Text; } else { StatusLabel.CssClass = "error"; if (!UnsubscribeCheckBox.Checked) { StatusLabel.Text = "Unsubscription was not enforced"; } else { StatusLabel.Text = "Please enter a valid reason"; } } } catch (Exception ex) { StatusLabel.CssClass = "error"; StatusLabel.Text = "Error: " + ex.Message; HospitalClass.Log(ex); } }