private void button3_Click(object sender, EventArgs e) //btnBook { //if Book Ticket button is clicked try { //first validate and check if the class and payment methods are selected if ((cmbClass.Text == "") || (cmbPmt.Text == "")) { MessageBox.Show("Please make sure you choose a Payment Method and Flight Class", "Select Payment and Class", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else {//then save all to booking table //assigning the form detalis into class variable to store in database bookClass = new BookingClass(); bookClass.FlightID = txtFlight.Text; bookClass.CustomerID = txtCustomer.Text; bookClass.From = lblFrom.Text; bookClass.To = lblTo.Text; bookClass.PmtMetd = cmbPmt.Text; bookClass.NumSeats = Convert.ToInt32(lblSeat.Text); bookClass.TotalFare = Convert.ToDouble(txtFare.Text) * Convert.ToDouble(lblRate.Text); txtTotFare.Text = Convert.ToString(bookClass.TotalFare); bookClass.addBooking(); char seatRow; int seatNum; int rowNumber; //update seatRecords in database seatClass seatObj = new seatClass(); seatObj.loadSeats(Convert.ToInt32(bookClass.FlightID)); for (int i = 0; i < seatObj.seatCount; i++) { //get row and number from seat class and assign here seatRow = seatObj.seatObject[i].SeatRow; seatNum = seatObj.seatObject[i].SeatNumber; rowNumber = (int)seatRow - 64; //take seatrow above and subtract from 64 coz we added before to get ascii here we subtract if (seatStat[seatNum, rowNumber] == 2) //seatStat is just the array variable assigned top { //send to update seat class, which turns seat==2 into seat ==1 i.e.booked seatObj.updateSeat(Convert.ToInt32(bookClass.FlightID), seatRow, seatNum, Convert.ToInt32(bookClass.BookingID)); } } MessageBox.Show("Data added successfully! Booking Completed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { MessageBox.Show("Error: " + ex, "Exception Error"); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { //take flight id from comboBox selection int f = int.Parse(cbFlightID.Text); // Load the seats for the selected flights stClass.loadSeats(f); for (int i = 0; i < stClass.seatCount; i++) { //gettinig seatrow, seatnum and available char c = stClass.seatObject[i].SeatRow; int r = (int)c - 64; //subtract 64 and change back to integer,eg A = 65-64= 1 int s = stClass.seatObject[i].SeatNumber; int available = stClass.seatObject[i].Available; seatStatus[s, r] = available; //integer available assigned to array we declare top } int totalButtons = pnlPlane.Controls.Count; //now to remove the extra buttons that we have offset or removed from above for (int i = 0; i < totalButtons; i++) { //existing seatbuttons removed from panel when selectedindex change pnlPlane.Controls.RemoveAt(0); } //DISPLAY PRICE FROM BOOK CLASS bookClass.getFlightDetails(Convert.ToString(f)); label4.Text = Convert.ToString(bookClass.TotalFare); drawPlan();//call the draw plan method for each flight changed } catch (NullReferenceException ex0) { MessageBox.Show("Error! Please select a valid flight from dropdown box \r\nException Error : " + ex0.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex1) { MessageBox.Show("Error! \r\nException Error : " + ex1.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { //load the seat for the selected flight int f = Convert.ToInt32(comboBox1.Text); bookClass.getFlightDetails(Convert.ToString(f)); label3.Text = Convert.ToString(bookClass.TotalFare); seatClass stCl = new seatClass(); stCl.loadSeats(f); double totSales = 0; for (int i = 0; i < stCl.seatCount; i++) { char c = stCl.seatObject[i].SeatRow; int r = ((int)c) - 64; int s = stCl.seatObject[i].SeatNumber; int available = stCl.seatObject[i].Available; seatStatus[s, r] = available; if (available == 1) { totSales += Convert.ToInt32(label3.Text); //adding totSales with the fare for each seat } } int totalButtons = panel1.Controls.Count; for (int i = 0; i < totalButtons; i++) { panel1.Controls.RemoveAt(0); } //now drawPlan drawPlan(); textBox1.Text = totSales.ToString(); }