//********************************************* Methods interacting with the Database *******************************************
//It inserts the new Schedules for the selected Date and all the Instructors
private void insertNewSchedulesForInstructor(string instructor, string[][] schedules)
{
//It checks the data from the matrix coming from the ListView
for (int i = 1; i < schedules.Length - 1; i++) //days
{
string myDate = listViewWeek.Columns[i].Text;
for (int j = 0; j < schedules[0].Length - 1; j++) //hours
{
//The information to proceed with the INSERT query
string myTime = timesOfDate[j];
string value = schedules[i][j];
int slotId = 1;
//IT checks that value=1
if (value != "0")
{
if (!DBData.checkExistingAppointment(instructor, myDate, myTime))
{
var insertQuery = $"INSERT INTO Appointments (usernameInstructor, idTimeSlot, slotDate, slotTime) VALUES('{instructor}', {slotId}, '{ControlFunctions.formatToSQLDate(DateTime.Parse(myDate))}', '{myTime}')";
SQL.executeQuery(insertQuery);
}
}
}
}
MessageBox.Show("Instructors Schedules saved successfully.");
}
//It inserts the new Schedules for the selected Date and all the Instructors confirming the Schedules
private void insertNewSchedules(string myDate, string[][] schedules)
{
//It checks the data from the matrix coming from the ListView
for (int i = 1; i < schedules.Length - 1; i++)
{
for (int j = 0; j < schedules[0].Length - 1; j++)
{
//The information to proceed with the INSERT query
string instructor = instructorsUserNames[i - 1];
string carAssignedForWeek = getCarsAssignedToInstructor(instructor, firstDayOfWeek, lastDayOfWeek);
//string carLicense = cars[i - 1];
string myTime = timesOfDate[j];
string value = schedules[i][j];
int slotId = 1;
//IT checks that value=1
if (value != "0")
{
if (!DBData.checkExistingAppointment(instructor, myDate, myTime))
{
var insertQuery = "";
if (carAssignedForWeek == "")
{
insertQuery = $"INSERT INTO Appointments (usernameInstructor, idTimeSlot, slotDate, slotTime, confirmed) VALUES('{instructor}', {slotId}, '{ControlFunctions.formatToSQLDate(DateTime.Parse(myDate))}', '{myTime}', 1)";
}
else
{
insertQuery = $"INSERT INTO Appointments (usernameInstructor, idTimeSlot, slotDate, slotTime, carLicense, confirmed) VALUES('{instructor}', {slotId}, '{ControlFunctions.formatToSQLDate(DateTime.Parse(myDate))}', '{myTime}', '{carAssignedForWeek}', 1)";
}
SQL.executeQuery(insertQuery);
}
}
}
}
MessageBox.Show("Instructors Schedules saved successfully. Now assign a car to the required Instructors.");
}
