public DeleteGPSendingResponseDto DeleteGPSendingMasterAndDetails(DeleteGPSendingRequestDto deleteGPSendingRequestDto)
{
DeleteGPSendingResponseDto response = new DeleteGPSendingResponseDto();
var deleteGPSendingDetailsItems = new List <DeleteGPSendingDetailsCM>();
var deleteGPSendingCM = new DeleteGPSendingCM();
foreach (var dcItems in deleteGPSendingRequestDto.DeleteGPSendingDetails)
{
var deleteDcDetails = new DeleteGPSendingDetailsCM
{
GPNumber = dcItems.GPNumber,
GPSerialNo = dcItems.GPSerialNo,
UpdatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove
UpdatedDateTime = System.DateTime.UtcNow
};
deleteGPSendingDetailsItems.Add(deleteDcDetails);
}
deleteGPSendingCM.GPNumber = deleteGPSendingRequestDto.GPNumber;
deleteGPSendingCM.IsDeleteFrom = deleteGPSendingRequestDto.IsDeleteFrom;
deleteGPSendingCM.DeleteGPSendingDetailsCM = deleteGPSendingDetailsItems;
gatePassRepository.DeleteGPSendingMasterAndDetails(deleteGPSendingCM);
return(response);
}
public void DeleteGPSendingMasterAndDetails(DeleteGPSendingCM DeleteGPSendingCM)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new GPSendingDeleteCommand {
Connection = connection
};
command.Execute(DeleteGPSendingCM.DeleteGPSendingDetailsCM.ToDataTableWithNull(), DeleteGPSendingCM.GPNumber, DeleteGPSendingCM.IsDeleteFrom);
}
}