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