public void Execute(DataTable dataTableForGPSendingDetails, GPSendingDetailsCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspAddGPSendingDetails]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@GPSendingDetails", SsDbType.Structured, ParameterDirection.Input, dataTableForGPSendingDetails)); sqlCommand.ExecuteNonQuery(); } }
public void SaveGPSendingDetails(GPSendingDetailsCM GPSendingDetailsCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GPSendingDetailsInsertCommand { Connection = connection }; command.Execute(GPSendingDetailsCM.GPSendingDetailsListItemsCM.ToDataTableWithNull(), GPSendingDetailsCM); } }
public GPSendingResponseDto SaveGPSendingDetails(GPSendingRequestDto GPSendingRequestDto) { var createdBy = Helper.userIdToekn(); GPSendingResponseDto GPSendingResponseDto = new GPSendingResponseDto(); #region Section To Save GPMaster gatePassRepository.SaveGPSendingMaster(GPSendingRequestDto.GPType, GPSendingRequestDto.GPNumber, GPSendingRequestDto.VendorCode, GPSendingRequestDto.GPDate, GPSendingRequestDto.RequestedBy, GPSendingRequestDto.Remarks); #endregion #region Section To Save GP Details foreach (var gpSendingDetails in GPSendingRequestDto.GPSendingDetailsList) { var GPSendingDetailsListCM = new List <GPSendingDetailsListCM>(); var cModel = new GPSendingDetailsCM(); var GPSendingDetail = new GPSendingDetailsListCM { GPNumber = gpSendingDetails.GPNumber, GPSerialNo = gpSendingDetails.GPSerialNo, Description = gpSendingDetails.Description, Units = gpSendingDetails.Units, ReceivedQuantity = gpSendingDetails.ReceivedQuantity, SentQuantity = gpSendingDetails.SentQuantity, CreatedBy = createdBy, CreatedDateTime = DateTime.Now }; GPSendingDetailsListCM.Add(GPSendingDetail); cModel.GPSendingDetailsListItemsCM = GPSendingDetailsListCM; // Section to add the gp sending master details information gatePassRepository.SaveGPSendingDetails(cModel); } #endregion return(GPSendingResponseDto); }