protected void btnOk_Click(object sender, EventArgs e)
{
try
{
int selected_userId;
UserClass uc = new UserClass();
PatientClass pc = new PatientClass();
UserPatientClass upc = new UserPatientClass();
LogUserClass luc = new LogUserClass();
LogPatientClass lpc = new LogPatientClass();
/*Delete Users' and Patient's record
* Insert values on Log_UsersWholeFieldWithName and Log_PatientWholeFieldWithName table*/
/*Getting userId from username from Users table*/
DataTable dt = uc.SelectAllUsersFromUsername(Session["selectedRow_Username"].ToString());
if (dt.Rows.Count > 0)
{
Session["selected_userId"] = dt.Rows[0]["userId"].ToString();
selected_userId = Convert.ToInt32(Session["selected_userId"]);
/*Getting patientRecord from userId from Patient table*/
DataTable dtPatient = pc.SelectAllPatientFromUserId(selected_userId);
if (dtPatient.Rows.Count > 0)
{
Session["selected_patientId"] = dtPatient.Rows[0]["patientId"].ToString();
int selected_patientId = Convert.ToInt32(Session["selected_patientId"]);
String selected_patientFirstName = dtPatient.Rows[0]["patientFirstName"].ToString();
String selected_patientMiddleName = dtPatient.Rows[0]["patientMiddleName"].ToString();
String selected_patientLastName = dtPatient.Rows[0]["patientLastName"].ToString();
Session["selected_patientName"] = selected_patientFirstName + " "
+ selected_patientMiddleName + " " + selected_patientLastName;
luc.insertOn_Log_UsersWholeFieldWithName_WithDeleteOperation(selected_userId, Session["selectedRow_Username"].ToString());
lpc.insertOn_Log_PatientWholeFieldWithName_WithDeleteOperation(selected_userId, selected_patientId, Session["selected_patientName"].ToString());
uc.delete_UsersFrom_userId(selected_userId);
pc.delete_PatientFrom_userId(selected_userId);
}
//else { ltrMessage.Text = "Error 2nd if"; }
}
//else { ltrMessage.Text += "Error 1st if"; }
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
finally
{
ltrDelMsg.Visible = false;
btnOk.Visible = false;
loadData();
}
}