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