// 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 = ""; } }
// Search In ranges private void Search_In_Range_button_Click(object sender, EventArgs e) { String Option = Search_In_Range_comboBox.Text; String SearchKeyFROM, SearchKeyTO, SQLcommand; #region Data Validation if (!ValidateData.ValidateComboBoxItem(Option, new List <String> { "Patient_ID", "Age", "Visit_date", "Birth_date", "DMF", "_dmf", "DEF" })) { Error.SetError(Search_In_Range_comboBox, "Please"); return; } Error.Clear(); SearchKeyFROM = Search_IR_from_textBox.Text; SearchKeyTO = Search_IR_to_textBox.Text; if (Option == "Patient_ID" && (!ValidateData.ValidateIDField(SearchKeyFROM) || !ValidateData.ValidateIDField(SearchKeyTO))) { Error.SetError(SIR_SK_Label, "Enter valid ID"); return; } else if (Option == "Age" && (!ValidateData.ValidateAge(SearchKeyFROM) || !ValidateData.ValidateAge(SearchKeyTO))) { Error.SetError(SIR_SK_Label, "Enter Valid age"); return; } else if (Option == "Visit_date" && (!ValidateData.ValidateDate(SearchKeyFROM) || !ValidateData.ValidateDate(SearchKeyTO))) { MessageBox.Show("Please enter valid Visit date, ex: 1/2/2002 "); Error.SetError(SIR_SK_Label, "Enter valid visit date"); return; } else if (Option == "Birth_date" && (!ValidateData.ValidateDate(SearchKeyFROM) || !ValidateData.ValidateDate(SearchKeyTO))) { MessageBox.Show("Please enter valid Birth date, ex: 1/2/2002 "); Error.SetError(SIR_SK_Label, "Enter valid visit date"); return; } else if (Option == "DMF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO))) { MessageBox.Show("Please enter valid DMF values"); Error.SetError(SIR_SK_Label, "Enter valid DMF values"); return; } else if (Option == "_dmf" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO))) { MessageBox.Show("Please enter valid dmf values"); Error.SetError(SIR_SK_Label, "Enter valid DMF values"); return; } else if (Option == "DEF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO))) { MessageBox.Show("Please enter valid DEF values"); Error.SetError(SIR_SK_Label, "Enter valid DEF values"); return; } Error.Clear(); #endregion ///////////////////////////////////// // Fetch Data from DB SQLcommand = Get_Search_InRange_SQLcommand(Option, SearchKeyFROM, SearchKeyTO); if (SQLcommand.Length != 0) { Search_Result newResult = new Search_Result(SQLcommand); if (newResult.ShowForm == true) { newResult.Show(); } else { Error.SetError(Set_Search_2P_Button, "Search keys is not exist in your database"); return; } } else { MessageBox.Show("SQL COMMAND STRING IS EMPTY"); } Error.Clear(); }