public List <ProviderDataVis> GetProviderData() { string procName = "[dbo].[ProvidersReport_Select_DetailCounts]"; List <ProviderDataVis> list = null; _data.ExecuteCmd(procName, null, (reader, set) => { ProviderDataVis provider = HydrateProviderDataVis(reader); if (list == null) { list = new List <ProviderDataVis>(); } list.Add(provider); }); return(list); }
private ProviderDataVis HydrateProviderDataVis(IDataReader reader) { int index = 0; ProviderDataVis provider = new ProviderDataVis(); provider.Id = reader.GetSafeInt32(index++); provider.Gender = reader.GetSafeString(index++); provider.DateAttested = reader.GetSafeDateTime(index++); provider.Compliant = reader.GetSafeInt32(index++); provider.Professional = reader.GetSafeJSON <ProfessionalDetailsReport>(index++); provider.Affiliations = reader.GetSafeJSON <List <AffiliationReport> >(index++); provider.Certifications = reader.GetSafeJSON <List <TypeTableBase> >(index++); provider.Expertise = reader.GetSafeJSON <List <TypeTableBase> >(index++); provider.Languages = reader.GetSafeJSON <List <TypeTableBase> >(index++); provider.Licenses = reader.GetSafeJSON <List <ProviderLicenseReport> >(index++); provider.Specializations = reader.GetSafeJSON <List <SpecializationReport> >(index++); provider.InsurancePlans = reader.GetSafeJSON <List <TypeTableBase> >(index++); return(provider); }