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