public void TestFillAdpData() { root data; using (var context = new FantasyContext()) { var reader = new XmlSerializer(typeof(root)); using (var file = new StreamReader(@"C:\Users\codyf_000\Documents\Visual Studio 2013\Projects\YahooFantasy\YahooFantasy.Tests\adp_xml_2011.xml")) { data = (root)reader.Deserialize(file); } var adpData = data.adp_data.Select(d => new Adp { PlayerName = d.name, TimesDrafted = d.times_drafted, OverallAdp = d.adp_overall, Position = d.pos, Team = d.team }); var adpList = adpData.ToList(); var year = DateTime.Parse(data.adp_info.start_date).Year; adpList.ForEach(a => a.Year = 2012); adpList.ForEach(a => context.Drafts.Add(a)); context.SaveChanges(); } }
public void TestScrapeDraft() { var draftData = Scraper.ScrapeDraft(2014); using (var context = new FantasyContext()) { draftData.ForEach(d => context.Drafts.Add(d)); context.SaveChanges(); } }
public void SaveSettings(SettingsRoot settings, string leagueJson, string settingsJson, string transactionsJson) { var context = new FantasyContext(); foreach (var league in settings.FantasyContent.Leagues) { decimal pointsPerReception = 0.0M; decimal pointsPerPassingTd = 4.0M; string ppr, ppptd; try { ppr = league.Settings.First() .StatModifiers.ModifiedStats .FirstOrDefault(s => s.ModifiedStat.StatId == 11) .ModifiedStat.Value; } catch { ppr = null; } try { ppptd = league.Settings.First() .StatModifiers.ModifiedStats .FirstOrDefault(s => s.ModifiedStat.StatId == 5) .ModifiedStat.Value; } catch { ppptd = null; } Decimal.TryParse(ppr, out pointsPerReception); Decimal.TryParse(ppptd, out pointsPerPassingTd); var dbLeague = new YahooFantasy.Models.Simple.Trades.League { LeagueKey = league.LeagueKey, NumberOfOwners = league.NumTeams, LeagueJson = leagueJson, SettingsJson = settingsJson, TransactionsJson = transactionsJson, PointsPerPassingTouchdown = pointsPerPassingTd, PointsPerReception = pointsPerReception }; context.Leagues.Add(dbLeague); context.SaveChanges(); } }
public PlayerService(FantasyContext context) { _context = context; }
public DevedoresController(FantasyContext context) { this._context = context; }
public HomeController(FantasyContext context) { dbContext = context; }
public EtapaParticipanteDao(FantasyContext fantasyContext) { _fantasyContext = fantasyContext; }
public DraftController(FantasyContext context) { dbContext = context; }
public ParticipantesController(FantasyContext context) { _context = context; }
public void TestFillPlayersTable() { var wrapper = new Api.ApiWrapper("nfl"); var players = wrapper.GetAllPlayers(); var playerTypes = new List <string>(); var playerPositions = new List <string>(); using (var context = new FantasyContext()) { foreach (var player in players) { if (!playerTypes.Any(p => p == player.PositionType)) { playerTypes.Add(player.PositionType); } if (!playerPositions.Any(p => p == player.DisplayPosition)) { playerPositions.Add(player.DisplayPosition); } var dbPlayer = new SimplePlayer { FirstName = player.Name.AsciiFirst, LastName = player.Name.AsciiLast, YahooPlayerId = Convert.ToInt32(player.PlayerId), FullName = player.Name.Full, UniformNumber = player.UniformNumber }; switch (player.PositionType) { case "O": dbPlayer.PlayerType = SimplePlayerTypes.OffensivePlayer; break; case "K": dbPlayer.PlayerType = SimplePlayerTypes.Kicker; break; case "DP": dbPlayer.PlayerType = SimplePlayerTypes.DefensivePlayer; break; case "DT": dbPlayer.PlayerType = SimplePlayerTypes.TeamDefense; break; default: dbPlayer.PlayerType = SimplePlayerTypes.Unknown; break; } var position = player.DisplayPosition; string primaryPosition; try { primaryPosition = position.Substring(0, position.IndexOf(',')); } catch { primaryPosition = position; } switch (primaryPosition) { case "QB": dbPlayer.PrimaryPosition = SimplePositionTypes.Quarterback; break; case "RB": dbPlayer.PrimaryPosition = SimplePositionTypes.Runningback; break; case "WR": dbPlayer.PrimaryPosition = SimplePositionTypes.Receiver; break; case "TE": dbPlayer.PrimaryPosition = SimplePositionTypes.TightEnd; break; case "DEF": dbPlayer.PrimaryPosition = SimplePositionTypes.TeamDefense; break; case "K": dbPlayer.PrimaryPosition = SimplePositionTypes.Kicker; break; case "CB": dbPlayer.PrimaryPosition = SimplePositionTypes.Cornerback; break; case "DT": dbPlayer.PrimaryPosition = SimplePositionTypes.DefensiveTackle; break; case "S": dbPlayer.PrimaryPosition = SimplePositionTypes.Safety; break; case "LB": dbPlayer.PrimaryPosition = SimplePositionTypes.Linebacker; break; case "DE": dbPlayer.PrimaryPosition = SimplePositionTypes.DefensiveEnd; break; default: dbPlayer.PrimaryPosition = SimplePositionTypes.Unknown; break; } context.Players.Add(dbPlayer); } context.SaveChanges(); } }
public void TestFillWeeklyStatsForOffensivePlayers() { var wrapper = new Api.ApiWrapper("nfl"); using (var context = new FantasyContext()) { var players = context.Players.ToList(); var playerStats = context.Stats.ToList(); var noStats = context.NoStats.ToList(); //var years = Enumerable.Range(2001, 13).OrderByDescending(i => i).ToList(); var years = Enumerable.Range(2011, 1).OrderByDescending(i => i).ToList(); var weeks = Enumerable.Range(1, 17).ToList(); var positions = new List <SimplePositionTypes> { SimplePositionTypes.Quarterback, SimplePositionTypes.Runningback, SimplePositionTypes.Receiver, SimplePositionTypes.TightEnd, SimplePositionTypes.Kicker }; var validPlayers = from pl in players join po in positions on pl.PrimaryPosition equals po select pl; foreach (var player in validPlayers) { foreach (var year in years) { foreach (var week in weeks) { var shouldPull = !playerStats.Any(ps => ps.Player.YahooPlayerId == player.YahooPlayerId && ps.Year.Year == year && ps.Week == week) && !noStats.Any(ns => ns.Player == player && ns.Week == week && ns.Year == year); if (!shouldPull) { continue; } var stats = new StatWrapper(); try { stats = wrapper.GetWeeklyStatsByPlayer(player.YahooPlayerId.ToString(), year.ToString(), week); } catch (KeyNotFoundException ex) { var noStat = new NoStats { Player = player, Week = week, Year = year }; context.NoStats.Add(noStat); context.SaveChanges(); continue; } catch { continue; } if (stats.Stats == null) { continue; } if (stats != null) { var simpleStat = new SimpleStats { Player = player, Year = new DateTime(year, 1, 1), Week = week, TeamName = stats.Team ?? "", TeamAbbreviation = stats.TeamAbbr ?? "", Position = player.PrimaryPosition == null ? 0 : player.PrimaryPosition }; foreach (var stat in stats.Stats) { var props = simpleStat.GetType().GetProperties(); foreach (var prop in props) { if (prop.CustomAttributes.Any(p => p.AttributeType == typeof(PlayerMappingAttribute))) { var attr = prop.GetCustomAttributes(typeof(PlayerMappingAttribute), false).FirstOrDefault(); var statId = ((PlayerMappingAttribute)attr).YahooStatId; if (stat.StatDetail.StatId == statId) { if (prop.PropertyType == typeof(int?)) { int nullableValue = 0; int.TryParse(stat.StatDetail.Value, out nullableValue); prop.SetValue(simpleStat, nullableValue); } else { var statValue = Convert.ChangeType(stat.StatDetail.Value, prop.PropertyType); prop.SetValue(simpleStat, statValue); } } } } } context.Stats.Add(simpleStat); context.SaveChanges(); } } } } } }
public void TestFillAnnualStatsForOffensivePlayers() { var wrapper = new Api.ApiWrapper("nfl"); using (var context = new FantasyContext()) { var players = context.Players.ToList(); var playerStats = context.Stats.ToList(); //var years = Enumerable.Range(2001, 13).OrderByDescending(i => i).ToList(); var years = Enumerable.Range(2013, 13).OrderByDescending(i => i).ToList(); var positions = new List <SimplePositionTypes> { //SimplePositionTypes.Quarterback, SimplePositionTypes.Runningback, SimplePositionTypes.Receiver //, //SimplePositionTypes.TightEnd, //SimplePositionTypes.Kicker }; var validPlayers = from pl in players join po in positions on pl.PrimaryPosition equals po select pl; foreach (var player in validPlayers) { foreach (var year in years) { var shouldPull = !playerStats.Any(ps => ps.Player.YahooPlayerId == player.YahooPlayerId && ps.Year.Year == year); if (!shouldPull) { continue; } var stats = new StatWrapper(); try { stats = wrapper.GetStatDataByPlayer(player.YahooPlayerId.ToString(), year.ToString()); } catch { if (stats.Stats == null) { continue; } } if (stats != null) { var simpleStat = new SimpleStats { Player = player, Year = new DateTime(year, 1, 1), Week = null, TeamName = stats.Team, TeamAbbreviation = stats.TeamAbbr }; switch (stats.Position) { case "QB": simpleStat.Position = SimplePositionTypes.Quarterback; break; case "RB": simpleStat.Position = SimplePositionTypes.Runningback; break; case "WR": simpleStat.Position = SimplePositionTypes.Receiver; break; case "TE": simpleStat.Position = SimplePositionTypes.TightEnd; break; case "DEF": simpleStat.Position = SimplePositionTypes.TeamDefense; break; case "K": simpleStat.Position = SimplePositionTypes.Kicker; break; case "CB": simpleStat.Position = SimplePositionTypes.Cornerback; break; case "DT": simpleStat.Position = SimplePositionTypes.DefensiveTackle; break; case "S": simpleStat.Position = SimplePositionTypes.Safety; break; case "LB": simpleStat.Position = SimplePositionTypes.Linebacker; break; case "DE": simpleStat.Position = SimplePositionTypes.DefensiveEnd; break; default: simpleStat.Position = SimplePositionTypes.Unknown; break; } foreach (var stat in stats.Stats) { var props = simpleStat.GetType().GetProperties(); foreach (var prop in props) { if (prop.CustomAttributes.Any(p => p.AttributeType == typeof(PlayerMappingAttribute))) { var attr = prop.GetCustomAttributes(typeof(PlayerMappingAttribute), false).FirstOrDefault(); var statId = ((PlayerMappingAttribute)attr).YahooStatId; if (stat.StatDetail.StatId == statId) { if (prop.PropertyType == typeof(int?)) { int nullableValue = 0; int.TryParse(stat.StatDetail.Value, out nullableValue); prop.SetValue(simpleStat, nullableValue); } else { var statValue = Convert.ChangeType(stat.StatDetail.Value, prop.PropertyType); prop.SetValue(simpleStat, statValue); } } } } } context.Stats.Add(simpleStat); context.SaveChanges(); } } } } }
public UserDao(FantasyContext fantasyContext) { _fantasyContext = fantasyContext; }
public EtapaController(FantasyContext context) { this._context = context; }