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