private void UpdateButton_Click_1(object sender, EventArgs e) { string timestamp = SqlUpdater.CreateTimestamp(); int userId = SqlUpdater.GetCurrentUserID(); string username = SqlUpdater.GetCurrentUserName(); int appointmentId = Convert.ToInt32(SearchBar.Text); int customerId = Convert.ToInt32(CustomerIdBox.Text); string type = TypeBox.Text; DateTime startTime = DateTime.Parse(StartTimeBox.Text).ToUniversalTime(); DateTime endTime = DateTime.Parse(EndTimeBox.Text).ToUniversalTime(); String st = DateTime.Parse(StartTimeBox.Text).ToUniversalTime().ToString("u"); String et = DateTime.Parse(EndTimeBox.Text).ToUniversalTime().ToString("u"); bool pass = Validator(); if (pass) { try { if (AppHasConflict(startTime, endTime)) { throw new AppointmentException(); } else { try { if (OutsideBusinessHours(startTime, endTime)) { throw new AppointmentException(); } else { SqlUpdater.UpdateAppt(customerId, userId, st, et, type, timestamp, username, appointmentId); mainFormObject.UpdateCalendar(); MessageBox.Show("Update Sucessfull."); Close(); } } catch (AppointmentException ex) { ex.BusinessHours(); } } } catch (AppointmentException ex) { ex.AppOverlap(); } } else { MessageBox.Show("Add Appointment Error."); } }