public string GetFilteredValues(string filter)
{
CommunityProgressReportDBHandle dataBaseHandler = new CommunityProgressReportDBHandle();
string query = this.GetQuery(filter);
List <ReportModel> filteredValues = dataBaseHandler.GetFilteredValues(query);
return(JsonConvert.SerializeObject(filteredValues));
}
public string GetFilteredTable(string filter)
{
CommunityProgressReportDBHandle dataBaseHandler = new CommunityProgressReportDBHandle();
string query = this.GetQuery(filter);
List <List <string> > listOfString;
if (filter == "Number of articles peer category and topic")
{
listOfString = dataBaseHandler.getRankTopicCategory(query);
}
else
{
listOfString = dataBaseHandler.getViewsTopicCategory(query);
}
return(JsonConvert.SerializeObject(listOfString));
}
