HealthInformationProgram.Data.Repositories.SupplementalDiagnosisRepository.GetAllSupplementalDiagnosisForGivenDiagnosisId C# (CSharp) Method

        public List<lkup_splmtl_diag> GetAllSupplementalDiagnosisForGivenDiagnosisId(decimal diagnosisId)
        {
            try
            {
                using (var ctx = new ClinicDataContext(connString))
                {

                    return ctx.lkup_splmtl_diag.Where(x => x.diag_id == diagnosisId).ToList(); ;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public List<SupplementalDiagnosisModel> GetAllSupplementalDiagnosisForGivenDiagnosisId(decimal diagnosisId)
        {
            var categories = new List<SupplementalDiagnosisModel>();
            var repo = new HealthInformationProgram.Data.Repositories.SupplementalDiagnosisRepository();

            var dataList = repo.GetAllSupplementalDiagnosisForGivenDiagnosisId(diagnosisId);
            foreach (var item in dataList)
            {
                var cat = new SupplementalDiagnosisModel();

                cat.SupplementalDiagnosisId = GetDataValue(item.splmtl_diag_id);
                cat.SupplementalDiagnosisDescription = GetDataValue(item.splmtl_diag_descn);
                cat.DiagnosisId = GetDataValue(item.diag_id);
                cat.Diagnosis = GetDiagnosis(item.diag_id).DiagnosisDescription;
                cat.SortOrder = GetDataValue(item.user_intrfc_sort_ord);
                cat.Status = GetDataValue(item.splmtl_diag_stat);
                cat.SupplementalDiagnosisEffectiveStartDate = GetDataValue(item.splmtl_diag_strt_eff_dt);
                cat.SupplementalDiagnosisEffectiveEndDate = GetDataValue(item.splmtl_diag_end_eff_dt);
                cat.UpdatedBy = GetDataValue(item.rec_updt_user_id_cd);
                cat.UpdateDate = GetDataValue(item.rec_updt_dt);
                cat.CreatedBy = GetDataValue(item.rec_creat_user_id_cd);
                cat.CreateDate = GetDataValue(item.rec_creat_dt);

                categories.Add(cat);
            }
            return categories;
        }