public List<RawVisitModel> GetInvalidRawVisit()
        {
            var rawVisits = new List<RawVisitModel>();
            var repo = new HealthInformationProgram.Data.Repositories.RawVisitRepository();
            var exRepo = new HealthInformationProgram.Data.Repositories.LookupExceptionRepository();
            var excpList = exRepo.GetAll();

            foreach ( var raw in repo.GetAll().Where(v=>v.err_cd<0).OrderByDescending(v=>v.rec_creat_dt) )
            {

                var viewModel = new RawVisitModel();
                var exception =excpList.Where(e => e.err_cd == raw.err_cd).FirstOrDefault();

                viewModel.ErrorDescription = (exception != null) ? exception.exception_descn : "No error description in DB";
                viewModel.ErrorCode = GetDataValue(raw.err_cd);
                viewModel.VisitId = GetDataValue(raw.visit_uuid);
                viewModel.VisitJson = GetDataValue(raw.visit_json);
                viewModel.VisitStatus = GetDataValue(raw.visit_stat);
                viewModel.UpdatedBy = GetDataValue(raw.rec_updt_user_id_cd);
                viewModel.UpdateDate = GetDataValue(raw.rec_updt_dt);
                viewModel.CreatedBy = GetDataValue(raw.rec_creat_user_id_cd);
                viewModel.CreateDate = GetDataValue(raw.rec_creat_dt);

                rawVisits.Add(viewModel);
            }

            return rawVisits;
        }
        public List<ExceptionModel> GetExceptionList()
        {
            var errorCodes = new List<ExceptionModel>();
            var repo = new HealthInformationProgram.Data.Repositories.LookupExceptionRepository();
            foreach ( var errorCode in repo.GetAll() )
            {

                var viewModel = new HealthInformationProgram.Models.ExceptionModel();

                viewModel.ErrorCode = errorCode.err_cd.ToString();
                viewModel.ExceptionDescription = errorCode.exception_descn;

                errorCodes.Add(viewModel);
            }

            return errorCodes;
        }