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();
}
}
/*Insert on Log_PatientWholeField table with the insert Operation */
public void insertOn_Log_PatientWholeField_WithInsertOperation(String username)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
String patientWholeFieldLog_Date;
String patientWholeFieldLog_Operation = "Insert";
/*Current date and time calculated*/
DateTime currentDateNTime = DateTime.Now;
patientWholeFieldLog_Date = currentDateNTime.ToString("dd/MM/yyyy hh:mm:ss tt");
cmd.CommandText = "sp_Log_patientWholeField";
cmd.CommandType = CommandType.StoredProcedure;
/*Getting Patient Id from Patient's username and putting that userId value*/
try
{
UserClass uc = new UserClass();
PatientClass pc = new PatientClass();
int userId, patientId;
DataTable dt = uc.GetUserIdFromUsername(username);
if (dt.Rows.Count > 0)
{
String userIdString = dt.Rows[0]["userId"].ToString();
userId = Convert.ToInt32(userIdString);
cmd.Parameters.Add("@userId", userId);
/*Getting Patient Id from Patient's userId*/
DataTable dtPatient = pc.SelectAllPatientFromUserId(userId);
if (dtPatient.Rows.Count > 0)
{
String patientIdString = dtPatient.Rows[0]["patientId"].ToString();
patientId = Convert.ToInt32(patientIdString);
cmd.Parameters.Add("@patientId", patientId);
}
}
}
catch (Exception ex)
{
throw ex;
}
cmd.Parameters.Add("@patientWholeFieldLog_Date", patientWholeFieldLog_Date);
cmd.Parameters.Add("@patientWholeFieldLog_Operation", patientWholeFieldLog_Operation);
cmd.ExecuteNonQuery();
}
