private static void fillPassengers() { int passID = PassengerInfo.accessPassenger(); while (!PassengerInfo.emptyPassenger()) { ResetSeat(passID); deletePassengers(passID); PassengerInfo.removePassengers(); } }
private static void clearSeats() { PassengerInfo.loadPassengersReserve(ReserveP.getTicketID()); SQLConnection.Instance.OpenConnection(); fillPassengers(); SQLConnection.Instance.CloseConnection(); //MessageBox.Show("Reservation Succesfully Removed."); }
private void fillPassenger() { PassengerID = PassengerInfo.accessPassenger(); PassengerInfo.LoadPassengerInfo(PassengerID); firstName = PassengerInfo.passengerObject[0].getFirstName(); midName = PassengerInfo.passengerObject[0].getMidName(); lastName = PassengerInfo.passengerObject[0].getLastName(); Age = PassengerInfo.passengerObject[0].getAge(); gender = PassengerInfo.passengerObject[0].getGender(); birthdate = PassengerInfo.passengerObject[0].getDate(); }
private void RefreshForm() { adult = 0; child = 0; infant = 0; remove_comboBox1.SelectedIndex = -1; remove_comboBox1.Items.Clear(); PassengerInfo.loadPassengersReserve(ReserveP.getTicketID()); fillComboBox(); //remove_comboBox1.Refresh(); }
private static void deleteReservation() { PassengerInfo.loadPassengersReserve(ticketID); fareID = Price.getReserveFareID(ticketID); SQLConnection.Instance.OpenConnection(); fillPassengers(); removeReservation(ticketID); removeFare(fareID); SQLConnection.Instance.CloseConnection(); MessageBox.Show("Reservation Succesfully Removed."); }
private void seat_select_button_Click_1(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(); //updates flight to new flight MySqlCommand passengerFlight = new MySqlCommand("UPDATE Passenger Set FlightID = '" + flightNumber + "' where PassengerID = '" + PassengerID + "' ;", SQLConnection.Instance.GetConnection()); passengerFlight.ExecuteNonQuery(); SQLConnection.Instance.CloseConnection(); //testing this //PassengerContainer.removePassengers(); PassengerInfo.removePassengers(); if (!PassengerInfo.emptyPassenger()) { this.Close(); Seating_Update another = new Seating_Update(); } else { Payment_Update payup = new Payment_Update(); this.Close(); //MessageBox.Show("Payment next"); } } }
private void fillText() { int numofpassengers = 0; countPassengers = PassengerInfo.getNumPassengers(); int maxofpassengers = countPassengers; reserve_richTextBox1.ReadOnly = true; reserve_richTextBox1.Text = "Showing " + maxofpassengers + " Passenger(s) information: \n"; while (numofpassengers < maxofpassengers) { reserve_richTextBox1.Text += "\nPassenger: " + PassengerInfo.getPassenger(); reserve_richTextBox1.Text += "\nSeat Information: " + PassengerInfo.getSeatInfo() + "\n"; numofpassengers++; } reserve_richTextBox1.Text += "\n"; }
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()); seatCommand.ExecuteNonQuery(); //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(); //updates flight to new flight MySqlCommand passengerFlight = new MySqlCommand("UPDATE Passenger Set FlightID = '" + flightNumber + "' where PassengerID = '" + PassengerID + "' ;", SQLConnection.Instance.GetConnection()); passengerFlight.ExecuteNonQuery(); SQLConnection.Instance.CloseConnection(); Price.Discount(); PassengerInfo.removePassengers(); if (!PassengerInfo.emptyPassenger()) { this.Close(); Seating_Update another = new Seating_Update(); } else { Payment_Update payup = new Payment_Update(); this.Close(); //MessageBox.Show("Payment next"); } }
private void button1_Click(object sender, EventArgs e) { checkChanges(); PassengerInfo.removePassengers(); if (!PassengerInfo.emptyPassenger()) { clearForm(); fillPassenger(); fillText(); RefreshForm(); } else { MessageBox.Show("Confirmationn of Changes Emailed send shortly."); Passenger_Changes.fillEmail(); this.Close(); Reserve_Update back2back = new Reserve_Update(); } }
public static void LoadPassengerInfo(int passNumber) { DataSet dsPasssenger = new DataSet(); SQLConnection.Instance.OpenConnection(); MySqlCommand findPassengers = new MySqlCommand("select * from Passenger where PassengerID = '" + passNumber + "';", SQLConnection.Instance.GetConnection()); MySqlDataAdapter daPassenger = new MySqlDataAdapter(findPassengers); daPassenger.Fill(dsPasssenger); SQLConnection.Instance.CloseConnection(); passengerObject[0] = new PassengerInfo(); DataRow dataRow = dsPasssenger.Tables[0].Rows[0]; passengerObject[0].setFirstName((string)dataRow[1]); passengerObject[0].setMidName((string)dataRow[2]); passengerObject[0].setLastName((string)dataRow[3]); passengerObject[0].setAge((string)dataRow[4]); passengerObject[0].setGender((string)dataRow[5]); passengerObject[0].setDate((DateTime)dataRow[6]); }
private void SFlight_Click(object sender, EventArgs e) { if (FlightP.getFlightNumber() == 0) { getFirst(); } int newflight = FlightP.getFlightNumber(); ReserveP.setFlightNumber(ReserveP.getTicketID()); int oldflight = ReserveP.getFlightNumber(); //MessageBox.Show("Selected: 3:" + newflight.ToString() + " Reservation: 1:" + oldflight.ToString()); //keep user from entering same flight again if (newflight == oldflight) { MessageBox.Show("Please select a different flight."); Arrival_combobox.SelectedIndex = -1; Depart_Date.Value = System.DateTime.Now; int zero = 0; FlightP.setFlightNumber(zero); } else { // clear reservation seats from previous flight // load passengers to pick new seat on this flight clearSeats(); PassengerInfo.loadPassengersReserve(ReserveP.getTicketID()); Price.loadPrices(FlightP.getFlightNumber()); Price.resetDiscount(); Seating_Update newseats = new Seating_Update(); this.Close(); } }
private void fillPassenger() { PassengerID = PassengerInfo.accessPassenger(); PassengerInfo.LoadPassengerInfo(PassengerID); firstName = PassengerInfo.passengerObject[0].getFirstName(); lastName = PassengerInfo.passengerObject[0].getLastName(); Age = PassengerInfo.passengerObject[0].getAge(); if (Age == "Adult") { adult++; } else if (Age == "Children") { child++; } else { infant++; } name = PassengerID + " " + firstName + " " + lastName + " " + Age; remove_comboBox1.Items.Add(name); }
private void getPassengerInfo() { PassengerInfo.loadPassengersReserve(ticketID); }
/// <summary> /// Gets passsenger first and last name to display in the label of the form. /// </summary> private void getPassenger() { PassengerInfo.setPassengerID(PassengerInfo.accessPassenger()); PassengerInfo.LoadPassengerInfo(PassengerInfo.getPassengerID()); pass_info_label.Text = "Passenger: " + PassengerInfo.passengerObject[0].getFirstName() + " " + PassengerInfo.passengerObject[0].getLastName(); }