public void Process(CSET_Context db, int aggregationID, LineChart response, string Type)
{
var results = db.usp_GetTop5Areas(aggregationID);
HashSet <int> labels = new HashSet <int>();
Dictionary <string, ChartDataSet> datasets = new Dictionary <string, ChartDataSet>();
foreach (usp_GetTop5Areas_result r in results.Where(x => x.TopBottomType == Type))
{
ChartDataSet ds1;
if (!datasets.TryGetValue(r.Question_Group_Heading, out ds1))
{
var ds = new ChartDataSet();
ds.label = r.Question_Group_Heading;
response.datasets.Add(ds);
datasets.Add(r.Question_Group_Heading, ds);
ds.data.Add((float)r.percentage);
}
else
{
ds1.data.Add((float)r.percentage);
}
if (!labels.Contains(r.Assessment_Id))
{
response.labels.Add(r.Assessment_Date.ToString("d-MMM-yyyy"));
labels.Add(r.Assessment_Id);
}
}
}