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