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