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