public async Task OnGetAsync() { TblGames = await _context.TblGames.ToListAsync(); TblPlayers = await _Pcontext.TblPlayers.ToListAsync(); playerToGames = new List <PlayerToGame>(); currentPlayerGames = new List <TblGames>(); playersList = TblPlayers.Select(p => p.Email).ToList(); map = new Dictionary <TblPlayers, List <TblGames> >(); foreach (TblPlayers player in TblPlayers) { int playerId = player.Id; int gameCount = 0; foreach (TblGames game in TblGames) { if (game.Pid.Equals(playerId)) { gameCount++; addToMap(player, game); } } playerToGames.Add(new PlayerToGame { Pid = playerId, Email = player.Email, GameCount = gameCount }); } }
public async Task <ActionResult <TblPlayers> > PostTblPlayers(TblPlayers tblPlayers) { _context.TblPlayers.Add(tblPlayers); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblPlayers", new { id = tblPlayers.Id }, tblPlayers)); }
public async Task <IActionResult> PutTblPlayers(int id, TblPlayers tblPlayers) { if (id != tblPlayers.Id) { return(BadRequest()); } _context.Entry(tblPlayers).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblPlayersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void addToMap(TblPlayers player, TblGames game) { List <TblGames> listValue; if (map.TryGetValue(player, out listValue)) { listValue.Add(game); } else { map.Add(player, new List <TblGames> { game }); } }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } TblPlayers = await _context.TblPlayers.FirstOrDefaultAsync(m => m.Id == id); if (TblPlayers == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } TblPlayers = await _context.TblPlayers.FindAsync(id); if (TblPlayers != null) { _context.TblPlayers.Remove(TblPlayers); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task OnPostAsync(String playerEmail) { if (playerEmail != null) { var p = from tbPlayer in _pcontext.TblPlayers where tbPlayer.Email == playerEmail select tbPlayer; player = p.First(); var x = from g in _context.TblGames where g.Pid == player.Id orderby g.Id ascending select g; tblGames = await x.ToListAsync(); } else { tblGames = new List <TblGames>(); } }