public TRLabFileErrorDetail Save_TRLabFileErrorDetailList(List <TRLabFileErrorDetail> model)
{
var currentDateTime = DateTime.Now;
TRLabFileErrorDetail objReturn = new TRLabFileErrorDetail();
using (var _db = new LabDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
_db.TRLabFileErrorDetails.AddRange(model);
_db.SaveChanges();
trans.Commit();
//objReturn = _mapper.Map<STGLabFileDataDetailDTO>(objModel);
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objReturn);
}
public Guid Save_TRLabFileErrorDetail(TRLabFileErrorDetail model)
{
var currentDateTime = DateTime.Now;
Guid objReturn = Guid.Empty;
using (var _db = new LabDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
_db.TRLabFileErrorDetails.Add(model);
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objReturn);
}
public int Get_CheckExistingHeader(TRSTGLabFileDataHeader model, string mp_program, string mp_filetype)
{
int objReturn = 1;
var currentDateTime = DateTime.Now;
using (var _db = new LabDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
//var objResult2 = _db.TRSTGLabFileDataHeaders.FirstOrDefault(x => x.ldh_hos_code == model.ldh_hos_code
// && x.ldh_lab == model.ldh_lab
// && x.ldh_labno == model.ldh_labno
// && x.ldh_organism == model.ldh_organism
// //&& x.ldh_specimen == model.ldh_specimen
// && x.ldh_date == model.ldh_date
// && x.ldh_lfu_id != model.ldh_lfu_id
// && x.ldh_flagdelete == false);
var objResult = _db.TRSTGLabFileDataHeaders.FromSqlRaw <TRSTGLabFileDataHeader>("sp_UPLOAD_CheckExistingHeader {0},{1},{2},{3},{4},{5},{6},{7}",
model.ldh_hos_code,
model.ldh_lab,
model.ldh_labno,
model.ldh_organism,
model.ldh_date,
model.ldh_lfu_id,
mp_program,
mp_filetype
).AsEnumerable().FirstOrDefault();
if (objResult != null)
{
objReturn = objResult.ldh_sequence + 1;
objResult.ldh_status = 'D';
objResult.ldh_flagdelete = true;
objResult.ldh_updateuser = "******";
objResult.ldh_updatedate = currentDateTime;
_db.SaveChanges();
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objReturn);
}
public Guid Save_TRLabFileErrorHeader(TRLabFileErrorHeader model)
{
var currentDateTime = DateTime.Now;
Guid objReturn = Guid.Empty;
using (var _db = new LabDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
if (model.feh_status == 'N')
{
_db.TRLabFileErrorHeaders.Add(model);
}
else if (model.feh_status == 'E')
{
var objModel = new TRLabFileErrorHeader();
objModel = _db.TRLabFileErrorHeaders.FirstOrDefault(x => x.feh_id == model.feh_id);
objModel.feh_errorrecord = model.feh_errorrecord;
}
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objReturn);
}
