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 deleteDivision(int id)
{
using (var context = new TennisContext())
{
Division div = context.Divisions.Include(d => d.TeamPlayers.Select(tp => tp.Player))
.Include(d => d.TeamPlayers.Select(tp => tp.Team))
.SingleOrDefault(d => d.Id == id);
foreach (TeamPlayer tp in div.TeamPlayers)
{
context.Entry(tp).State = EntityState.Deleted;
}
context.Entry(div).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void deleteTeam(int id)
{
using (var context = new TennisContext())
{
Team team = context.Teams.Include(t => t.TeamPlayers.Select(tp => tp.Division))
.Include(t => t.TeamPlayers.Select(tp => tp.Player))
.SingleOrDefault(t => t.Id == id);
foreach (TeamPlayer tp in team.TeamPlayers)
{
context.Entry(tp).State = EntityState.Deleted;
}
context.Entry(team).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void modifyTeam(Team team)
{
using (var context = new TennisContext())
{
context.Entry(team).State = EntityState.Modified;
context.SaveChanges();
}
}
public void modifyDivision(Division div)
{
using (var context = new TennisContext())
{
context.Entry(div).State = EntityState.Modified;
context.SaveChanges();
}
}
public void modifyFine(Fine fine)
{
using (var context = new TennisContext())
{
context.Entry(fine).State = EntityState.Modified;
context.SaveChanges();
}
}
public void modifyGame(Game game)
{
using (var context = new TennisContext())
{
context.Entry(game).State = EntityState.Modified;
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();
}
}
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 void deleteFine(int id)
{
Fine fine = getFineById(id);
using (var context = new TennisContext())
{
context.Entry(fine).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void deleteGame(int id)
{
Game game = getGameById(id);
using (var context = new TennisContext())
{
context.Entry(game).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void modifyPlayer(Player player)
{
using (var context = new TennisContext())
{
removeAllRoles(player.Id);
Player p = new Player
{
BirthDay = player.BirthDay,
City = player.City,
FederationNr = player.FederationNr,
FirstName = player.FirstName,
Gender = player.Gender,
HouseNr = player.HouseNr,
Id = player.Id,
LastName = player.LastName,
MailBox = player.MailBox,
PhoneNr = player.PhoneNr,
PlayerNr = player.PlayerNr,
Street = player.Street,
YearOfJoin = player.YearOfJoin,
Zipcode = player.Zipcode,
Roles = new List <Role>()
};
context.Players.Attach(p);
foreach (Role role in player.Roles)
{
Role r = new Role {
Id = role.Id
};
context.Roles.Attach(r);
p.Roles.Add(r);
}
context.Entry(p).State = EntityState.Modified;
context.SaveChanges();
}
}
public void modifyRole(Role role)
{
using (var context = new TennisContext())
{
removeAllPlayers(role.Id);
Role r = new Role {
Id = role.Id, Name = role.Name, Players = new List <Player>()
};
context.Roles.Attach(r);
foreach (Player player in role.Players)
{
Player p = new Player {
Id = player.Id
};
context.Players.Attach(p);
r.Players.Add(p);
}
context.Entry(r).State = EntityState.Modified;
context.SaveChanges();
}
}