// 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 = ""; } }