public bool Save_HISFileUploadSummary(TRHISFileUploadSummary model) { var currentDateTime = DateTime.Now; bool objComplete = false; using (var _db = new HISDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { _db.TRHISFileUploadSummarys.Add(model); _db.SaveChanges(); trans.Commit(); objComplete = true; } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } } return(objComplete); }
public STGHISFileUploadDetailDTO Save_HISFileDataDetail(List <TRSTGHISFileUploadDetail> model) { var currentDateTime = DateTime.Now; STGHISFileUploadDetailDTO objReturn = new STGHISFileUploadDetailDTO(); using (var _db = new HISDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { //_db.TRSTGHISFileUploadDetails.AddRange(model); _db.BulkInsert(model); _db.SaveChanges(); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } } return(objReturn); }
public List <TRSTGHISFileUploadHeader> Save_HISFileDataHeaderList(List <TRSTGHISFileUploadHeader> model) { var currentDateTime = DateTime.Now; List <TRSTGHISFileUploadHeader> objReturn = new List <TRSTGHISFileUploadHeader>(); using (var _db = new HISDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { var hfu_id = model.FirstOrDefault().huh_hfu_id; //_db.TRSTGHISFileUploadDetails.AddRange(model); _db.BulkInsert(model); _db.SaveChanges(); trans.Commit(); objReturn = _db.TRSTGHISFileUploadHeaders.FromSqlRaw <TRSTGHISFileUploadHeader>("sp_GET_TRSTGHISFileUploadHeader {0} " , hfu_id ).ToList();; } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } } return(objReturn); }
public int Save_HISFileDataHeader(TRSTGHISFileUploadHeader model) { var currentDateTime = DateTime.Now; int objReturn = 0; using (var _db = new HISDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { _db.TRSTGHISFileUploadHeaders.Add(model); _db.SaveChanges(); trans.Commit(); objReturn = model.huh_id; } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } } return(objReturn); }
public Tuple <int, Boolean> Get_CheckExistingDetail(TRSTGHISFileUploadHeader modelHeader, TRSTGHISFileUploadDetail modelDetail) { int iNextSeqNo = 1; bool blnDup = false; var currentDateTime = DateTime.Now; using (var _db = new HISDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { var objResult = _db.TRSTGHISFileUploadDetails.FromSqlRaw <TRSTGHISFileUploadDetail>("sp_UPLOAD_HIS_CheckExisting_Detail {0},{1},{2},{3},{4},{5},{6},{7}", modelHeader.huh_hos_code , modelHeader.huh_ref_no , modelHeader.huh_lab_no , modelHeader.huh_hn_no , modelHeader.huh_date , modelHeader.huh_hfu_id , modelDetail.hud_field_name , modelDetail.hud_field_value ).AsEnumerable(); if (objResult != null) { foreach (var obj in objResult) { iNextSeqNo = obj.hud_seq_no + 1; blnDup = true; obj.hud_status = 'D'; obj.hud_updateuser = "******"; obj.hud_updatedate = currentDateTime; } _db.SaveChanges(); } trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } } return(Tuple.Create(iNextSeqNo, blnDup)); }
public string Get_CheckExistingHeaders(TRSTGHISFileUploadHeader model, string mp_filetype, ref int refNextSeq, ref bool refIsDup) { string returnvalue = ""; //int iNextSeqNo = 1; //bool blnDup = false; var currentDateTime = DateTime.Now; using (var _db = new HISDataContext()) { using (var trans = _db.Database.BeginTransaction()) { try { var objResult = _db.TRSTGHISFileUploadHeaders.FromSqlRaw <TRSTGHISFileUploadHeader>("sp_UPLOAD_HIS_CheckExisting_SP_Header {0},{1},{2},{3},{4},{5},{6}", model.huh_hos_code, model.huh_ref_no, model.huh_lab_no, model.huh_hn_no, model.huh_date, model.huh_hfu_id, mp_filetype ).AsEnumerable().FirstOrDefault(); if (objResult != null) { refNextSeq = objResult.huh_seq_no + 1; refIsDup = true; objResult.huh_status = 'D'; objResult.huh_delete_flag = true; objResult.huh_updateuser = "******"; objResult.huh_updatedate = currentDateTime; _db.SaveChanges(); } trans.Commit(); returnvalue = "OK"; } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } } return(returnvalue); }