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