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;
}
