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 HISFileUploadSummaryDTO SaveFileUploadSummary(List <HISFileUploadSummaryDTO> models) { log.MethodStart(); var currentDateTime = DateTime.Now; HISFileUploadSummaryDTO objReturn = new HISFileUploadSummaryDTO(); using (var trans = _db.Database.BeginTransaction()) { try { foreach (var objModel in models) { var obj = new TRHISFileUploadSummary(); obj.hus_hfu_id = objModel.hus_hfu_id; obj.hus_error_fieldname = objModel.hus_error_fieldname; obj.hus_error_fielddescr = objModel.hus_error_fielddescr; obj.hus_error_fieldrecord = objModel.hus_error_fieldrecord; obj.hus_createuser = objModel.hus_createuser; obj.hus_createdate = currentDateTime; _db.TRHISFileUploadSummarys.Add(obj); } _db.SaveChanges(); trans.Commit(); var objM = _db.TRHISFileUploadSummarys.FirstOrDefault(); objReturn = _mapper.Map <HISFileUploadSummaryDTO>(objM); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } return(objReturn); }