public void testPayBooking()
        {
            BookingsClass.payBooking(1);
            dataSet = BookingsClass.getBookingDetailsById(1);

            int actualPaid = int.Parse(dataSet.Tables[0].Rows[0]["Paid"].ToString());

            int expectedPaid = 1;

            Assert.AreEqual(expectedPaid, actualPaid);
        }
        public void testGetAllBookingsForShowing()
        {
            dataSet = BookingsClass.getAllBookingsForShowing(2);

            int    actualBooking_Id    = int.Parse(dataSet.Tables[0].Rows[0]["Booking_Id"].ToString());
            int    actualCustomer_Id   = int.Parse(dataSet.Tables[0].Rows[0]["Customer_Id"].ToString());
            string actualDateOfBooking = dataSet.Tables[0].Rows[0]["Date_Of_Booking"].ToString();
            int    actualPaid          = int.Parse(dataSet.Tables[0].Rows[0]["Paid"].ToString());

            int    expectedBookingId     = 1;
            int    expectedCustomer_Id   = 2;
            string expectedDateOfBooking = "2017-06-20 12:00";
            int    expectedPaid          = 1;

            Assert.AreEqual(expectedBookingId, actualBooking_Id);
            Assert.AreEqual(expectedCustomer_Id, actualCustomer_Id);
            Assert.AreEqual(expectedDateOfBooking, actualDateOfBooking);
            Assert.AreEqual(expectedPaid, actualPaid);
        }
        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);
        }