public IActionResult Index() { InfoVM model = new InfoVM(); model.MuseumsRegistrated = museumRepository.MuseumsRegistrated(); model.MuseumsRegMonth = museumRepository.MuseumsRegMonth(); model.TicketsRevenue = 0; model.TicketsRevenueMonth = 0; model.TicketsSale = 0; model.TicketsSaleMonth = 0; model.UsersRegistrated = clientRepository.GetRegClients(); model.UsersRegMonth = clientRepository.GetRegClientsMonth(); model.ActiveMuseums = 0; model.InactiveMuseums = 0; model.museumTicketSales = new List <MuseumTicketSale>(); IEnumerable <Museums> museums = museumRepository.GetMuseums(); museums = museums.Where(x => x.OnlineTickets).ToList(); foreach (Museums x in museums) { int total = ticketRepository.GetSum(x.UserId); model.museumTicketSales.Add(new MuseumTicketSale { Museum = x.Name, Quantity = total }); if (x.User.Active) { model.ActiveMuseums++; } else { model.InactiveMuseums++; } model.TicketsSale += total; model.TicketsSaleMonth += ticketRepository.GetMonthSum(x.UserId); model.TicketsRevenue += ticketRepository.GetTotal(x.UserId); model.TicketsRevenueMonth += ticketRepository.GetMonthTotal(x.UserId); } model.TotalMuseumTicketSales = model.museumTicketSales.Select(x => x.Quantity).Sum(); return(View(model)); }