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);
}