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