public static void UpdateTimeSlot(TimeSlotModel timeSlot)
{
using IDbConnection cnn = new SQLiteConnection(LoadConnectionString());
string q = string.Concat("UPDATE time_slots SET roomid = '", timeSlot.Roomid, "', datetime ='", timeSlot.Datetime, "', timeslot='", timeSlot.Timeslot, "', booked='", timeSlot.Booked, "' WHERE id =", timeSlot.Id.ToString(), ";");
cnn.Execute(q, timeSlot);
}
public static void BookTimeSlot(TimeSlotModel timeSlot)
{
List <TimeSlotModel> list = LoadTimeSlots(timeSlot.Datetime, timeSlot.Timeslot);
if (list.Count > 0)
{
using IDbConnection cnn = new SQLiteConnection(LoadConnectionString());
cnn.Execute("INSERT into time_slots (roomid, datetime, timeslot, booked) values (@RoomId, @Datetime, @Timeslot, @Booked)", timeSlot);
}
}
private void BookRoom(int roomId)
{
TimeSlotModel timeslot = new TimeSlotModel
{
Roomid = roomId,
Datetime = bookableDateTimes[comboBoxDates.SelectedIndex].ToShortDateString(),
Timeslot = comboBoxTimeSlots.Items[comboBoxTimeSlots.SelectedIndex].ToString(),
Booked = true
};
SqliteDataAccess.BookTimeSlot(timeslot);
LoadAvailability();
}