private List<Passenger> GetPassengers(string requestId, MySqlDatabase db) { var passengerlist = new List<Passenger>(); DataSet dataset = db.ExecuteQuery(CommandBuilder.BuildGetPassengersRequest(requestId, db.Connection)); if (dataset != null && dataset.Tables.Count > 0) { if (dataset.Tables[0].Rows != null && dataset.Tables[0].Rows.Count > 0) { foreach (DataRow row in dataset.Tables[0].Rows) { if (!Convert.IsDBNull(row["PassengerId"]) && !Convert.IsDBNull(row["RequestId"])) { var passenger = new Passenger { PassengerId = row["PassengerId"].GetString(), Title = row["Title"].GetString(), FirstName = row["FirstName"].GetString(), LastName = row["LastName"].GetString(), Gender = row["Gender"].GetString(), DateOfBirth = row["DateOfBirth"].GetDate() }; passengerlist.Add(passenger); } } } } return passengerlist; }
internal static MySqlCommand BuildSavePassenger(Passenger passenger, string requestId, MySqlConnection connection) { var cmd = new MySqlCommand("spSavePassenger", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.Add(new MySqlParameter("intitle", passenger.Title)); cmd.Parameters.Add(new MySqlParameter("infirstname", passenger.FirstName)); cmd.Parameters.Add(new MySqlParameter("inlastname", passenger.LastName)); cmd.Parameters.Add(new MySqlParameter("indateOfBirth", passenger.DateOfBirth)); cmd.Parameters.Add(new MySqlParameter("ingender", passenger.Gender)); cmd.Parameters.Add(new MySqlParameter("inrequestId", requestId)); return cmd; }
private static bool SavePassenger(int flightId, Passenger passenger) { var db = new MySqlDatabase(DbConfiguration.ReservationDB); var cmd = CommandBuilder.BuildInsertFlightPassengerCommand(flightId, passenger.FirstName, passenger.LastName, passenger.Title, passenger.DateOfBirth, passenger.Gender, db.Connection); int passengerId; db.ExecuteNonQuery(cmd, "outPassengerId", out passengerId); passenger.PassengerId = passengerId.ToString(); return true; }
private static AirTravelerType GetTravellerDetails(Passenger passenger, Account account, string rph) { int age = passenger.GetAge(); string paxCode = "CNN"; if(age < 2) paxCode = "INF"; else if(age >=12 ) paxCode = "ADT"; string title; if (string.Equals(paxCode, "CNN")) title = string.Equals(passenger.Gender, "Male") ? "Master" : "Miss"; else title = passenger.Title; AirTravelerType traveller = new AirTravelerType() { PassengerTypeCode = paxCode, PersonName = new PersonNameType() { NamePrefix = new string[] { title }, GivenName = new string[] { passenger.FirstName }, Surname = passenger.LastName }, BirthDateSpecified = true, BirthDate = passenger.DateOfBirth, TravelerRefNumber = new AirTravelerTypeTravelerRefNumber() { RPH = rph }, }; return traveller; }