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