public List<PlayerHistoryVM> PlayerHistory(int peopleId)
{
using (var db = new CSBCDbContext())
{
var players = db.Players.Where(p => p.PeopleID == peopleId).OrderByDescending(p => p.Season.FromDate);
var viewPlayers = new List<PlayerHistoryVM>();
foreach (var player in players)
{
var viewPlayer = new PlayerHistoryVM();
viewPlayer.SeasonID = (player.SeasonID == null ? 0 : (int) player.SeasonID);
if (player.Season != null)
viewPlayer.Season = player.Season.Description;
if (player.Team != null)
viewPlayer.Team = player.Team.TeamName;
viewPlayer.Rating = player.Rating;
viewPlayer.BalanceOwed = player.BalanceOwed;
viewPlayers.Add(viewPlayer);
}
return viewPlayers;
}
}
private void LoadPlayerHistory(int p)
{
using (var db = new CSBCDbContext())
{
var rep = new PlayerHistoryVM(db);
var players = rep.PlayerHistory(p);
//gridPlayerHistory.DataSource = players;
//gridPlayerHistory.DataBind();
}
}