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