public void Execute(DataTable dataTableForGPSendingDetails, GPReceivingDetailsCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspAddGPReceivingDetails]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@GPReceivingDetails", SsDbType.Structured, ParameterDirection.Input, dataTableForGPSendingDetails)); sqlCommand.ExecuteNonQuery(); } }
public void SaveGPReceivingDetails(GPReceivingDetailsCM GPReceivingDetailsCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GPReceivingDetailsInsertCommand { Connection = connection }; command.Execute(GPReceivingDetailsCM.GPReceivingDetailsListItemsCM.ToDataTableWithNull(), GPReceivingDetailsCM); } }
public GPReceivingResponseDto SaveGPReceivingtDetails(GPReceivingRequestDto GPReceivingRequestDto) { var createdBy = Helper.userIdToekn(); GPReceivingResponseDto GPReceivingResponseDto = new GPReceivingResponseDto(); #region Section To Save GP Receiving Master gatePassRepository.SaveGPReceivingMaster(GPReceivingRequestDto.GPReceiptNumber, GPReceivingRequestDto.GPReceiptDate, GPReceivingRequestDto.VendorCode, GPReceivingRequestDto.DocumentID, GPReceivingRequestDto.DocumentDate, GPReceivingRequestDto.Remarks); #endregion #region Section To Save GP Receiving Details foreach (var gpReceivingDetails in GPReceivingRequestDto.GPReceivingDetails) { var GPReceivingDetailsListCM = new List <GPReceivingDetailsListCM>(); var cModel = new GPReceivingDetailsCM(); var GPReceivingDetail = new GPReceivingDetailsListCM { GPReceiptNumber = gpReceivingDetails.GPReceiptNumber, GPNumber = gpReceivingDetails.GPNumber, GPSerialNo = gpReceivingDetails.GPSerialNo, ReceivedQuantity = gpReceivingDetails.ReceiptQuantity, CreatedBy = createdBy, CreatedDateTime = DateTime.Now }; GPReceivingDetailsListCM.Add(GPReceivingDetail); cModel.GPReceivingDetailsListItemsCM = GPReceivingDetailsListCM; // Section to add the gp sending master details information gatePassRepository.SaveGPReceivingDetails(cModel); } #endregion return(GPReceivingResponseDto); }