public void deletePlayer(int id) { using (var context = new TennisContext()) { Player player = context.Players //.Include(p => p.Roles) .Include(p => p.Fines) .Include(p => p.TeamPlayers.Select(tp => tp.Division)) .Include(p => p.TeamPlayers.Select(tp => tp.Team)) .SingleOrDefault(p => p.Id == id); List <Game> playerGames = context.Games.Where(g => g.Player1Id == id || g.Player2Id == id).ToList(); foreach (Game g in playerGames) { context.Entry(g).State = EntityState.Deleted; } foreach (Fine f in player.Fines) { context.Entry(f).State = EntityState.Deleted; } foreach (TeamPlayer tp in player.TeamPlayers) { context.Entry(tp).State = EntityState.Deleted; } context.Entry(player).State = EntityState.Deleted; context.SaveChanges(); } }
public void createGame(Game game) { using (var context = new TennisContext()) { context.Games.Add(game); context.SaveChanges(); } }
public void modifyGame(Game game) { using (var context = new TennisContext()) { context.Entry(game).State = EntityState.Modified; context.SaveChanges(); } }
public void modifyTeam(Team team) { using (var context = new TennisContext()) { context.Entry(team).State = EntityState.Modified; context.SaveChanges(); } }
public void createTeam(Team team) { using (var context = new TennisContext()) { context.Teams.Add(team); context.SaveChanges(); } }
public void createDivision(Division div) { using (var context = new TennisContext()) { context.Divisions.Add(div); context.SaveChanges(); } }
public void createTeamPlayer(TeamPlayer tp) { using (var context = new TennisContext()) { context.TeamPlayers.Add(tp); context.SaveChanges(); } }
public void modifyFine(Fine fine) { using (var context = new TennisContext()) { context.Entry(fine).State = EntityState.Modified; context.SaveChanges(); } }
public void createFine(Fine fine) { using (var context = new TennisContext()) { context.Fines.Add(fine); context.SaveChanges(); } }
public void modifyDivision(Division div) { using (var context = new TennisContext()) { context.Entry(div).State = EntityState.Modified; context.SaveChanges(); } }
public void createRole(Role role) { using (var context = new TennisContext()) { context.Roles.Add(role); context.SaveChanges(); } }
public void createPlayer(Player player) { using (var context = new TennisContext()) { context.Players.Add(player); context.SaveChanges(); } }
public void deleteRole(int id) { using (var context = new TennisContext()) { Role role = context.Roles.Find(id); context.Entry(role).State = EntityState.Deleted; context.SaveChanges(); } }
private void removeAllRoles(int id) { using (var context = new TennisContext()) { Player p = context.Players.Include(pl => pl.Roles).SingleOrDefault(pl => pl.Id == id); p.Roles.Clear(); context.SaveChanges(); } }
private void removeAllPlayers(int id) { using (var context = new TennisContext()) { Role r = context.Roles.Include(rl => rl.Players).SingleOrDefault(rl => rl.Id == id); r.Players.Clear(); context.SaveChanges(); } }
public List <Team> getTeams() { List <Team> teams = new List <Team>(); using (var context = new TennisContext()) { teams = context.Teams.ToList(); } return(teams); }
public Fine getFineById(int?id) { Fine fine; using (var context = new TennisContext()) { fine = context.Fines.Include(f => f.Player).SingleOrDefault(f => f.Id == id); } return(fine); }
public void deleteFine(int id) { Fine fine = getFineById(id); using (var context = new TennisContext()) { context.Entry(fine).State = EntityState.Deleted; context.SaveChanges(); } }
public List <Division> getDivisions() { List <Division> divisions = new List <Division>(); using (var context = new TennisContext()) { divisions = context.Divisions.ToList(); } return(divisions); }
public void deleteTeamPlayer(int playerId, int divisionId, int teamId) { TeamPlayer tp = getTeamPlayerById(playerId, divisionId, teamId); using (var context = new TennisContext()) { context.Entry(tp).State = EntityState.Deleted; context.SaveChanges(); } }
public List <Role> getRoles() { List <Role> roles = new List <Role>(); using (var context = new TennisContext()) { roles = context.Roles.ToList(); } return(roles); }
public List <Fine> getFines() { List <Fine> fines = new List <Fine>(); using (var context = new TennisContext()) { fines = context.Fines.Include(f => f.Player).ToList(); } return(fines); }
public Role getRoleById(int?id) { Role role; using (var context = new TennisContext()) { role = context.Roles.Include(r => r.Players).SingleOrDefault(r => r.Id == id); } return(role); }
public List <Player> getPlayers() { List <Player> players = new List <Player>(); using (var context = new TennisContext()) { players = context.Players.ToList(); } return(players); }
public Game getGameById(int?id) { Game game; using (var context = new TennisContext()) { game = context.Games.Include(g => g.Player1).Include(g => g.Player2).SingleOrDefault(g => g.Id == id); } return(game); }
public void deleteGame(int id) { Game game = getGameById(id); using (var context = new TennisContext()) { context.Entry(game).State = EntityState.Deleted; context.SaveChanges(); } }
public List <TeamPlayer> getTeamPlayers() { List <TeamPlayer> tp = new List <TeamPlayer>(); using (var context = new TennisContext()) { tp = context.TeamPlayers.Include(t => t.Division).Include(t => t.Player).Include(t => t.Team).ToList(); } return(tp); }
public List <Game> getGames() { List <Game> games = new List <Game>(); using (var context = new TennisContext()) { games = context.Games.Include(g => g.Player1).Include(g => g.Player2).ToList(); } return(games); }
public TeamPlayer getTeamPlayerById(int?playerId, int?divisionId, int?teamId) { TeamPlayer tp; using (var context = new TennisContext()) { tp = context.TeamPlayers.Include(t => t.Division).Include(t => t.Player).Include(t => t.Team) .SingleOrDefault(t => t.DivisionId == divisionId && t.PlayerId == playerId && t.TeamId == teamId); } return(tp); }
public Team getTeamById(int?id) { Team team; using (var context = new TennisContext()) { team = context.Teams.Include(t => t.TeamPlayers.Select(tp => tp.Division)) .Include(t => t.TeamPlayers.Select(tp => tp.Player)) .SingleOrDefault(t => t.Id == id); } return(team); }