internal static MySqlCommand BuildInsertPassengerFareCommand(int flightId, PassengerType passengerType, int quantity,
string classofServices, string fareBasisCode, string currency, decimal baseFare, decimal totalTax, decimal totalFees,
decimal totalMarkup, decimal totalFare, MySqlConnection connection)
{
var cmd = new MySqlCommand("spInsertPassengerFare", connection) { CommandType = CommandType.StoredProcedure };
cmd.Parameters.Add(new MySqlParameter("inFlightId", flightId));
cmd.Parameters.Add(new MySqlParameter("inPassengerType", passengerType.ToString()));
cmd.Parameters.Add(new MySqlParameter("inCount", quantity));
cmd.Parameters.Add(new MySqlParameter("inClassesOfService", classofServices));
cmd.Parameters.Add(new MySqlParameter("inFareBasisCodes", fareBasisCode));
cmd.Parameters.Add(new MySqlParameter("inCurrency", currency));
cmd.Parameters.Add(new MySqlParameter("inBaseFare", baseFare));
cmd.Parameters.Add(new MySqlParameter("inTotalTax", totalTax));
cmd.Parameters.Add(new MySqlParameter("inTotalFee", totalFees));
cmd.Parameters.Add(new MySqlParameter("inTotalMarkup", totalMarkup));
cmd.Parameters.Add(new MySqlParameter("inTotalFare", totalFare));
cmd.Parameters.Add(new MySqlParameter("inAddedOn", DateTime.Now));
return cmd;
}
internal static MySqlCommand BuildInsertFareComponentCommand(int flightId,
PassengerType passengerType, string componentType, decimal amount, string name, MySqlConnection connection)
{
var cmd = new MySqlCommand("spInsertPassengerFareComponent", connection) { CommandType = CommandType.StoredProcedure };
cmd.Parameters.Add(new MySqlParameter("inFlightId", flightId));
cmd.Parameters.Add(new MySqlParameter("inPassengerType", passengerType.ToString()));
cmd.Parameters.Add(new MySqlParameter("inComponentType", componentType));
cmd.Parameters.Add(new MySqlParameter("inName", name));
cmd.Parameters.Add(new MySqlParameter("inAmount", amount));
cmd.Parameters.Add(new MySqlParameter("inAddedOn", DateTime.Now));
cmd.Parameters.Add(new MySqlParameter("outComponentId", MySqlDbType.Int32));
cmd.Parameters["outComponentId"].Direction = ParameterDirection.Output;
return cmd;
}
