// event method for when the submit button is clicked
private void btnNewBook_Click(object sender, EventArgs e)
{
// converts the date in the dtTime control to text
DateTime date = Convert.ToDateTime(dtDate.Text);
// if the booking is not already taken
if (!db.checkBookingExists(dtDate.Text, Convert.ToInt32(txtPeriod.Value), Convert.ToInt32(txtRoom.Value), editID))
{
// if in edit mode
if (modeEdit)
{
// update the booking
db.updateBooking(editID, Convert.ToInt32(txtRoom.Value), date, Convert.ToInt32(txtPeriod.Value), session.userID, txtNotes.Text);
help.refreshHomeForm();
}
else
{
// insert the booking
db.insertBooking(Convert.ToInt32(txtRoom.Value), date, Convert.ToInt32(txtPeriod.Value), session.userID, txtNotes.Text);
help.refreshHomeForm();
}
// close the form
this.Close();
}
else
{
// show error message
MessageBox.Show("That slot is taken!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// event method for when the test booking button is clicked
private void btnTestBooking_Click(object sender, EventArgs e)
{
Debug.WriteLine("Inserting test booking..");
// generate random dates, rooms and periods
Random r = new Random();
int dateThing = r.Next(1, 22);
int roomID = r.Next(1, 8);
int period = r.Next(1, 6);
// sets date
DateTime date = new DateTime(2018, 2, dateThing);
// if booking does not already exist, insert the booking
if (!db.checkBookingExists(date.ToString(), period, roomID))
{
db.insertBooking(roomID, date, period, session.userID, "Test Booking");
}
}
// when test booking button is clicked
private void btnTestBooking_Click(object sender, EventArgs e)
{
Debug.WriteLine("Inserting test booking..");
// generate random values
Random r = new Random();
int dateThing = r.Next(1, 22);
int roomID = r.Next(1, 8);
int period = r.Next(1, 6);
// convert random date into datetime format
DateTime date = new DateTime(2018, 2, dateThing);
// if booking doesn't already exist, insert into table
if (!db.checkBookingExists(date.ToString(), period, roomID))
{
db.insertBooking(roomID, date, period, session.userID, "Test Booking");
}
// refresh the form
refreshForm();
}
