public IEnumerable <Domain.Dashboard.GraphData> GetUserstatsList() { //UserCount afgelopen 10 dagen InitNonExistingRepo(); List <Gebruiker> users = repo.ReadGebruikers().ToList(); DateTime lastJoin = users.OrderBy(m => m.Joindate).ToList().Last().Joindate; DateTime stop = users.OrderBy(m => m.Joindate).ToList().Last().Joindate; stop.AddDays(-10); List <Domain.Dashboard.GraphData> GraphDataList = new List <Domain.Dashboard.GraphData>(); for (int i = 0; i < 10; i++) { string date = lastJoin.Date.Year + "-" + lastJoin.Date.Month + "-" + lastJoin.Date.Day; int count = 0; IEnumerable <Gebruiker> usrs = users.Where(s => s.Joindate.Day == lastJoin.Date.Day).ToList(); foreach (Gebruiker u in usrs) { count++; } Domain.Dashboard.GraphData graph = new Domain.Dashboard.GraphData(date, count); GraphDataList.Add(graph); lastJoin = lastJoin.AddDays(-1); } return(GraphDataList); }
public IEnumerable <Domain.Dashboard.GraphData> GetTotalUsersList() { InitNonExistingRepo(); //enkel actieve gebruikers meegeven int count = repo.ReadGebruikers().Where(g => g.Active == true).Count(); List <Domain.Dashboard.GraphData> cijferlist = new List <Domain.Dashboard.GraphData>(); Domain.Dashboard.GraphData graph = new Domain.Dashboard.GraphData() { Label = "Aantal actieve gebruikers", Value = count }; cijferlist.Add(graph); return(cijferlist); }