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

        public lkup_splmtl_diag GetSupplementalDiagnosis(decimal id)
        {
            try
            {
                using ( var ctx = new ClinicDataContext(connString) )
                {

                    return ctx.lkup_splmtl_diag.Where(v => v.splmtl_diag_id == id).FirstOrDefault();
                }
            }
            catch ( Exception ex )
            {
                throw ex;
            }
        }

        public SupplementalDiagnosisModel GetSupplementalDiagnosisByDescription(string description)
        {
            var repo = new HealthInformationProgram.Data.Repositories.SupplementalDiagnosisRepository();
            var dataItem = repo.GetSupplementalDiagnosis(description);

            var cat = new SupplementalDiagnosisModel();

            cat.SupplementalDiagnosisId = GetDataValue(dataItem.splmtl_diag_id);
            cat.SupplementalDiagnosisDescription = GetDataValue(dataItem.splmtl_diag_descn);
            cat.SortOrder = GetDataValue(dataItem.user_intrfc_sort_ord);
            cat.Status = GetDataValue(dataItem.splmtl_diag_stat);
            cat.SupplementalDiagnosisEffectiveStartDate = GetDataValue(dataItem.splmtl_diag_strt_eff_dt);
            cat.SupplementalDiagnosisEffectiveEndDate = GetDataValue(dataItem.splmtl_diag_end_eff_dt);
            cat.UpdatedBy = GetDataValue(dataItem.rec_updt_user_id_cd);
            cat.UpdateDate = GetDataValue(dataItem.rec_updt_dt);
            cat.CreatedBy = GetDataValue(dataItem.rec_creat_user_id_cd);
            cat.CreateDate = GetDataValue(dataItem.rec_creat_dt);

            return cat;
        }