//It deletes the Appointment
private void buttonDelete_Click(object sender, EventArgs e)
{
if (listViewAppointments.SelectedItems.Count > 0)
{
DialogResult clientDecision = MessageBox.Show("Are you sure you want to delete that Appointment?", "Appointment Deletion", MessageBoxButtons.YesNo);
switch (clientDecision)
{
case DialogResult.Yes:
var myDate = listViewAppointments.SelectedItems[0].Text;
var myTime = listViewAppointments.SelectedItems[0].SubItems[1].Text;
var myInstructor = listViewAppointments.SelectedItems[0].SubItems[2].Text;
//It updates the DB freing the client
freeClientAppointment(myDate, myTime, myInstructor);
//It loads the Appointments for the Client
clientAppointments = getClientAppointments(userName, DateTime.Today);
//It refreshes the Appointments ListView
listViewAppointments.Items.Clear();
createListViewAppointmentsReport();
//It refreshes the Appointment Selection ListView
ControlFunctions.clearListViewReport(listViewAppointmentSelection);
createListViewAppointmentSelectionReport();
MessageBox.Show("Appointment deleted successfully.");
break;
case DialogResult.No:
break;
}
}
else
{
MessageBox.Show("Please select an Appointment first.");
}
}
//********************************************* Event Methods *****************************************************************
//It creates the ListView for the instructor to create his Schedule
private void dateTimePickerWeek_ValueChanged(object sender, EventArgs e)
{
listViewWeek.Visible = true;
//clearVariables();
//It loads the Times of the selected Date
timesOfDate = DBData.getTimesOfDay(dateTimePickerWeek.Value);
//It creates the Day ListView
ControlFunctions.clearListViewReport(listViewWeek);
createlistViewWeekReport(dateTimePickerWeek.Value);
}
private void listViewWeek_SelectedIndexChanged(object sender, EventArgs e)
{
if (listViewWeek.SelectedIndices.Count != 0)
{
var myIndex = listViewWeek.SelectedIndices[0];
var dateSelected = listViewWeek.Items[myIndex].Text;
if (myIndex < daysOfWeek)
{
labelDate.Text = dateSelected;
ControlFunctions.clearListViewReport(listViewDay);
createListViewDayReport(DateTime.Parse(dateSelected));
}
}
}
private void buttonSaveSchedule_Click(object sender, EventArgs e)
{
if (listViewWeek.Items.Count > 0)
{
string[][] LVData = ControlFunctions.obtainDataFromListView(listViewDay);
DBData.deleteExistingSchedulesForInstructorsAndDate(labelDate.Text);
insertNewSchedules(labelDate.Text, LVData);
ControlFunctions.clearListViewReport(listViewWeek);
createListViewWeekReport();
}
else
{
MessageBox.Show("Please select first a date and plan a Schedule.");
}
}
//********************************************* Event Methods *****************************************************************
private void dateTimePickerDate_ValueChanged(object sender, EventArgs e)
{
//It loads the Times of the selected Date
selectedDate = dateTimePickerDate.Value;
timesOfDate = DBData.getTimesOfDay(selectedDate);
//It makes the ListViews visibles
listViewAppointmentSelection.Visible = true;
listViewAppointments.Visible = true;
//It creates the Appointment Selection ListView
ControlFunctions.clearListViewReport(listViewAppointmentSelection);
createListViewAppointmentSelectionReport();
//It loads the Appointments for the Client
clientAppointments = getClientAppointments(userName, DateTime.Today);
}
//It saves the Schedule for the Week************************************take care with the confirmed ones from the Admin, dont delete them and dont write them again
private void buttonSaveSchedule_Click(object sender, EventArgs e)
{
if (listViewWeek.Items.Count > 0)
{
//It obtains the new schedule from the Day ListView
string[][] LVData = ControlFunctions.obtainDataFromListView(listViewWeek);
//It deletes the schedules for that Date and Instructor in the DB
DBData.deleteExistingSchedulesForInstructorAndDates(instructorUserName, firstDayOfWeek.ToString("d"), lastDayOfWeek.ToString("d"));
//It inserts the new Schedules for that Date and instructor in the DB
insertNewSchedulesForInstructor(instructorUserName, LVData);
//It actualizes the Week ListView
ControlFunctions.clearListViewReport(listViewWeek);
createlistViewWeekReport(dateTimePickerWeek.Value);
}
else
{
MessageBox.Show("Please select first a date and plan a Schedule.");
}
}
private void buttonSaveCar_Click(object sender, EventArgs e)
{
if (comboBoxInstructor.SelectedIndex != -1 && comboBoxCar.SelectedIndex != -1)
{
if (checkInstructorScheduled(comboBoxInstructor.Text))
{
DBData.updateCarAssignation(comboBoxCar.Text, comboBoxInstructor.Text, firstDayOfWeek, lastDayOfWeek);
ControlFunctions.clearListViewReport(listViewCarsAssigned);
createListViewAssignedCarsReport();
populateCarCombo();
}
else
{
MessageBox.Show($"You have to select a week with scheduled slots for {comboBoxInstructor.Text}.");
}
}
else
{
MessageBox.Show("Please select an Instructor and assing a Car with the Comboboxes below.");
}
}
private void dateTimePickerWeek_ValueChanged(object sender, EventArgs e)
{
listViewDay.Visible = true;
listViewWeek.Visible = true;
listViewCarsAssigned.Visible = true;
comboBoxInstructor.SelectedItem = -1;
comboBoxInstructor.Text = "";
comboBoxCar.SelectedItem = -1;
comboBoxCar.Text = "";
populateCarCombo();
timesOfDate = DBData.getTimesOfDay(dateTimePickerWeek.Value);
ControlFunctions.clearListViewReport(listViewWeek);
createListViewWeekReport();
ControlFunctions.clearListViewReport(listViewCarsAssigned);
createListViewAssignedCarsReport();
labelDate.Text = dateTimePickerWeek.Value.ToString("d");
ControlFunctions.clearListViewReport(listViewDay);
createListViewDayReport(dateTimePickerWeek.Value);
}
//It saves the Appointment
private void buttonConfirm_Click(object sender, EventArgs e)
{
//It updates the DB
if (instructor != "" && appointmentTime != "")
{
bookAppointment();
//It loads the Appointments for the Client
clientAppointments = getClientAppointments(userName, DateTime.Today);
//It refreshes the Appointments ListView
listViewAppointments.Items.Clear();
createListViewAppointmentsReport();
//It refreshes the Appointment Selection ListView
ControlFunctions.clearListViewReport(listViewAppointmentSelection);
createListViewAppointmentSelectionReport();
labelAppointmentSelected.Text = "No appointment selected";
appointmentTime = "";
MessageBox.Show("Appointment booked successfully.");
}
else
{
MessageBox.Show("Please select a slot first.");
}
}
//It cancels the Schedule for the Week and retrieves the data from the DB
private void buttonCancelSchedule_Click(object sender, EventArgs e)
{
//It actualizes the Week ListView
ControlFunctions.clearListViewReport(listViewWeek);
createlistViewWeekReport(dateTimePickerWeek.Value);
}
private void buttonCancelSchedule_Click(object sender, EventArgs e)
{
ControlFunctions.clearListViewReport(listViewDay);
createListViewDayReport(DateTime.Parse(labelDate.Text));
}
