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 testDeleteShowing()
        {
            dataSet = ShowingsClass.deleteShowing(2);

            string actualEmail   = dataSet.Tables[0].Rows[0]["Email"].ToString();
            string expectedEmail = "*****@*****.**";

            dataSet = SeatsClass.getSeatDetails("Stall", "M", 5, 2);
            int actualRowCountSeats   = dataSet.Tables[0].Rows.Count;
            int expectedRowCountSeats = 0;

            dataSet = BookingsClass.getBookingDetailsById(1);
            int actualRowCountBookings   = dataSet.Tables[0].Rows.Count;
            int expectedRowCountBookings = 0;

            Assert.AreEqual(expectedRowCountSeats, actualRowCountSeats);
            Assert.AreEqual(expectedEmail, actualEmail);
            Assert.AreEqual(expectedRowCountBookings, actualRowCountBookings);
        }