public async Task <IActionResult> OnGetAsync() { UserContext = CoreService.GetUserContext(); if (UserContext == null) { return(NotFound()); } VetMember = UserContext.CurrentUser; Transactions = CoreService .GetCoinTransactionQuery(UserContext.CurrentUser) .Include(c => c.RecivedVetMember) .Include(c => c.SendVetMember) .OrderByDescending(c => c.CreateDate) .Take(5); Trades = CoreService.DbContext .Trades .Include(c => c.VetMember) .Include(c => c.TradeMessages) .ThenInclude(c => c.VetMember) .OrderByDescending(c => c.CreateDate) .Where(c => c.VetMemberId == UserContext.CurrentUser.Id) .Take(5) .ToArray(); CommentedTrades = CoreService.DbContext .Trades .Include(c => c.VetMember) .Include(c => c.TradeMessages) .ThenInclude(c => c.VetMember) .OrderByDescending(c => c.TradeMessages.Max(d => d.CreateDate)) .Where(c => c.TradeMessages.Any(d => d.VetMemberId == UserContext.CurrentUser.Id) && c.VetMemberId != UserContext.CurrentUser.Id ) .Take(5) .ToArray(); Contracts = await CoreService.DbContext .Contracts .Include(c => c.VetMember) .Include(c => c.Trade.VetMember) .Where(c => c.VetMemberId == UserContext.CurrentUser.Id) .OrderByDescending(c => c.ContractMessages.Max(d => d.CreateDate)) .Take(5) .ToArrayAsync(); Venders = await CoreService.DbContext .Venders .Include(c => c.VetMember) .Where(c => c.VetMemberId == UserContext.CurrentUser.Id) .OrderByDescending(c => c.CreateDate) .Take(5) .ToArrayAsync(); WaitingContracts = await CoreService.EnumWaitingContracts(VetMember); return(Page()); }