Ejemplo n.º 1
0
        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;
        }
Ejemplo n.º 2
0
        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;
        }
Ejemplo n.º 3
0
        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;
        }