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