public static void TradePlayer(int playerId, int newTeamId) { HockeyEntities db = new HockeyEntities(); Player player = db.Players.Where(p => p.Id == playerId).FirstOrDefault(); player.TeamId = newTeamId; db.SaveChanges(); }
public ActionResult TradePlayer(int?playerid) { HockeyEntities db = new HockeyEntities(); Player player = db.Players.Where(p => p.Id == playerid).FirstOrDefault(); List <Team> teams = db.Teams.Where(t => t.Id != player.TeamId).ToList(); ViewBag.availableTeams = teams; return(View(player)); }
public ActionResult TeamPlayers(int?TeamId) { if (TeamId == null) { return(HttpNotFound()); } //int TeamId = int.Parse(Request.QueryString["TeamId"]) HockeyEntities db = new HockeyEntities(); Team team = db.Teams.Where(t => t.Id == TeamId.Value).FirstOrDefault(); return(View(team)); }
// GET: Home public ActionResult Index() { HockeyEntities db = new HockeyEntities(); return(View(db.Teams.ToList())); }