// 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(); }