private void fillText() { int numofpassengers = 0; int maxofpassengers = PassengerContainer.getNumPassenger(); richTextBox1.ReadOnly = true; richTextBox1.Text = "Showing " + maxofpassengers + " Passenger(s) information: \n"; while (numofpassengers < maxofpassengers) { richTextBox1.Text += "\nPassenger: " + ReserveP.getPassenger(); richTextBox1.Text += "\nSeat Information: " + ReserveP.getSeatInfo() + "\n"; numofpassengers++; } SQLConnection.Instance.OpenConnection(); insertReserve(); insertTicket(); SQLConnection.Instance.CloseConnection(); fillEmail(); MessageBox.Show("Email Confirmation of Reservation send shortly."); }
/// <summary> /// Seat button Calls the class Passenger Container that will save all the passengers in a list to use for the seat form. /// The seat form is created and Passenger's form is closed. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void seat_button2_Click(object sender, EventArgs e) { //fill passenger list in class //PassengerContainer.loadPassengers(FlightP.getFlightNumber(), AccountP.getAccountID()); PassengerContainer.loadPassengers(FlightP.getFlightNumber(), AccountP.getAccountID()); Price.loadPrices(FlightP.getFlightNumber()); Price.resetDiscount(); Seating nfseat = new Seating(); this.Close(); }
public static string getPassenger() { string pstr; string firstname, midname, lastname, age, gender, birthdate; DateTime birth; tempID = PassengerContainer.accessPassenger(); DataSet dsPassenger = new DataSet(); SQLConnection.Instance.OpenConnection(); MySqlCommand passData = new MySqlCommand(); MySqlDataAdapter daPass = new MySqlDataAdapter("select * from Passenger where PassengerID = '" + tempID + "';", SQLConnection.Instance.GetConnection()); daPass.Fill(dsPassenger); SQLConnection.Instance.CloseConnection(); DataRow dataRow = dsPassenger.Tables[0].Rows[0]; firstname = (string)dataRow[1]; midname = (string)dataRow[2]; lastname = (string)dataRow[3]; age = (string)dataRow[4]; gender = (string)dataRow[5]; birth = (DateTime)dataRow[6]; PassengerContainer.removePassengers(); string date = birth.ToString("d"); birthdate = DateTime.Parse(date).ToString("MM-dd-yyyy"); if (string.IsNullOrEmpty(midname)) { midname = " "; } else { midname = " " + midname + " "; } age = getAge(age); pstr = firstname + midname + lastname + "\nAge: " + age + " Gender: " + gender + " Birthdate: " + birthdate; return(pstr); }
/// <summary> /// stores the passengers in list so the form can loop back to /// add their information to our database /// </summary> private void fillPassenger() { acount = PassengerContainer.getAdultPassengers(); ccount = PassengerContainer.getChildPassengers(); icount = PassengerContainer.getInfantPassengers(); //adult group if (acount != 0) { int count = 0; if (acount > count) { while (count < acount) { adultList.Add(count); count++; } } } //child group if (ccount != 0) { int index = 0; if (ccount > index) { while (index < ccount) { childrenList.Add(index); index++; } } } if (icount != 0) { int track = 0; if (acount > track) { while (track < icount) { infantsList.Add(track); track++; } } } }
/// <summary> /// Saves the seat chosen by user to the corresponding passenger in the database. /// Removes passenger from passenger list and calls next passenger and /// if passenger list is empty the form opens the payment form /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void seat_select_button_Click(object sender, EventArgs e) { if (select_count > 1) { MessageBox.Show(select_count.ToString() + " seats selected. Please select only one seat"); } else { SQLConnection.Instance.OpenConnection(); MySqlCommand seatCommand = new MySqlCommand("UPDATE Seat Set Available = 1 where FlightID = '" + flightNumber + "' AND classSeat = '" + Seat.getClassSeat() + "' AND Row = '" + jlocation + "' AND selectSeat = '" + ilocation + "';", SQLConnection.Instance.GetConnection()); MySqlCommand findseatCommand = new MySqlCommand("select SeatID from Seat where FlightID = '" + flightNumber + "' AND classSeat = '" + Seat.getClassSeat() + "' AND Row = '" + jlocation + "' AND selectSeat = '" + ilocation + "';", SQLConnection.Instance.GetConnection()); seatCommand.ExecuteNonQuery(); Seat.setSeatPassenger(Convert.ToInt32(findseatCommand.ExecuteScalar())); //passengerID carrier //check MySqlCommand passengerEnter = new MySqlCommand("UPDATE Passenger Set SeatID = '" + Seat.getSeatPassenger() + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection()); passengerEnter.ExecuteNonQuery(); //class into passenger table MySqlCommand passengerClass = new MySqlCommand("UPDATE Passenger Set Class = '" + Seat.getClassSeat() + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection()); passengerClass.ExecuteNonQuery(); SQLConnection.Instance.CloseConnection(); //MessageBox.Show("Seat Reserved on Row: " + jlocation.ToString() + " Column: " + ilocation.ToString() + " SeatID: " + Seat.getSeatPassenger() + " For Passenger: " + PassengerContainer.getPassengerID()); //testing this PassengerContainer.removePassengers(); if (!PassengerContainer.emptyPassenger()) { this.Close(); Seating nextperson = new Seating(); } else { this.Close(); Payment payhere = new Payment(); } } }
/// <summary> /// Gets passsenger first and last name to display in the label of the form. /// </summary> private void getPassenger() { PassengerContainer.setPassengerID(PassengerContainer.accessPassenger()); string FirstName, LastName; SQLConnection.Instance.OpenConnection(); MySqlCommand findFirst = new MySqlCommand("select FirstName from Passenger where PassengerID = '" + PassengerContainer.getPassengerID() + "';", SQLConnection.Instance.GetConnection()); FirstName = (string)findFirst.ExecuteScalar(); MySqlCommand findLast = new MySqlCommand("select LastName from Passenger where PassengerID = '" + PassengerContainer.getPassengerID() + "';", SQLConnection.Instance.GetConnection()); LastName = (string)findLast.ExecuteScalar(); pass_info_label.Text = "Passenger: " + FirstName + " " + LastName; SQLConnection.Instance.CloseConnection(); }
/// <summary> /// This function saves the number of adult, child and/or infants that were selected in the comboboxes /// to use in the passenger and seat form /// </summary> private void getPassengers() { if (adult_comboBox1.SelectedItem != null) { //Start.adultPassengers = int.Parse(adult_comboBox1.SelectedItem.ToString()); PassengerContainer.setAdultPassengers(int.Parse(adult_comboBox1.SelectedItem.ToString())); } if (child_comboBox2.SelectedItem != null) { //Start.childPassengers = int.Parse(child_comboBox2.SelectedItem.ToString()); PassengerContainer.setChildPassengers(int.Parse(child_comboBox2.SelectedItem.ToString())); } if (infant_comboBox3.SelectedItem != null) { //Start.infantPassengers = int.Parse(infant_comboBox3.SelectedItem.ToString()); PassengerContainer.setInfantPassengers(int.Parse(infant_comboBox3.SelectedItem.ToString())); } }
private void button1_Click(object sender, EventArgs e) { int seatID = Seat.randomSeat(Seat.getClassSeat(), airplaneTotaSeats, flightNumber); SQLConnection.Instance.OpenConnection(); MySqlCommand seatCommand = new MySqlCommand("UPDATE Seat Set Available = 1 where SeatID = '" + seatID + "';", SQLConnection.Instance.GetConnection()); //MySqlCommand findseatCommand = new MySqlCommand("select SeatID from Seat where FlightID = '" + FlightP.getFlightNumber() + "' AND classSeat = '" + Seat.getClassSeat() + "' AND Row = '" + jlocation + "' AND selectSeat = '" + ilocation + "';", SQLConnection.Instance.GetConnection()); seatCommand.ExecuteNonQuery(); //Seat.setSeatPassenger(Convert.ToInt32(findseatCommand.ExecuteScalar())); //Seat.setSeatPassenger(seatID); //passengerID carrier //check MySqlCommand passengerEnter = new MySqlCommand("UPDATE Passenger Set SeatID = '" + seatID + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection()); passengerEnter.ExecuteNonQuery(); //class into passenger table MySqlCommand passengerClass = new MySqlCommand("UPDATE Passenger Set Class = '" + Seat.getClassSeat() + "' where PassengerID = '" + PassengerID + "';", SQLConnection.Instance.GetConnection()); passengerClass.ExecuteNonQuery(); SQLConnection.Instance.CloseConnection(); Price.Discount(); PassengerContainer.removePassengers(); if (!PassengerContainer.emptyPassenger()) { this.Close(); Seating nextperson = new Seating(); } else { this.Close(); Payment payhere = new Payment(); } }
private void fillGrid() { PassengerContainer.loadPassengers(FlightP.getFlightNumber(), AccountP.getAccountID()); }