public List<SupplementalDiagnosisCategoryModel> GetAllSupplementalCategories() { var categories = new List<SupplementalDiagnosisCategoryModel>(); var repo = new HealthInformationProgram.Data.Repositories.SupplementalDiagnosisCategoryRepository(); var dataList = repo.GetAll(); foreach (var item in dataList) { var cat = new SupplementalDiagnosisCategoryModel(); cat.SupplementalDiagnosisCategoryId = GetDataValue(item.splmtl_diag_cat_id); cat.SupplementalDiagnosisCategoryType = GetDataValue(item.splmtl_diag_cat); cat.SortOrder = GetDataValue(item.user_intrfc_sort_ord); cat.Status = GetDataValue(item.splmtl_diag_cat_stat); cat.SupplementalDiagnosisCategoryEffectiveStartDate = GetDataValue(item.splmtl_diag_cat_strt_eff_dt); cat.SupplementalDiagnosisCategoryEffectiveEndDate = GetDataValue(item.splmtl_diag_cat_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; }