private void BindDemographicData(Base.Classes.Class course)
{
var demographicDataSource = course.GetDemographicData();
string rawData = "[";
string labels = "[";
//Load gender data to hidden inputs
foreach(DataRow row in demographicDataSource.Tables["Gender"].Rows)
{
rawData += "['" + row["Gender"].ToString() + "', " + row["Percentage"].ToString() + ", " +
row["Count"].ToString() + "],";
labels += "'" + row["Gender"].ToString() + "',";
}
genderRawData.Value = (rawData == "[" ? rawData : rawData.Substring(0, rawData.LastIndexOf(","))) + "]";
genderLabels.Value = (labels == "[" ? labels : labels.Substring(0, labels.LastIndexOf(","))) + "]";
//***********************************************************************
//Reset rawData and labels
rawData = "[";
labels = "[";
//Load race data to hidden inputs
foreach (DataRow row in demographicDataSource.Tables["Races"].Rows)
{
if (DataIntegrity.ConvertToInt(row["Count"]) == 0) continue;
rawData += "['" + row["Race"].ToString() + "', " + row["Percentage"].ToString() + ", " +
row["Count"].ToString() + "],";
labels += "'" + row["Race"].ToString() + "',";
}
raceRawData.Value = (rawData == "[" ? rawData : rawData.Substring(0, rawData.LastIndexOf(","))) + "]";
raceLabels.Value = (labels == "[" ? labels : labels.Substring(0, labels.LastIndexOf(","))) + "]";
//***********************************************************************
//Reset rawData and labels
rawData = "[";
labels = "[";
//Load demographic subgroup data to hidden inputs
foreach (DataRow row in demographicDataSource.Tables["Other"].Rows)
{
if (DataIntegrity.ConvertToInt(row["Count"]) == 0) continue;
rawData += "['" + row["Demographic"].ToString() + "', " + row["Percentage"].ToString() + ", " +
row["Count"].ToString() + ", " + row["DemoField"].ToString() + "],";
labels += "'" + row["Demographic"].ToString() + "',";
}
subgroupRawData.Value = (rawData == "[" ? rawData : rawData.Substring(0, rawData.LastIndexOf(","))) + "]";
subgroupLabels.Value = (labels == "[" ? labels : labels.Substring(0, labels.LastIndexOf(","))) + "]";
//***********************************************************************
}