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