public void Save(Fixture fixture)
{
using (var context = new ScoreSquidContext())
{
commands.SaveFixture(context, fixture);
}
}
public List<Fixture> GetAll()
{
using(var context = new ScoreSquidContext())
{
return commands.GetAllFixtures(context);
}
}
public Fixture GetByHomeTeamNameAndAwayTeamName(string homeTeamName, string awayTeamName)
{
using (var context = new ScoreSquidContext())
{
return commands.GetFixturesByHomeTeamNameAndAwayTeamName(context, homeTeamName, awayTeamName);
}
}
public void SaveNewTeam(string teamName, Division division)
{
using (var context = new ScoreSquidContext())
{
commands.SaveNewTeam(context, teamName, division);
}
}
public bool TeamExists(string teamName)
{
using (var context = new ScoreSquidContext())
{
return commands.TeamExists(context, teamName);
}
}
public Division LoadDivisionByIdentifier(string divisionIdentifier)
{
using (var context = new ScoreSquidContext())
{
return commands.LoadDivisionByIdentifier(context, divisionIdentifier);
}
}
public Team LoadTeamByName(string teamName)
{
using (var context = new ScoreSquidContext())
{
return commands.LoadTeamByName(context, teamName);
}
}
public Team LoadById(int id)
{
using (var context = new ScoreSquidContext())
{
return commands.LoadTeamById(context, id);
}
}
public List<Team> GetAll()
{
using (var context = new ScoreSquidContext())
{
return commands.GetAllTeams(context);
}
}
public void Save(Division division)
{
using (var context = new ScoreSquidContext())
{
commands.SaveDivison(context, division);
}
}
public Player Login(string username, string password)
{
using (var context = new ScoreSquidContext())
{
return commands.LoginPlayer(context, username, password);
}
}
public Player Register(Player player)
{
using (var context = new ScoreSquidContext())
{
return commands.RegisterPlayer(context, player);
}
}
public List<Division> GetAll()
{
using (var context = new ScoreSquidContext())
{
return commands.GetAllDivisions(context);
}
}
public Team LoadTeamByName(ScoreSquidContext context, string teamName)
{
return context
.Teams
.Include(x => x.Division)
.FirstOrDefault(x => x.Name == teamName);
}
public Player LoginPlayer(ScoreSquidContext context, string username, string password)
{
return context
.Players
.FirstOrDefault(x => x.Username.Equals(username)
&& x.Password.Equals(password));
}
public Division GetDivisionByIdentifier(ScoreSquidContext context, string leagueIdentifier)
{
return context
.Divisions
.Include(x => x.Teams)
.FirstOrDefault(x => x.DivisionIdentifier.Equals(leagueIdentifier));
}
public Team LoadTeamById(ScoreSquidContext context, int id)
{
return context
.Teams
.Include(x => x.Division)
.FirstOrDefault(x => x.Id.Equals(id));
}
public List<Team> GetAllTeams(ScoreSquidContext context)
{
return context
.Teams
.Include(x => x.Division)
.ToList();
}
public List<Division> GetAllDivisions(ScoreSquidContext context)
{
return context
.Divisions
.Include(x => x.Teams)
.ToList();
}
public Division GetByIdentifier(string leagueIdentifier)
{
using (var context = new ScoreSquidContext())
{
return commands.GetDivisionByIdentifier(context, leagueIdentifier);
}
}
public void SaveDivison(ScoreSquidContext context, Division division)
{
context.Divisions.Add(division);
context.Save();
}
public Player RegisterPlayer(ScoreSquidContext context, Player player)
{
context.Players.Add(player);
context.Save();
return player;
}
public Division LoadDivisionByIdentifier(ScoreSquidContext context, string divisionIdentifier)
{
return context
.Divisions
.FirstOrDefault(x => x.DivisionIdentifier.Equals(divisionIdentifier));
}
public Fixture GetFixturesByHomeTeamNameAndAwayTeamName(ScoreSquidContext context, string homeTeamName, string awayTeamName)
{
return context.Fixtures.FirstOrDefault(x => x.HomeTeam.Name == homeTeamName && x.AwayTeam.Name == awayTeamName);
}
public List<Fixture> GetAllFixtures(ScoreSquidContext context)
{
return context.Fixtures.ToList();
}
public void SaveFixture(ScoreSquidContext context, Fixture fixture)
{
context.Fixtures.Add(fixture);
context.Save();
}
public void SaveNewTeam(ScoreSquidContext context, string teamName, Division division)
{
Team team = new Team { Name = teamName, Division = division };
context.Teams.Add(team);
context.Save();
}
public bool TeamExists(ScoreSquidContext context, string teamName)
{
return context
.Teams
.Any(x => x.Name == teamName);
}
