public void SecondTest()
{
using (var context = new AmerFamilyPlayoffContext(this.ContextOptions))
{
Assert.True(context.Playoffs.Count() == 1);
Assert.True(context.Playoffs.Include(p => p.Season).Single(p => p.Id == 2).Season.Year == 2019);
}
}
public void FirstTest()
{
using (var context = new AmerFamilyPlayoffContext(this.ContextOptions))
{
Assert.True(context.Teams.Count() == 32);
context.Teams.Add(new Team
{
Abbreviation = "",
Location = "",
Name = "",
});
context.SaveChanges();
Assert.True(context.Teams.Count() == 33);
}
}
public void GetSeasonTeamsTest()
{
using (var context = new AmerFamilyPlayoffContext(this.ContextOptions))
{
var count = context.SeasonTeams.Count();
Assert.True(count == (32 * 3));
var teamsController = new TeamsController(context);
var actual = teamsController.Get(new TeamQuery
{
Season = 2019,
}).Result;
Assert.True(actual.Count() == 32);
}
}
public TeamsController(AmerFamilyPlayoffContext context)
{
this.context = context ?? throw new ArgumentNullException(nameof(context));
}
public SeasonsController(AmerFamilyPlayoffContext context)
{
_context = context;
}
public static void Seed(this AmerFamilyPlayoffContext context)
{
var entitiesToAdd = new List <object>();
var seasonList = new List <Season>();
var twentyEighteenSeason = new Season
{
Year = 2018,
Description = "2018-2019"
};
var twentyNineteenSeason = new Season
{
Year = 2019,
Description = "2019-2020"
};
var twentyTwentySeason = new Season
{
Year = 2020,
Description = "2020-2021"
};
seasonList.Add(twentyEighteenSeason);
seasonList.Add(twentyNineteenSeason);
seasonList.Add(twentyTwentySeason);
entitiesToAdd.AddRange(seasonList);
var teamList = new List <Team>();
teamList.Add(new Team {
Abbreviation = "ARI", Location = "Arizona", Name = "Cardinals"
});
teamList.Add(new Team {
Abbreviation = "ATL", Location = "Atlanta", Name = "Falcons"
});
teamList.Add(new Team {
Abbreviation = "BAL", Location = "Baltimore", Name = "Ravens"
});
teamList.Add(new Team {
Abbreviation = "BUF", Location = "Buffalo", Name = "Bills"
});
teamList.Add(new Team {
Abbreviation = "CAR", Location = "Carolina", Name = "Panthers"
});
teamList.Add(new Team {
Abbreviation = "CHI", Location = "Chicago", Name = "Bears"
});
teamList.Add(new Team {
Abbreviation = "CIN", Location = "Cincinnati", Name = "Bengals"
});
teamList.Add(new Team {
Abbreviation = "CLE", Location = "Cleveland", Name = "Browns"
});
teamList.Add(new Team {
Abbreviation = "DAL", Location = "Dallas", Name = "Cowboys"
});
teamList.Add(new Team {
Abbreviation = "DEN", Location = "Denver", Name = "Broncos"
});
teamList.Add(new Team {
Abbreviation = "DET", Location = "Detroit", Name = "Lions"
});
teamList.Add(new Team {
Abbreviation = "GB", Location = "Green Bay", Name = "Packers"
});
teamList.Add(new Team {
Abbreviation = "HOU", Location = "Houston", Name = "Texans"
});
teamList.Add(new Team {
Abbreviation = "IND", Location = "Indianapolis", Name = "Colts"
});
teamList.Add(new Team {
Abbreviation = "JAX", Location = "Jacksonville", Name = "Jaguars"
});
teamList.Add(new Team {
Abbreviation = "KC", Location = "Kansas City", Name = "Chiefs"
});
teamList.Add(new Team {
Abbreviation = "LAC", Location = "Los Angeles", Name = "Chargers"
});
teamList.Add(new Team {
Abbreviation = "LAR", Location = "Los Angeles", Name = "Rams"
});
teamList.Add(new Team {
Abbreviation = "LV", Location = "Las Vegas", Name = "Raiders"
});
teamList.Add(new Team {
Abbreviation = "MIA", Location = "Miami", Name = "Dolphins"
});
teamList.Add(new Team {
Abbreviation = "MIN", Location = "Minnesota", Name = "Vikings"
});
teamList.Add(new Team {
Abbreviation = "NE", Location = "New England", Name = "Patriots"
});
teamList.Add(new Team {
Abbreviation = "NO", Location = "New Orleans", Name = "Saints"
});
teamList.Add(new Team {
Abbreviation = "NYG", Location = "New York", Name = "Giants"
});
teamList.Add(new Team {
Abbreviation = "NYJ", Location = "New York", Name = "Jets"
});
teamList.Add(new Team {
Abbreviation = "PHI", Location = "Philadelphia", Name = "Eagles"
});
teamList.Add(new Team {
Abbreviation = "PIT", Location = "Pittsburgh", Name = "Steelers"
});
teamList.Add(new Team {
Abbreviation = "SEA", Location = "Seattle", Name = "Seahawks"
});
teamList.Add(new Team {
Abbreviation = "SF", Location = "San Francisco", Name = "49ers"
});
teamList.Add(new Team {
Abbreviation = "TB", Location = "Tampa Bay", Name = "Buccaneers"
});
teamList.Add(new Team {
Abbreviation = "TEN", Location = "Tennessee", Name = "Titans"
});
teamList.Add(new Team {
Abbreviation = "WAS", Location = "Washington", Name = "Football Team"
});
entitiesToAdd.AddRange(teamList);
foreach (var season in seasonList)
{
foreach (var team in teamList)
{
entitiesToAdd.Add(new SeasonTeam
{
Season = season,
Team = team,
});
}
}
var twentyNineteenPlayoffs = new Playoff
{
Season = twentyNineteenSeason
};
entitiesToAdd.Add(twentyNineteenPlayoffs);
var wildCardRound = new Round
{
Name = "Wild Card",
Number = 1,
Matchups = new List <Matchup>(),
};
wildCardRound.Matchups.Add(new Matchup
{
AwayTeamId = 2,
HomeTeamId = 4,
});
entitiesToAdd.Add(wildCardRound);
entitiesToAdd.Add(new PlayoffRound
{
Playoff = twentyNineteenPlayoffs,
Round = wildCardRound,
});
context.AddRange(entitiesToAdd);
context.SaveChanges();
}
