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");
}
}
