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