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