public ActionResult MostVisited() { MostVisitedCreateViewModel mostVisited = new MostVisitedCreateViewModel(); DateTime dateWeek = DateTime.Now.AddDays(-7); DateTime dateMonth = DateTime.Now.AddMonths(-1); DateTime dateYear = DateTime.Now.AddYears(-1); ReservationsRepository repository = new ReservationsRepository(); RestaurantsRepository rep = new RestaurantsRepository(); List <Restaurant> restaurants = rep.GetAll(); mostVisited.Restaurants = restaurants; UsersRepository repo = new UsersRepository(); List <User> users = repo.GetAll(); mostVisited.Users = users; //mostVisited.mostVisitedWeekly = repository.GetAll(n => n.ReservationTime > dateWeek && n.ReservationTime < DateTime.Now); mostVisited.mostVisitedWeekly = repository.GetAll(dateWeek); mostVisited.mostVisitedMonthly = repository.GetAll(dateMonth); mostVisited.mostVisitedYearly = repository.GetAll(dateYear); //mostVisited.mostVisitedMonthly = repository.GetAll(n => n.ReservationTime > dateMonth && n.ReservationTime < DateTime.Now); //mostVisited.mostVisitedYearly = repository.GetAll(n => n.ReservationTime > dateYear && n.ReservationTime < DateTime.Now); return(View(mostVisited)); }