//It deletes the existing Schedules for all the Instructors and the Date that don't have an Appointment with a Client public static void deleteExistingSchedulesForInstructorsAndDate(string myDate) { var deleteQuery = $"DELETE FROM Appointments WHERE slotDate='{ControlFunctions.formatToSQLDate(DateTime.Parse(myDate))}' AND usernameClient IS null"; SQL.executeQuery(deleteQuery); }
//It deletes the existing Schedules for a Instructor and between the Dates that don't have an Appointment with a Client nor have been confirmed by Admin public static void deleteExistingSchedulesForInstructorAndDates(string instructor, string myDate1, string myDate2) { var deleteQuery = $"DELETE FROM Appointments WHERE usernameInstructor='{instructor}' AND slotDate>='{ControlFunctions.formatToSQLDate(DateTime.Parse(myDate1))}' AND slotDate<='{ControlFunctions.formatToSQLDate(DateTime.Parse(myDate2))}' AND usernameClient IS null AND confirmed is null"; SQL.executeQuery(deleteQuery); }