// Delete Patient Profile private void Delete_patient_button_Click(object sender, EventArgs e) { string message = "Are you sure you want to delete this patient?"; string caption = "Warning"; MessageBoxButtons buttons = MessageBoxButtons.YesNoCancel; MessageBoxIcon Icon = MessageBoxIcon.Warning; DialogResult result; // Displays the MessageBox. result = MessageBox.Show(message, caption, buttons, Icon); if (result == DialogResult.Yes) { RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM Diagnosis WHERE Patient_ID = {0}", Patient_ID); RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM Dates WHERE Patient_ID = {0}", Patient_ID); RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM [X-ray_images] WHERE Patient_ID = {0}", Patient_ID); RetrievedContext.Database.ExecuteSqlCommand("DELETE FROM Patient_info WHERE Patient_ID = {0}", Patient_ID); RetrievedContext.SaveChanges(); if (!RetrievedContext.Patient_info.Any(i => i.Patient_ID == Patient_ID)) { MessageBox.Show("The patient was deleted"); ValidateData.ReorderXray_table(); ValidateData.ReorderDiagnosis_table(); ValidateData.ReorderDates_table(); } else { MessageBox.Show("Failed to delete the patient"); } this.Close(); } }
// Delete Set of patients private void Delete_patients_button_Click(object sender, EventArgs e) { String From, To; int FromID, ToID; From = Delete_from_textBox.Text; To = Delete_to_textBox.Text; if (!ValidateData.ValidateIDField(From)) { Error.SetError(Delete_from_textBox, "sdgd"); return; } Error.Clear(); if (!ValidateData.ValidateIDField(To)) { Error.SetError(Delete_to_textBox, "sdgd"); return; } Error.Clear(); FromID = Int32.Parse(From); ToID = Int32.Parse(To); //------------------------------------ string message = "Are you sure you want to delete these patients?"; string caption = "Warning"; MessageBoxButtons buttons = MessageBoxButtons.YesNoCancel; MessageBoxIcon Icon = MessageBoxIcon.Warning; DialogResult result; // Displays the MessageBox. result = MessageBox.Show(message, caption, buttons, Icon); if (result == DialogResult.Yes) { Delete.Database.ExecuteSqlCommand("DELETE FROM Diagnosis WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID); Delete.Database.ExecuteSqlCommand("DELETE FROM Dates WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID); Delete.Database.ExecuteSqlCommand("DELETE FROM [X-ray_images] WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID); int Number_of_rows_Affected = Delete.Database.ExecuteSqlCommand("DELETE FROM Patient_info WHERE Patient_ID BETWEEN {0} AND {1} ", FromID, ToID); Delete.SaveChanges(); MessageBox.Show(Number_of_rows_Affected + " Patients was deleted.\n Please check your DB browser"); if (Number_of_rows_Affected != 0) { ValidateData.ReorderXray_table(); ValidateData.ReorderDiagnosis_table(); ValidateData.ReorderDates_table(); } Delete_from_textBox.Text = ""; Delete_to_textBox.Text = ""; } }
// Main Function private void AddnewPatient_saveAndConfirm_button_Click(object sender, EventArgs e) { int ID = 0, Age; String Name, Home_no = "", Mobile_no, Address, Cheif_comp, Medical_Alr, Comments, Sex, RelativeMarriage; DateTime VisitDate, BirthDate; byte[] PatientPhoto; var newPatient = new Patient_info(); // Re-validate if (!DataValidation()) { return; } try { ID = Int32.Parse(Patient_ID_textBox.Text); Age = Int32.Parse(Age_textBox.Text); Name = Patient_name_textBox.Text; Home_no = Homenum_textBox.Text; Mobile_no = Mobile_textBox.Text; Address = Address_textBox.Text; Cheif_comp = Chief_Complaint_textBox.Text; Medical_Alr = Medical_alert_textBox.Text; VisitDate = Convert.ToDateTime(Visit_date_textBox.Text); BirthDate = Convert.ToDateTime(DateOfBirth_textBox.Text); PatientPhoto = imageToByteArray(Patient_Picture); Comments = Comments_textbox.Text; Sex = Sex_Combobox.Text; RelativeMarriage = Realative_Marriage_comboBox.Text; // Main Panel /////////////////////////////// newPatient.Patient_ID = ID; newPatient.Patient_name = Name; newPatient.Visit_date = VisitDate; newPatient.Age = Age; newPatient.Home_number = Home_no; newPatient.Phone_number = Mobile_no; newPatient.Birth_date = BirthDate; newPatient.Patient_image = PatientPhoto; newPatient.Sex = Sex; newPatient.Relative_marriage = RelativeMarriage; newPatient.Address = Address; newPatient.Cheif_complaint = Cheif_comp; newPatient.Medical_alert = Medical_Alr; newPatient.D_DMF = D; newPatient.M_DMF = M; newPatient.F_DMF = F; newPatient.DMF = DMF; newPatient.dd_dmf = d; newPatient.mm_dmf = m; newPatient.ff_dmf = f; newPatient.C_dmf = _dmf; newPatient.D_DEF = _D; newPatient.E_DEF = E; newPatient.F_DEF = _F; newPatient.DEF = DEF; if (Comments.Length != 0) { newPatient.Comments = Comments; } /////////////////////////////////////////// // Diagnosis and Treatment Plans panel ////////////////////////////////////////// var Dcount = (from o in DataEntiry.Diagnoses select o).Count(); int Dtemp = Dcount + 1; foreach (List <String> row in DiagnosisAndTPs_table) { var DiagnosisObject = new Diagnosis(); DiagnosisObject.Diagnose_ID = Dtemp; DiagnosisObject.Diagnose = row[0]; DiagnosisObject.Treatment_Plan = row[1]; newPatient.Diagnoses.Add(DiagnosisObject); Dtemp++; } ///////////////////////////////////////// // Patinet's X-ray images //////////////////////////////////////// // Byte[] XrayImage; MemoryStream ms; int index = 0; var Xcount = (from o in DataEntiry.X_ray_images select o).Count(); int Xtemp = Xcount + 1; foreach (Bitmap img in Patient_Xray_images) { var XrayimageObject = new X_ray_images(); ms = new MemoryStream(); img.Save(ms, img.RawFormat); XrayimageObject.Xray_image = ms.ToArray(); XrayimageObject.Image_name = XrayImagesNames[index]; XrayimageObject.Xray_images_ID = Xtemp; newPatient.X_ray_images.Add(XrayimageObject); index++; Xtemp++; } ///////////////////////////////////////// // Dates And Procedures Panel //////////////////////////////////////// var DAcount = (from o in DataEntiry.Dates select o).Count(); int DAtemp = DAcount + 1; foreach (List <String> row in DatesAndProc_table) { var DatesObject = new Date(); DatesObject.Dates_ID = DAtemp; DatesObject.Date1 = Convert.ToDateTime(row[0]); DatesObject.Doctor_name = row[1]; DatesObject.Procedures = row[2]; DatesObject.Procedure_Comment = row[3]; if (row[4].Length != 0) { DatesObject.Medication = row[4]; } DatesObject.Supervisor_signature = row[5]; newPatient.Dates.Add(DatesObject); DAtemp++; } } catch (Exception) { MessageBox.Show("Please press Check Data Button before Saving"); return; } DataEntiry.Patient_info.Add(newPatient); try { DataEntiry.SaveChanges(); } catch (Exception ex) { Exception exeption = ex; MessageBox.Show("Something wrong with saving the changes in the DBcontext"); return; } // Check if exist string SqlCommand = "SELECT * FROM Patient_info WHERE Patient_ID = " + ID.ToString() + " AND Home_number = " + Home_no.ToString() + " "; BSS.DataSource = Con.GetData(SqlCommand); Check = (DataTable)BSS.DataSource; if (Check.Rows.Count != 0) { MessageBox.Show("The patient was added successfully"); NewPatientWasAdded = true; Add_new_Patient Reset = new Add_new_Patient(); this.Close(); this.Dispose(); Reset.Show(); } else { MessageBox.Show("Failed to add the patient file"); } }