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);
}
public Guid Get_HeaderIdForMultipleline(TRSTGLabFileDataHeader model)
{
Guid objReturn = Guid.Empty;
using (var _db = new LabDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objResult = _db.TRSTGLabFileDataHeaders.FirstOrDefault(x => x.ldh_lfu_id == model.ldh_lfu_id &&
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_flagdelete == false);
if (objResult != null)
{
objReturn = objResult.ldh_id;
}
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objReturn);
}
public STGLabFileDataDetailDTO Save_LabFileDataDetail(List <TRSTGLabFileDataDetail> model)
{
var currentDateTime = DateTime.Now;
STGLabFileDataDetailDTO objReturn = new STGLabFileDataDetailDTO();
using (var _db = new LabDataContext())
{
_db.BulkInsert(model);
//using (var trans = _db.Database.BeginTransaction())
//{
// try
// {
// //_db.TRSTGLabFileDataDetails.
// _db.TRSTGLabFileDataDetails.AddRange(model);
// _db.SaveChanges();
// trans.Commit();
// //objReturn = _mapper.Map<STGLabFileDataDetailDTO>(objModel);
// }
// catch (Exception ex)
// {
// // TODO: Handle failure
// trans.Rollback();
// }
// finally
// {
// trans.Dispose();
// }
//}
}
return(objReturn);
}
