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