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