public Guid Save_LabFileDataHeader(TRSTGLabFileDataHeader model) { var currentDateTime = DateTime.Now; Guid objReturn = Guid.Empty; using (var _db = new LabDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { _db.TRSTGLabFileDataHeaders.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 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); }