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