public LabFileUploadDataDTO SaveLabFileUploadData(LabFileUploadDataDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
LabFileUploadDataDTO objReturn = new LabFileUploadDataDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TRLabFileUpload();
if (model.lfu_status == 'N')
{
objModel = _mapper.Map <TRLabFileUpload>(model);
objModel.lfu_createdate = currentDateTime;
objModel.lfu_updatedate = currentDateTime;
_db.TRLabFileUploads.Add(objModel);
}
else
{
objModel = _db.TRLabFileUploads.FirstOrDefault(x => x.lfu_id == model.lfu_id);
objModel.lfu_status = model.lfu_status;
objModel.lfu_version = model.lfu_version;
objModel.lfu_flagdelete = model.lfu_flagdelete;
objModel.lfu_lab = model.lfu_lab;
objModel.lfu_FileName = model.lfu_FileName;
objModel.lfu_Program = model.lfu_Program;
objModel.lfu_Path = model.lfu_Path;
objModel.lfu_FileType = model.lfu_FileType;
objModel.lfu_TotalRecord = model.lfu_TotalRecord;
objModel.lfu_AerobicCulture = model.lfu_AerobicCulture;
objModel.lfu_ErrorRecord = model.lfu_ErrorRecord;
objModel.lfu_StartDatePeriod = model.lfu_StartDatePeriod;
objModel.lfu_EndDatePeriod = model.lfu_EndDatePeriod;
objModel.lfu_approveduser = model.lfu_approveduser;
objModel.lfu_approveddate = model.lfu_approveddate;
objModel.lfu_updateuser = model.lfu_updateuser;
objModel.lfu_updatedate = currentDateTime;
}
_db.SaveChanges();
trans.Commit();
objReturn = _mapper.Map <LabFileUploadDataDTO>(objModel);
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
return(objReturn);
}
