public ActionResult Index()
{
IEnumerable <PvP> pvpStats = pvPTable.GetAll();
IEnumerable <Player> players = playerTable.GetAll();
IEnumerable <Game> games = gameTable.GetAll();
try
{
var pvpScoreboard = from s in pvpStats
join p in players on s.pID equals p.ID
join g in games on s.gID equals g.ID
select new PvPViewModel
{
WinnerName = p.Name,
OpponentName = s.OpponentName,
GameName = g.Name,
lastPlayedDate = s.LastMatch
};
ViewBag.Title = "PvP";
return(View(pvpScoreboard));
}
catch
{
return(View("Home"));
}
}
public ActionResult HomePage(HomeViewModel homeViewModel)
{
IEnumerable <HighScore> highScores = hsTable.GetAll();
IEnumerable <PvP> pvpStats = plTable.GetAll();
try
{
int iD = Convert.ToInt32(Session["id"]);
PvP userPVP = pvpStats.Where(p => p.ID == iD).FirstOrDefault();
HighScore userHS = highScores.Where(h => h.pID == iD).FirstOrDefault();
homeViewModel.highScore = userHS;
homeViewModel.pvpStat = userPVP;
homeViewModel.Name = Convert.ToString(Session["name"]);
return(View(homeViewModel));
}
catch
{
return(View("Error"));
}
}
