PlayerObj FindPickedPlayer(int playerID) { PlayerObj match = null; var intPicked = (int)DraftMoveType.Pick; var intKept = (int)DraftMoveType.Keep; var pickedPlayer = from p in db.DraftMoves where p.SeasonID == Settings.DraftSeasonID && (p.MoveType == intPicked || p.MoveType == intKept) && p.PlayerID.HasValue && p.PlayerID == playerID select p; if (pickedPlayer.Count() > 0) match = new PlayerObj(pickedPlayer.First().Player); return match; }
PlayerObj FindPlayer(int playerID) { PlayerObj match = null; var allPlayers = from t in db.Players where t.PlayerID == playerID select t; if (allPlayers.Count() > 0) match = new PlayerObj(allPlayers.First()); return match; }
public Dictionary<String, PlayerObj> GetPlayerMap() { Dictionary<String, PlayerObj> allPlayers = new Dictionary<String, PlayerObj>(); var query = from t in db.Players select t; foreach (Player p in query) { PlayerObj nextPlayer = new PlayerObj() { PlayerID = p.PlayerID, FirstName = p.FirstName, LastName = p.LastName, Suffix = p.Suffix, Identity = p.Identifier, Team = p.Team, Position = p.Position }; allPlayers[nextPlayer.PlayerID.ToString()] = nextPlayer; } return allPlayers; }