public Person AddPerson(Person person) { db.Persons.Add(person); db.SaveChanges(); person = GetPersonById(person.Id); return(person); }
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 createFine(Fine fine) { using (var context = new TennisContext()) { context.Fines.Add(fine); context.SaveChanges(); } }
public void modifyGame(Game game) { using (var context = new TennisContext()) { context.Entry(game).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 createTeamPlayer(TeamPlayer tp) { using (var context = new TennisContext()) { context.TeamPlayers.Add(tp); 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 createGame(Game game) { using (var context = new TennisContext()) { context.Games.Add(game); 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 modifyDivision(Division div) { using (var context = new TennisContext()) { context.Entry(div).State = EntityState.Modified; context.SaveChanges(); } }
public void createDivision(Division div) { using (var context = new TennisContext()) { context.Divisions.Add(div); 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 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(); } }
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(); } }
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 IActionResult CurtManagement(CurtManagementModel model) { var curt = new Curt() { Name = model.Name }; _context.Add(curt); _context.SaveChanges(); return(RedirectToAction("CurtManagement", "Admin")); }
public void removePlayer(int roleId, int playerId) { Role role = getRoleById(roleId); using (var context = new TennisContext()) { Player player = context.Players.Find(playerId); role.Players.Remove(player); player.Roles.Remove(role); 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 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 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(); } }
public BookingReply PostBooking(Booking booking) { db.Bookings.Add(booking); db.SaveChanges(); return(new BookingReply(booking)); }
public Booking AddBooking(Booking booking) { db.Bookings.Add(booking); db.SaveChanges(); return(GetBookingById(booking.Id)); }
public PersonReply PostPerson(Person person) { db.Persons.Add(person); db.SaveChanges(); return(new PersonReply(person)); }