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);
}
}
