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