public void testGetAllShowings()
        {
            dataSet = ShowingsClass.getAllShowings();

            string actualShowingDateRow0             = dataSet.Tables[0].Rows[0]["Date"].ToString();
            double actualShowingUpperCirclePriceRow0 = double.Parse(dataSet.Tables[0].Rows[0]["UpperCirclePrice"].ToString());
            double actualShowingDressCirclePriceRow0 = double.Parse(dataSet.Tables[0].Rows[0]["DressCirclePrice"].ToString());
            double actualShowingStallPriceRow0       = double.Parse(dataSet.Tables[0].Rows[0]["StallsPrice"].ToString());

            string actualShowingDateRow1             = dataSet.Tables[0].Rows[1]["Date"].ToString();
            double actualShowingUpperCirclePriceRow1 = double.Parse(dataSet.Tables[0].Rows[1]["UpperCirclePrice"].ToString());
            double actualShowingDressCirclePriceRow1 = double.Parse(dataSet.Tables[0].Rows[1]["DressCirclePrice"].ToString());
            double actualShowingStallPriceRow1       = double.Parse(dataSet.Tables[0].Rows[1]["StallsPrice"].ToString());

            string expectedShowingDateRow0             = "2017-06-24 17:00";
            double expectedShowingUpperCirclePriceRow0 = 50;
            double expectedShowingDressCirclePriceRow0 = 25;
            double expectedShowingStallPriceRow0       = 12.5;

            string expectedShowingDateRow1             = "2017-06-22 12:00";
            double expectedShowingUpperCirclePriceRow1 = 7;
            double expectedShowingDressCirclePriceRow1 = 2;
            double expectedShowingStallPriceRow1       = 1;

            Assert.AreEqual(expectedShowingDateRow0, actualShowingDateRow0);
            Assert.AreEqual(expectedShowingUpperCirclePriceRow0, actualShowingUpperCirclePriceRow0);
            Assert.AreEqual(expectedShowingDressCirclePriceRow0, actualShowingDressCirclePriceRow0);
            Assert.AreEqual(expectedShowingStallPriceRow0, actualShowingStallPriceRow0);

            Assert.AreEqual(expectedShowingDateRow1, actualShowingDateRow1);
            Assert.AreEqual(expectedShowingUpperCirclePriceRow1, actualShowingUpperCirclePriceRow1);
            Assert.AreEqual(expectedShowingDressCirclePriceRow1, actualShowingDressCirclePriceRow1);
            Assert.AreEqual(expectedShowingStallPriceRow1, actualShowingStallPriceRow1);
        }
        private void Row_ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (this.Rows_combo.Items.Count != 0)
            {
                this.Seat_combo.Items.Clear();
                string sqlDateString = ShowingsClass.formatDateTimeToSqlLiteDateString((DateTime)SelectDate_Booking.SelectedDate);
                int    showingId     = ShowingsClass.getShowingIdByDate(sqlDateString);

                if (UpperCircle_radio.IsChecked == true)
                {
                    dataSet = SeatsClass.getAllAvailableNumbersByAreaRowShowingId(showingId, "UpperCircle", this.Rows_combo.SelectedValue.ToString());
                    fillNumberDropDown(dataSet);
                }
                else if (DressCircle_radio.IsChecked == true)
                {
                    dataSet = SeatsClass.getAllAvailableNumbersByAreaRowShowingId(showingId, "DressCircle", this.Rows_combo.SelectedValue.ToString());
                    fillNumberDropDown(dataSet);
                }
                else
                {
                    dataSet = SeatsClass.getAllAvailableNumbersByAreaRowShowingId(showingId, "Stall", this.Rows_combo.SelectedValue.ToString());
                    fillNumberDropDown(dataSet);
                }
            }
        }
Exemple #3
0
        private void LoadNewsletters_button_Click(object sender, RoutedEventArgs e)
        {
            DataSet dataset = ShowingsClass.getAllShowingsPastCurrentDate();

            foreach (DataRow row in dataset.Tables[0].Rows)
            {
                this.Newsletters_txt.Text = this.Newsletters_txt.Text + row["Name"].ToString() + " " + row["Date"].ToString() + "\n";
            }
        }
        private void Generate2_button_Click(object sender, RoutedEventArgs e)
        {
            DataSet dataSet = ShowingsClass.getAllShowingsPastCurrentDate();

            this.Report_txt.ItemsSource           = dataSet.Tables[0].DefaultView;
            this.Report_txt.Columns[0].Visibility = Visibility.Collapsed;
            this.Report_txt.Columns[1].Visibility = Visibility.Collapsed;
            this.Report_txt.Columns[6].Visibility = Visibility.Collapsed;
        }
Exemple #5
0
        private void EditShowing_button_Click(object sender, RoutedEventArgs e)
        {
            if (SelectDate_EditDelShow.SelectedDate == null)
            {
                MessageBox.Show("Please select a date for the required showing");
            }
            else
            {
                int    showingId       = ShowingsClass.getShowingIdByDate(ShowingsClass.formatDateTimeToSqlLiteDateString((DateTime)SelectDate_EditDelShow.SelectedDate));
                string startTime       = this.TimeOfShowing_EditDeleteShowing_txt.Text;
                string timeToBeChecked = ValidationClass.TimeChecker(startTime);

                if (timeToBeChecked != null)
                {
                    MessageBox.Show(timeToBeChecked);
                }
                else
                {
                    double upperCirclePrice = double.Parse(this.UpperCircle_EditDelShow_txt.Text);
                    string priceToBeChecked = UpperCircle_EditDelShow_txt.Text.ToString();
                    priceToBeChecked = ValidationClass.FloatChecker(priceToBeChecked);
                    if (priceToBeChecked != null)
                    {
                        MessageBox.Show(priceToBeChecked);
                    }
                    else
                    {
                        double dressCirclePrice = double.Parse(this.DressCircle_EditDelShow_txt.Text);
                        priceToBeChecked = DressCircle_EditDelShow_txt.Text.ToString();
                        priceToBeChecked = ValidationClass.FloatChecker(priceToBeChecked);
                        if (priceToBeChecked != null)
                        {
                            MessageBox.Show(priceToBeChecked);
                        }
                        else
                        {
                            double stallPrice = double.Parse(this.Stalls_EditDelShow_txt.Text);
                            priceToBeChecked = Stalls_EditDelShow_txt.Text.ToString();
                            priceToBeChecked = ValidationClass.FloatChecker(priceToBeChecked);
                            if (priceToBeChecked != null)
                            {
                                MessageBox.Show(priceToBeChecked);
                            }
                            else
                            {
                                dataSet = ShowingsClass.getShowingByShowingId(showingId);
                                string unedditedSqlDateTimeString = dataSet.Tables[0].Rows[0]["Date"].ToString();
                                string newDateTimeSqlString       = ShowingsClass.replaceSqlDateTimeWithNewTime(unedditedSqlDateTimeString, startTime);
                                ShowingsClass.editShowingDetails(showingId, newDateTimeSqlString, upperCirclePrice, dressCirclePrice, stallPrice);
                                MessageBox.Show("Showing edited");
                            }
                        }
                    }
                }
            }
        }
        public void testDeletePlay()
        {
            PlaysClass.deletePlay(2);
            dataSet = ShowingsClass.getShowingByShowingId(2);

            int actualPlayId = int.Parse(dataSet.Tables[0].Rows[0]["Play_Id"].ToString());

            int expectedPlayId = 1;

            Assert.AreEqual(expectedPlayId, actualPlayId);
        }
Exemple #7
0
        //-----------------------------------Add Showing ---------------------------------//

        //--------------------------------Edit/Delete Showing-----------------------------//
        private void SelectDate_EditDelShow_SelectionDateChanged(object sender, RoutedEventArgs e)
        {
            if (SelectDate_EditDelShow.SelectedDate != null)
            {
                int showingId = ShowingsClass.getShowingIdByDate(ShowingsClass.formatDateTimeToSqlLiteDateString((DateTime)SelectDate_EditDelShow.SelectedDate));
                dataSet = ShowingsClass.getShowingByShowingId(showingId);

                string dateTime = dataSet.Tables[0].Rows[0]["Date"].ToString();
                this.TimeOfShowing_EditDeleteShowing_txt.Text = ShowingsClass.getTimeFromSqlDateSting(dateTime);
                this.UpperCircle_EditDelShow_txt.Text         = dataSet.Tables[0].Rows[0]["UpperCirclePrice"].ToString();
                this.DressCircle_EditDelShow_txt.Text         = dataSet.Tables[0].Rows[0]["DressCirclePrice"].ToString();
                this.Stalls_EditDelShow_txt.Text = dataSet.Tables[0].Rows[0]["StallsPrice"].ToString();
            }
        }
 private void Stalls_radio_Checked(object sender, RoutedEventArgs e)
 {
     if (ChoosePlay_combo.Items.Count == 0)
     {
         MessageBox.Show("Please search for a showing before selecting seats");
     }
     else
     {
         this.Rows_combo.Items.Clear();
         this.UpperCircle_radio.IsChecked = false;
         this.DressCircle_radio.IsChecked = false;
         string sqlDateString = ShowingsClass.formatDateTimeToSqlLiteDateString((DateTime)SelectDate_Booking.SelectedDate);
         int    showingId     = ShowingsClass.getShowingIdByDate(sqlDateString);
         dataSet = SeatsClass.getAllAvailableRowByAreaShowingId(showingId, "Stall");
         int numberOfSeatsLeftForArea = SeatsClass.getNumOfSeatsLeftInAreaForShowing(showingId, "Stall");
         this.SeatsRemaining_lbl.Content = "Seats remaining: " + numberOfSeatsLeftForArea;
         fillRowDropDown(dataSet);
     }
 }
        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);
        }
        public void testGetShowingsByPlay()
        {
            dataSet = ShowingsClass.getShowingForPlays(2);

            string actualShowingDate             = dataSet.Tables[0].Rows[0]["Date"].ToString();
            double actualShowingUpperCirclePrice = double.Parse(dataSet.Tables[0].Rows[0]["UpperCirclePrice"].ToString());
            double actualShowingDressCirclePrice = double.Parse(dataSet.Tables[0].Rows[0]["DressCirclePrice"].ToString());
            double actualShowingStallPrice       = double.Parse(dataSet.Tables[0].Rows[0]["StallsPrice"].ToString());

            string expectedShowingDate             = "2017-06-22 12:00";
            double expectedShowingUpperCirclePrice = 7;
            double expectedShowingDressCirclePrice = 2;
            double expectedShowingStallPrice       = 1;

            Assert.AreEqual(expectedShowingDate, actualShowingDate);
            Assert.AreEqual(expectedShowingUpperCirclePrice, actualShowingUpperCirclePrice);
            Assert.AreEqual(expectedShowingDressCirclePrice, actualShowingDressCirclePrice);
            Assert.AreEqual(expectedShowingStallPrice, actualShowingStallPrice);
        }
        public void testEditShowing()
        {
            ShowingsClass.editShowingDetails(2, "2017-06-22 12:00", 7, 2, 1);
            dataSet = ShowingsClass.getShowingByShowingId(2);

            string actualShowingDate             = dataSet.Tables[0].Rows[0]["Date"].ToString();
            double actualShowingUpperCirclePrice = double.Parse(dataSet.Tables[0].Rows[0]["UpperCirclePrice"].ToString());
            double actualShowingDressCirclePrice = double.Parse(dataSet.Tables[0].Rows[0]["DressCirclePrice"].ToString());
            double actualShowingStallPrice       = double.Parse(dataSet.Tables[0].Rows[0]["StallsPrice"].ToString());

            string expectedShowingDate             = "2017-06-22 12:00";
            double expectedShowingUpperCirclePrice = 7;
            double expectedShowingDressCirclePrice = 2;
            double expectedShowingStallPrice       = 1;

            Assert.AreEqual(expectedShowingDate, actualShowingDate);
            Assert.AreEqual(expectedShowingUpperCirclePrice, actualShowingUpperCirclePrice);
            Assert.AreEqual(expectedShowingDressCirclePrice, actualShowingDressCirclePrice);
            Assert.AreEqual(expectedShowingStallPrice, actualShowingStallPrice);
        }
 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");
     }
 }
Exemple #13
0
 private void DeleteShowing_button_Click(object sender, RoutedEventArgs e)
 {
     if (SelectDate_EditDelShow.SelectedDate == null)
     {
         MessageBox.Show("Please select a date for the required showing");
     }
     else
     {
         MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure?", "Delete Confirmation", MessageBoxButton.YesNo);
         if (messageBoxResult == MessageBoxResult.Yes)
         {
             ShowingsClass.deleteShowing(ShowingsClass.getShowingIdByDate(ShowingsClass.formatDateTimeToSqlLiteDateString((DateTime)SelectDate_EditDelShow.SelectedDate)));
             MessageBox.Show("Showing deleted");
             this.Close();
             BookingOfficerWindow newBookingOfficerWindow = new BookingOfficerWindow();
             newBookingOfficerWindow.Show();
             //fillDatePicker(this.SelectDate_EditDelShow);
         }
         else
         {
             MessageBox.Show("Delete cancelled");
         }
     }
 }
Exemple #14
0
        private void CreateShowing_button_Click(object sender, RoutedEventArgs e)
        {
            if (Play_AddShowing_combo.Items.Count == 0)
            {
                MessageBox.Show("Please enter a play to search for");
            }
            else
            {
                KeyValuePair <int, string> test = (KeyValuePair <int, string>) this.Play_AddShowing_combo.SelectedValue;
                int playId = int.Parse((test.Key).ToString());

                dataSet = PlaysClass.getPlayDetailsById(playId);
                int playLength = int.Parse(dataSet.Tables[0].Rows[0]["Length"].ToString());

                string startTime       = StartTime_AddShowing_txt.Text;
                string timeToBeChecked = ValidationClass.TimeChecker(startTime);

                if (timeToBeChecked != null)
                {
                    MessageBox.Show(timeToBeChecked);
                }
                else
                {
                    //var startTimeCharArray = startTime.ToCharArray();
                    //string startHour = startTimeCharArray[0].ToString() + startTimeCharArray[1].ToString();
                    //string startMinutes = startTimeCharArray[3].ToString() + startTimeCharArray[4].ToString();

                    //DateTime startDateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day,
                    //    int.Parse(startHour), int.Parse(startMinutes), 0);

                    //DateTime endDateTime = startDateTime.AddMinutes(playLength);
                    //string endTime = endDateTime.Hour + ":" + endDateTime.Minute;

                    DateTime?startDate = this.StartDate_AddShowing.SelectedDate;
                    DateTime?endDate   = this.EndDate_AddShowing.SelectedDate;
                    if (startDate > endDate)
                    {
                        MessageBox.Show("Start date must be earlier than End date");
                    }
                    else
                    {
                        string priceToBeChecked = UpperCircle_AddShowing_txt.Text.ToString();
                        priceToBeChecked = ValidationClass.FloatChecker(priceToBeChecked);
                        if (priceToBeChecked != null)
                        {
                            MessageBox.Show(priceToBeChecked);
                        }
                        else
                        {
                            float upperCirclePrice = float.Parse(this.UpperCircle_AddShowing_txt.Text.ToString());

                            priceToBeChecked = DressCircle_AddShowing_txt.Text.ToString();
                            priceToBeChecked = ValidationClass.FloatChecker(priceToBeChecked);
                            if (priceToBeChecked != null)
                            {
                                MessageBox.Show(priceToBeChecked);
                            }
                            else
                            {
                                float dressCirclePrice = float.Parse(this.DressCircle_AddShowing_txt.Text.ToString());

                                priceToBeChecked = Stalls_AddShowing_txt.Text.ToString();
                                priceToBeChecked = ValidationClass.FloatChecker(priceToBeChecked);
                                if (priceToBeChecked != null)
                                {
                                    MessageBox.Show(priceToBeChecked);
                                }
                                else
                                {
                                    float stallPrice = float.Parse(this.Stalls_AddShowing_txt.Text.ToString());
                                    if (this.StartDate_AddShowing.SelectedDate == null || this.EndDate_AddShowing.SelectedDate == null)
                                    {
                                        MessageBox.Show("please enter start and end date");
                                    }
                                    else
                                    {
                                        bool sqlQuerryState = ShowingsClass.makeShowings((DateTime)startDate, (DateTime)endDate, startTime, playId, upperCirclePrice, dressCirclePrice, stallPrice);
                                        if (sqlQuerryState == true)
                                        {
                                            MessageBox.Show("Showing added");
                                            fillDatePicker(this.SelectDate_EditDelShow);
                                        }
                                        else
                                        {
                                            MessageBox.Show("conclict with current showing");
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
        private void UpgradeMember_button_Click(object sender, RoutedEventArgs e)
        {
            if (SurnameSearch_UpgradeMember_combo.Items.Count == 0)
            {
                MessageBox.Show("Please enter a customer name to search for");
            }
            else
            {
                int chosenCustomerID = int.Parse(this.SurnameSearch_UpgradeMember_combo.SelectedValue.ToString());
                dataSet = CustomerClass.getCustomerById(chosenCustomerID);

                CustomerClass.editCustomerDetails(chosenCustomerID, dataSet.Tables[0].Rows[0]["First_Name"].ToString(), dataSet.Tables[0].Rows[0]["Last_Name"].ToString(), dataSet.Tables[0].Rows[0]["Email"].ToString(), ShowingsClass.formatDateTimeToSqlLiteDateString(DateTime.Now.AddMonths(12)));
                MessageBox.Show("Customer changed to gold club member");
            }
        }
        //---------------------------------------------- Add Member Tab ------------------------------------------------------//
        private void CreateMember_button_Click(object sender, RoutedEventArgs e)
        {
            string mFirstName = Forename_AddMember_txt.Text.ToString();

            if (mFirstName.Length == 0)
            {
                MessageBox.Show("Please enter a Forename");
            }
            else
            {
                string stringToBeChecked = ValidationClass.HasNumbersInStringChecker(mFirstName);
                if (stringToBeChecked != null)
                {
                    MessageBox.Show("Forename cannot contain numbers");
                }
                else
                {
                    string mLastName = Surname_AddMember_txt.Text.ToString();
                    if (mLastName.Length == 0)
                    {
                        MessageBox.Show("Please enter a Surname");
                    }
                    else
                    {
                        stringToBeChecked = ValidationClass.HasNumbersInStringChecker(mLastName);
                        if (stringToBeChecked != null)
                        {
                            MessageBox.Show("Surname cannot contain numbers");
                        }
                        else
                        {
                            string mEmail = Email_AddMember_txt.Text.ToString();
                            if (mEmail.Length == 0)
                            {
                                MessageBox.Show("Please enter an Email");
                            }
                            else
                            {
                                if (CustomerClass.checkIfEmailExits(mEmail) == true)
                                {
                                    MessageBox.Show("This email already exists - Please enter another email");
                                }
                                else
                                {
                                    if (GoldMember_checkbox.IsChecked == true)
                                    {
                                        var    currentTime           = ShowingsClass.formatDateTimeToSqlLiteDateString(DateTime.Now.AddMonths(12));
                                        string mMembershipExpiryDate = currentTime.ToString();

                                        CustomerClass.newCustomer(mFirstName, mLastName, mEmail, mMembershipExpiryDate);
                                        MessageBox.Show("Customer added");
                                    }
                                    else
                                    {
                                        CustomerClass.newCustomer(mFirstName, mLastName, mEmail, null);
                                        MessageBox.Show("Customer added");
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
        private void fillDatePicker(DatePicker pDatePicker, int pId)
        {
            pDatePicker.BlackoutDates.Clear();
            pDatePicker.BlackoutDates.AddDatesInPast();
            List <DateTime> dateList = new List <DateTime>();
            DataSet         dataSet  = ShowingsClass.getShowingForPlays(pId);

            //DataSet dataSet = ShowingsClass.getAllShowings();
            foreach (DataRow row in dataSet.Tables[0].Rows)
            {
                int      tempShowingId = int.Parse(row["Showing_Id"].ToString());
                DateTime showingDate   = ShowingsClass.turnSqlLiteDateStringIntoDateTime(row["Date"].ToString());
                if (showingDate >= DateTime.Now)
                {
                    dateList.Add(showingDate);
                }
            }
            dateList.Sort();

            //if (dateList.Count != 0)
            //{
            //    DateTime nextStartDate = DateTime.Now.AddDays(-1);
            //    int count = 1;
            //    foreach (DateTime showingDateFromList in dateList)
            //    {
            //        if (count < dateList.Count)
            //        {
            //            nextStartDate = showingDateFromList;
            //            if (showingDateFromList.AddDays(1).Date == dateList[count].Date)
            //            {
            //                //next date in list is for next day so do nothing
            //            }
            //            else
            //            {
            //                pDatePicker.BlackoutDates.Add(new CalendarDateRange(nextStartDate.AddDays(1), dateList[count].AddDays(-1)));
            //            }
            //            count = count + 1;
            //        }
            //    }
            //    pDatePicker.BlackoutDates.Add(new CalendarDateRange(dateList[count - 1].AddDays(1), nextStartDate.AddYears(500)));
            //    pDatePicker.BlackoutDates.Add(new CalendarDateRange(DateTime.Now, dateList[0].AddDays(-1)));
            //}
            //else
            //{
            //    pDatePicker.BlackoutDates.Add(new CalendarDateRange(DateTime.Now, DateTime.Now.AddYears(500)));
            //}

            if (dateList.Count == 0)
            {
                pDatePicker.BlackoutDates.Add(new CalendarDateRange(DateTime.Now, DateTime.Now.AddYears(1)));
            }
            else
            {
                DateTime startDate = DateTime.Now;
                for (int i = 0; i < dateList.Count; i++)
                {
                    if (startDate.Date != dateList[i].Date)
                    {
                        pDatePicker.BlackoutDates.Add(new CalendarDateRange(startDate, dateList[i].AddDays(-1)));
                    }
                    startDate = dateList[i].AddDays(1);
                }
                pDatePicker.BlackoutDates.Add(new CalendarDateRange(startDate, startDate.AddMonths(12)));
            }
        }
        private void AddToBasket_button_Click(object sender, RoutedEventArgs e)
        {
            if (ChoosePlay_combo.Items.Count == 0)
            {
                MessageBox.Show("Please Choose a play");
            }
            else
            {
                if (SelectDate_Booking.SelectedDate == null)
                {
                    MessageBox.Show("Please enter a showing date");
                }
                else
                {
                    if (UpperCircle_radio.IsChecked == false && DressCircle_radio.IsChecked == false && Stalls_radio.IsChecked == false)
                    {
                        MessageBox.Show("Please check a seating area");
                    }
                    else
                    {
                        if (Rows_combo.SelectedValue == null)
                        {
                            MessageBox.Show("Please select a seat row");
                        }
                        else
                        {
                            if (Seat_combo.SelectedValue == null)
                            {
                                MessageBox.Show("Please select a seat number");
                            }
                            else
                            {
                                string area;

                                if (UpperCircle_radio.IsChecked == true)
                                {
                                    area = "UpperCircle";
                                }
                                else if (DressCircle_radio.IsChecked == true)
                                {
                                    area = "DressCircle";
                                }
                                else
                                {
                                    area = "Stall";
                                }

                                string sqlDateString = ShowingsClass.formatDateTimeToSqlLiteDateString((DateTime)SelectDate_Booking.SelectedDate);
                                int    showingId     = ShowingsClass.getShowingIdByDate(sqlDateString);

                                string row = this.Rows_combo.SelectedValue.ToString();
                                int    num = int.Parse(this.Seat_combo.SelectedValue.ToString());

                                //DataRow rowCheck = seatBookingsDataset.NewRow();
                                //rowCheck["Section"] = area;
                                //rowCheck["Row"] = row;
                                //rowCheck["Number"] = num;
                                bool cannAddToBasket = true;
                                foreach (DataRow loopRow in seatBookingsDataset.Rows)
                                {
                                    if (loopRow["Section"].ToString() == area && loopRow["Row"].ToString() == row && int.Parse(loopRow["Number"].ToString()) == num)
                                    {
                                        cannAddToBasket = false;
                                    }
                                }
                                if (cannAddToBasket == false)
                                {
                                    MessageBox.Show("Seat already in basket");
                                }
                                else
                                {
                                    if (seatBookingsDataset.Rows.Count < 6)
                                    {
                                        seatBookingsDataset.Rows.Add(area, row, num);
                                        this.UpperCircle_radio.IsChecked = false;
                                        this.DressCircle_radio.IsChecked = false;
                                        this.Stalls_radio.IsChecked      = false;
                                        this.Rows_combo.Items.Clear();
                                        this.Seat_combo.Items.Clear();
                                    }
                                }

                                //SeatBookingClass seatBookingObj = new SeatBookingClass(area, row, num, showingId);
                            }
                        }
                    }
                }
            }
        }