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