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(); } }
protected void btn_Ok_Click(object sender, EventArgs e) { try { PatientClass pc = new PatientClass(); LogPatientClass lpc = new LogPatientClass(); DiseaseClass dc = new DiseaseClass(); EntryUserClass euc = new EntryUserClass(); /*Current date and time calculated*/ DateTime currentDateNTime = DateTime.Now; String checkedPatDate = currentDateNTime.ToString("dd/MM/yyyy hh:mm:ss tt"); int checkedPatBy = Convert.ToInt32(Session["userId"]); /*selectPatientIdFromPatientUsername*/ String selected_PatUsername = Session["selectedRow_Username"].ToString(); DataTable dt = pc.selectPatientIdFromPatientUsername(selected_PatUsername); if (dt.Rows.Count > 0) { int selectedRow_patientId = Convert.ToInt32(dt.Rows[0]["patientId"].ToString()); /*selectEntryUserHospitalFrom_EntryUserUsername*/ String entryUser_username = Session["username"].ToString(); DataTable dt2 = euc.selectEntryUserHospitalFrom_EntryUserUsername(entryUser_username); if (dt2.Rows.Count > 0) { String entryUserHospital = dt2.Rows[0]["entryUserHospital"].ToString(); ltrMessage1.Text = ""; /*insertIn_CheckedPat*/ pc.insertIn_CheckedPat(selectedRow_patientId, checkedPatDate, txtbox_DiseaseName.Text, txtbox_Remarks.Text, entryUserHospital, checkedPatBy); } else { ltrMessage1.Text = "No data found!"; } } else { ltrMessage1.Text = "No data found!"; } /*get_checkedPatIdFrom_checkedPatDateNcheckedPatBy*/ DataTable dt1 = pc.get_checkedPatIdFrom_checkedPatDateNcheckedPatBy(checkedPatDate, checkedPatBy); if (dt1.Rows.Count > 0) { int checkedPatId = Convert.ToInt32(dt1.Rows[0]["checkedPatId"].ToString()); //Session["checkedPatId"] = dt.Rows[0]["checkedPatId"].ToString(); /*insertIn_Log_CheckedPatWholeField*/ lpc.insertIn_Log_CheckedPatWholeField(checkedPatDate, checkedPatId); } else { ltrMessage1.Text = "No data found!"; } /*insertIn_Disease*/ dc.insertIn_Disease(txtbox_DiseaseName.Text, txtbox_Remarks.Text, checkedPatBy, checkedPatDate); Response.Redirect("Patient_CheckupWithHistory_EntryUserMaster.aspx"); //txtbox_DiseaseName.Text = ""; //txtbox_Remarks.Text = ""; } catch (Exception ex) { ltrMessage.Text = ex.Message; } }
protected void btnRegister_Click(object sender, EventArgs e) { try { UserPatientClass upc = new UserPatientClass(); LogUserClass luc = new LogUserClass(); LogPatientClass lpc = new LogPatientClass(); /*Check normal conditions*/ //1. Checking Patient Age Group if not <1 DateTime currentDateNTime = DateTime.Now; int currentYear = currentDateNTime.Year; //Getting current year DateTime dob; dob = Convert.ToDateTime(txtboxDob.Text); int dobYear = dob.Year; //Getting dob year int age = currentYear - dobYear; if (age < 1) { ltrMessage.Text = "Invalid Date of Birth!"; } /*Passwords matching checking*/ else if (txtboxPassword.Text != txtboxConfirmPassword.Text) { ltrMessage.Text = "The Passwords did not match!"; } /*2 emails matching checking*/ else if (txtboxEmail.Text == txtboxSecEmail.Text) { ltrMessage.Text = "The 2 Email addresses you provided should not be same!"; } /*2 contacts matching checking*/ else if (txtboxContact.Text == txtboxSecContact.Text) { ltrMessage.Text = "The 2 Contact Numbers you provided should not be same!"; } else { ltrMessage.Text = ""; upc.RegisterPatient_Users(txtboxUsername.Text, txtboxPassword.Text, txtboxEmail.Text, txtboxSecEmail.Text); /*Putting Country as Nepal by default*/ String country; if (txtboxCountry.Text == "") { country = "Nepal"; //Console.WriteLine("Went to this condition!"); } else { country = txtboxCountry.Text; } upc.RegisterPatient_Patient(txtboxUsername.Text, txtboxFirstName.Text, txtboxMiddleName.Text, txtboxLastName.Text, txtboxDob.Text, dropdownlistGender.Text, txtboxContact.Text, txtboxSecContact.Text, txtboxHouseAdd.Text, txtboxDistrict.Text, txtboxCity.Text, country); String username = txtboxUsername.Text; luc.insertOn_Log_UsersWholeField_WithInsertOperation(username); lpc.insertOn_Log_PatientWholeField_WithInsertOperation(username); Session["username"] = txtboxUsername.Text; Response.Redirect("Home_Patient.aspx"); //ltrMessageGreen.Text = "New Account registered!"; //txtboxUsername.Text = ""; //txtboxPassword.Text = ""; //txtboxEmail.Text = ""; //txtboxSecEmail.Text = ""; //txtboxFirstName.Text = ""; //txtboxMiddleName.Text = ""; //txtboxLastName.Text = ""; //txtboxDob.Text = ""; //dropdownlistGender.Text = ""; //txtboxContact.Text = ""; //txtboxSecContact.Text = ""; //txtboxHouseAdd.Text = ""; //txtboxDistrict.Text = ""; //txtboxCity.Text = ""; //txtboxCountry.Text = ""; //txtboxFirstName.Focus(); } } catch (Exception ex) { ltrMessage.Text = ex.Message; } }