// GET: Player/Edit/5
public async Task <IActionResult> Confirm(int?id)
{
var player = await _context.Player.SingleOrDefaultAsync(m => m.PlayId == id);
if (player == null)
{
return(NotFound());
}
var member = _memberData.get(player.MemberId);
var enteredBy = _memberData.get(player.EnteredById);
var model = new PlayerDisplayViewModel();
model.MemberPlaying = true;
model.Player = player;
model.EnteredBy = enteredBy;
model.Member = member;
return(View(model));
}
// GET: Players/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new BadRequestResult());
}
var playerDisplayViewModel = new PlayerDisplayViewModel {
Player = _db.Players.Find(id)
};
var playerTeams = _db.TeamPlayerAssociations.Where(team => team.Player.Id == id).Select(x => x.Team.Id)
.ToList();
var fixturesInFirstTeam = _db.Fixtures
.Include(t => t.FirstTeam)
.Include(t => t.SecondTeam)
.Where(t => playerTeams.Contains(t.FirstTeam.Id))
.Select(
t => new
{
t.Date,
t.FirstTeam,
t.SecondTeam,
Score = t.FirstTeamScore.ToString(CultureInfo.InvariantCulture) + ":" + t.SecondTeamScore.ToString(CultureInfo.InvariantCulture),
IsWon = t.FirstTeamScore > t.SecondTeamScore
})
.AsEnumerable()
.Union(_db.Fixtures
.Include(t => t.FirstTeam)
.Include(t => t.SecondTeam)
.Where(t => playerTeams.Contains(t.SecondTeam.Id))
.Select(
t => new
{
t.Date,
t.FirstTeam,
t.SecondTeam,
Score = t.FirstTeamScore.ToString(CultureInfo.InvariantCulture) + ":" + t.SecondTeamScore.ToString(CultureInfo.InvariantCulture),
IsWon = t.SecondTeamScore > t.FirstTeamScore
})
)
.OrderByDescending(x => x.Date)
.Select(t => new FixturePlayerDisplayVIewModel()
{
Date = t.Date,
FirstTeam = t.FirstTeam,
SecondTeam = t.SecondTeam,
Score = t.Score,
IsWon = t.IsWon
})
.ToList();
playerDisplayViewModel.Fixtures = fixturesInFirstTeam;
if (playerDisplayViewModel.Player == null)
{
return(NotFound());
}
return(View(playerDisplayViewModel));
}
