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