private void ExecuteQuery(PassengerNameRecordModel passengerNameRecordModel, string query)
{
var parameters = new DynamicParameters();
parameters.Add("Id", passengerNameRecordModel.Id);
parameters.Add("QueueId", passengerNameRecordModel.QueueId);
parameters.Add("Number", passengerNameRecordModel.Number);
parameters.Add("Quantity", passengerNameRecordModel.Quantity);
parameters.Add("SurName", passengerNameRecordModel.SurName);
parameters.Add("Type", passengerNameRecordModel.Type);
parameters.Add("Date1", passengerNameRecordModel.Date1);
parameters.Add("Date2", passengerNameRecordModel.Date2);
parameters.Add("Date3", passengerNameRecordModel.Date3);
parameters.Add("DepartureDate", passengerNameRecordModel.DepartureDate);
parameters.Add("DepartureAirport", passengerNameRecordModel.DepartureAirport);
parameters.Add("ArrivalAirport", passengerNameRecordModel.ArrivalAirport);
parameters.Add("IsGroupBooking", passengerNameRecordModel.IsGroupBooking);
parameters.Add("Info", passengerNameRecordModel.Info);
parameters.Add("Error", passengerNameRecordModel.Error);
parameters.Add("TimeStamp", passengerNameRecordModel.TimeStamp);
parameters.Add("IsHandled", passengerNameRecordModel.IsHandled);
parameters.Add("AmadeusSyncTaskId", passengerNameRecordModel.AmadeusSyncTaskId);
parameters.Add("CategoryId", passengerNameRecordModel.CategoryId);
parameters.Add("TypeOfPnrElement", passengerNameRecordModel.TypeOfPnrElement);
parameters.Add("AgentId", passengerNameRecordModel.AgentId);
parameters.Add("OfficeId", passengerNameRecordModel.OfficeId);
parameters.Add("IataCode", passengerNameRecordModel.IataCode);
parameters.Add("QueueingOfficeId", passengerNameRecordModel.QueueingOfficeId);
parameters.Add("Location", passengerNameRecordModel.Location);
parameters.Add("CreationOfficeId", passengerNameRecordModel.CreationOfficeId);
parameters.Add("AgentSignature", passengerNameRecordModel.AgentSignature);
parameters.Add("AgentSignature", passengerNameRecordModel.AgentSignature);
parameters.Add("CreatorIataCode", passengerNameRecordModel.CreatorIataCode);
parameters.Add("CreationDate", passengerNameRecordModel.CreationDate);
using (var connection = _connectionFactory.GetConnection())
{
connection.Execute(query, parameters);
}
}
public void Insert(PassengerNameRecordModel passengerNameRecordModel)
{
if (passengerNameRecordModel == null) throw new ArgumentNullException("PassengerNameRecordModel");
const string query = @"INSERT INTO [PassengerNameRecord] ([Id], [QueueId], [Number], [Quantity] ,[SurName] ,[Type] ,[Date1] ,[Date2] ,[Date3], [DepartureDate], [DepartureAirport], [ArrivalAirport], [IsGroupBooking], [Info], [Error], [TimeStamp], [IsHandled], [AmadeusSyncTaskId], [CategoryId], [TypeOfPnrElement], [AgentId], [OfficeId], [IataCode], [QueueingOfficeId], [Location], [CreationOfficeId], [AgentSignature], [CreationDate], [CreatorIataCode]) VALUES (@Id, @QueueId, @Number, @Quantity , @SurName , @Type , @Date1 , @Date2 , @Date3, @DepartureDate, @DepartureAirport, @ArrivalAirport, @IsGroupBooking, @Info, @Error, @TimeStamp, @IsHandled, @AmadeusSyncTaskId, @CategoryId, @TypeOfPnrElement, @AgentId, @OfficeId, @IataCode, @QueueingOfficeId, @Location, @CreationOfficeId, @AgentSignature, @CreationDate, @CreatorIataCode)";
ExecuteQuery(passengerNameRecordModel, query);
}
