public void testDeleteBooking() { SeatBookingClass booking1 = new SeatBookingClass("Stall", "M", 5, 1); List <SeatBookingClass> SeatsToBookList = new List <SeatBookingClass>(); SeatsToBookList.Add(booking1); BookingsClass.newBooking(1, "2017-06-28 12:00", 0, SeatsToBookList); SeatBookingClass booking2 = new SeatBookingClass("Stall", "M", 6, 1); SeatsToBookList[0] = booking2; BookingsClass.newBooking(2, "2017-06-27 12:00", 0, SeatsToBookList); BookingsClass.deleteBooking(2); dataSet = BookingsClass.getBookingDetailsById(2); int actualBookingRowCount = dataSet.Tables[0].Rows.Count; int expectedBookingRowCount = 0; dataSet = SeatsClass.getSeatDetails("Stall", "M", 5, 1); int actualSeatBookingId = int.Parse(dataSet.Tables[0].Rows[0]["booking_Id"].ToString()); int epectedSeatBookingId = 0; Assert.AreEqual(expectedBookingRowCount, actualBookingRowCount); Assert.AreEqual(epectedSeatBookingId, actualSeatBookingId); }
public void testAddBooking() { SeatBookingClass booking1 = new SeatBookingClass("Stall", "M", 5, 2); List <SeatBookingClass> SeatsToBookList = new List <SeatBookingClass>(); SeatsToBookList.Add(booking1); BookingsClass.newBooking(2, "2017-06-20 12:00", 0, SeatsToBookList); dataSet = BookingsClass.getBookingDetailsById(1); int actualCustomerId = int.Parse(dataSet.Tables[0].Rows[0]["Customer_Id"].ToString()); string actualBookingDate = dataSet.Tables[0].Rows[0]["Date_Of_Booking"].ToString(); int actualPaid = int.Parse(dataSet.Tables[0].Rows[0]["Paid"].ToString()); dataSet = SeatsClass.getAllSeatsForBooking(1); string actualSection = dataSet.Tables[0].Rows[0]["Section"].ToString(); string actualRow = dataSet.Tables[0].Rows[0]["Row"].ToString(); int actualNumber = int.Parse(dataSet.Tables[0].Rows[0]["Number"].ToString()); int actualShowingId = int.Parse(dataSet.Tables[0].Rows[0]["Showing_Id"].ToString()); int actualBookingId = int.Parse(dataSet.Tables[0].Rows[0]["Booking_Id"].ToString()); int expectedCustomerId = 2; string expectedBookingDate = "2017-06-20 12:00"; int expectedPaid = 0; string expectedSection = "Stall"; string expectedRow = "M"; int expectedNumber = 5; int expectedShowingId = 2; int expectedBookingId = 1; Assert.AreEqual(expectedCustomerId, actualCustomerId); Assert.AreEqual(expectedBookingDate, actualBookingDate); Assert.AreEqual(expectedPaid, actualPaid); Assert.AreEqual(expectedSection, actualSection); Assert.AreEqual(expectedRow, actualRow); Assert.AreEqual(expectedNumber, actualNumber); Assert.AreEqual(expectedShowingId, actualShowingId); Assert.AreEqual(expectedBookingId, actualBookingId); }
private void BookPlay_button_Click(object sender, RoutedEventArgs e) { if (ChoosePlay_combo.Items.Count == 0) { MessageBox.Show("Please select a showing and fill out all other fields before selecting 'Add to Basket"); } else { string sqlDateString = ShowingsClass.formatDateTimeToSqlLiteDateString((DateTime)SelectDate_Booking.SelectedDate); int showingId = ShowingsClass.getShowingIdByDate(sqlDateString); int customerId = int.Parse(this.Surname_Booking_Combo.SelectedValue.ToString()); List <SeatBookingClass> seatBookingList = new List <SeatBookingClass>(); foreach (DataRow row in seatBookingsDataset.Rows) { SeatBookingClass seatBookingObj = new SeatBookingClass(row["Section"].ToString(), row["Row"].ToString(), int.Parse(row["Number"].ToString()), showingId); seatBookingList.Add(seatBookingObj); } //int pCustomerId, string pDate, int pPaid, List<SeatBookingClass> SeatsToBookList BookingsClass.newBooking(customerId, ShowingsClass.formatDateTimeToSqlLiteDateString(DateTime.Now), 0, seatBookingList); MessageBox.Show("New booking added"); } }