public int Update_HISFileUploadStatus(int hfu_id, char hfu_status, int hfu_matching_records, int hfu_duplicate_records, string hfu_updateuser)
{
int rowsAffected = 0;
using (var _db = new HISDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
rowsAffected = _db.Database.ExecuteSqlCommand("exec sp_UPDATE_TRHISFileUpload_Status {0},{1},{2},{3},{4}"
, hfu_id
, hfu_status
, hfu_matching_records
, hfu_duplicate_records
, hfu_updateuser);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(rowsAffected);
}
public int GetLabDataWithHISMatching(string hos_code, int hfu_id)
{
List <LabDataWithHISMatchingDTO> objList = new List <LabDataWithHISMatchingDTO>();
int iMatchingRecord = 0;
using (var _db = new HISDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.LabDataWithHISMatchingDTOs.FromSqlRaw <LabDataWithHISMatchingDTO>("sp_GET_LabWithHISMatching {0} ,{1} "
, hos_code
, hfu_id).ToList();
trans.Commit();
iMatchingRecord = objDataList.Count();
}
catch
{
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(iMatchingRecord);
}
public List <HISFileTemplateDTO> GetHISFileTemplate_Active()
{
List <HISFileTemplateDTO> objList = new List <HISFileTemplateDTO>();
using (var _db = new HISDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
objList = _db.HISFileTemplateDTOs.FromSqlRaw <HISFileTemplateDTO>("sp_GET_TCHISFileTemplate_Active").ToList();
trans.Commit();
}
catch
{
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objList);
}
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 List <TCParameter> GetParameter()
{
List <TCParameter> objReturn = new List <TCParameter>();
using (var _db = new HISDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
objReturn = _db.TCParameters.FromSqlRaw <TCParameter>("sp_GET_TCParameter {0}", "SP_UPLOAD_KEY").ToList();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objReturn);
}
public List <HISUploadDataDTO> Get_NewHISFileUpload(char status)
{
List <HISUploadDataDTO> objList = new List <HISUploadDataDTO>();
using (var _db = new HISDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
objList = _db.HISUploadDataDTOs.FromSqlRaw <HISUploadDataDTO>("sp_GET_TRHISFileUploadList {0} ,{1} ,{2} ,{3}, {4}"
, null, null, null, status, 1).ToList();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objList);
}
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);
}
public int Get_HeaderIdForMultipleline(TRSTGHISFileUploadHeader model)
{
int objReturn = 0;
using (var _db = new HISDataContext())
{
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objResult = _db.TRSTGHISFileUploadHeaders.FirstOrDefault(x => x.huh_hfu_id == model.huh_hfu_id &&
x.huh_hos_code == model.huh_hos_code &&
x.huh_ref_no == model.huh_ref_no &&
x.huh_lab_no == model.huh_lab_no &&
x.huh_hn_no == model.huh_hn_no &&
x.huh_date == model.huh_date &&
x.huh_delete_flag == false);
if (objResult != null)
{
objReturn = objResult.huh_id;
}
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
}
return(objReturn);
}
