private void resetAvailabilityToolStripMenuItem_Click(object sender, EventArgs e) { var AvailabilityQuery = from x in context.Availability select x; var availabilities = AvailabilityQuery.ToList <Availability>(); foreach (Availability a in availabilities) { a.C9am = false; a.C10am = false; a.C11am = false; a.C12pm = false; a.C1pm = false; a.C2pm = false; a.C3pm = false; a.C4pm = false; a.C5pm = false; } context.SaveChanges(); RefreshAvailabilityDataGrid(); }
private void ConfirmButton_Click(object sender, EventArgs e) { BookingCompleteDialog bookingCompleteDialog = new BookingCompleteDialog(); bookingCompleteDialog.Location = this.Location; bookingCompleteDialog.FormClosing += delegate { ConfirmButton.Enabled = false; this.toolStripStatusLabel.Text = "Booking has been completed!"; ConfirmationLabel.Visible = true; }; try { // Build a new Booking transaction object to insert into BookingTransaction newBookingTransaction = new BookingTransaction() { CustomerID = this.customerId, VenueID = this.venueID, DateCreated = DateTime.Now, BookedDate = bookedDate, BookedHour = timeslot, Status = "Confirmed", Remark = remark }; context.BookingTransaction.Add(newBookingTransaction); context.SaveChanges(); context = new SportsFacilitiesEntities(); // Update the availability table to show that the timeslot is occupied var query = from x in context.Availability where venueID == x.VenueID select x; Availability availability = query.First(); switch (timeslot) { case "9am": availability.C9am = true; break; case "10am": availability.C10am = true; break; case "11am": availability.C11am = true; break; case "12pm": availability.C12pm = true; break; case "1pm": availability.C1pm = true; break; case "2pm": availability.C2pm = true; break; case "3pm": availability.C3pm = true; break; case "4pm": availability.C4pm = true; break; case "5pm": availability.C5pm = true; break; } } catch (Exception ex) { toolStripStatusLabel.Text = ex.ToString(); Console.WriteLine("\n\n" + ex.ToString()); } context.SaveChanges(); bookingCompleteDialog.ShowDialog(); }