public void Get_Id_Success()
{
var fixture = fixtureRepository.Get(1);
Assert.That(fixture, Is.Not.Null);
Assert.That(fixture.HomeTeamLeague.Id, Is.EqualTo(1));
}
public int?GetFixtureIdForBiggestedHomeWinForTeam(int teamId)
{
// Select all the fixture id and winning margin for all winning home fixtures
var homeWinsPointsDifference = from f in fixtureRepository.Get()
where f.HomeTeamLeague.Team.Id == teamId &&
f.HomeTeamScore > f.AwayTeamScore
select new { f.Id, Diff = f.HomeTeamScore - f.AwayTeamScore };
// Select the fixtureI of the fixture with the biggest margin
return((from fixture in homeWinsPointsDifference
group fixture by new { fixture.Id, fixture.Diff } into grp
orderby grp.Key.Diff descending
select grp.Key.Id).Take(1).SingleOrDefault());
}
public IQueryable <Fixture> GetCupFixturesForSeason(int cupId, int seasonId)
{
return(from f in fixtureRepository.Get()
where f.IsCupFixture && f.Cup.Id == cupId &&
f.HomeTeamLeague.League.Season.Id == seasonId
select f);
}
public List <Fixture> GetFixturesForTeamLeagues(List <int> teamLeagueIds)
{
return((from f in fixtureRepository.Get()
where teamLeagueIds.Contains(f.HomeTeamLeague.Id) ||
teamLeagueIds.Contains(f.AwayTeamLeague.Id)
select f).ToList());
}
public TFixture Get(int id)
{
return(FixtureRepository.Get <TFixture, TAvailableSources>(id));
}
public Fixture GetFixture(int id)
{
return(fixtureRepository.Get(id));
}