/// <summary>
/// Method "GetAll" returns a list of all sports and the information about them
/// </summary>
public List <Sport> GetAll()
{
using (sportsClubContext = new SportsClubContext(Connection))
{
return(sportsClubContext.Sports.ToList());
}
}
/// <summary>
/// Method "GetAll" returns a list of all trainers and the information about them
/// </summary>
public List <Trainer> GetAll()
{
using (sportsClubContext = new SportsClubContext(Connection))
{
return(sportsClubContext.Trainers.ToList());
}
}
/// <summary>
/// Method "Delete" finds an existing trainer to which the given id matches and deletes him
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Trainers.Find(id);
if (item != null)
{
foreach (var team in sportsClubContext.Teams)
{
if (team.TrainerId == item.Id)
{
TeamBusiness teamBusiness = new TeamBusiness();
teamBusiness.Delete(team.Id);
}
}
try
{
sportsClubContext.Trainers.Remove(item);
}
catch
{
sportsClubContext.Trainers.Remove(item);
}
sportsClubContext.SaveChanges();
}
}
}
/// <summary>
/// Method "Get" returns the trainer to which the given id matches
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Trainer Get(int?id)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
return(sportsClubContext.Trainers.Find(id));
}
}
/// <summary>
/// Method "Get" returns the sport to which the given id matches
/// </summary>
/// <param name="id"></param>
public Sport Get(int?id)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
return(sportsClubContext.Sports.Find(id));
}
}
/// <summary>
/// Method "Add" adds a new trainer to the database
/// </summary>
/// <param name="trainer"></param>
public void Add(Trainer trainer)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
CheckIfTrainerNameIsCorrect(trainer);
sportsClubContext.Trainers.Add(trainer);
sportsClubContext.SaveChanges();
}
}
public EFReservationUnitOfWork(SportsClubContext ctx,
ReservationRepository reservationRepository,
MemberRepository memberRepository,
CourtRepository courtRepository)
{
this.ctx = ctx;
ReservationRepository = reservationRepository;
MemberRepository = memberRepository;
CourtRepository = courtRepository;
}
/// <summary>
/// Method "Add" adds a new game to the database
/// </summary>
/// <param name="game"></param>
public void Add(Game game)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
CheckIfTeamExists(game.FirstTeamId);
CheckIfTeamExists(game.SecondTeamId);
sportsClubContext.Games.Add(game);
sportsClubContext.SaveChanges();
}
}
/// <summary>
/// Method "Add" adds a new player to the database
/// </summary>
/// <param name="player"></param>
public void Add(Player player)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
CheckIfTeamExists(player.TeamId);
CheckIfPlayerNameIsCorrect(player);
sportsClubContext.Players.Add(player);
sportsClubContext.SaveChanges();
}
}
/// <summary>
/// Method "Add" adds a new sport to the database
/// </summary>
/// <param name="sport"></param>
public void Add(Sport sport)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
CheckIfSportExists(sport);
CheckIfSportNameIsCorrect(sport);
sportsClubContext.Sports.Add(sport);
sportsClubContext.SaveChanges();
}
}
/// <summary>
/// Method "Add" adds a new team to the database
/// </summary>
/// <param name="team"></param>
public void Add(Team team)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
CheckIfSportExists(team.SportId);
CheckIfTrainerExists(team.TrainerId);
CheckIfTeamNameIsCorrect(team);
CheckIfTeamExists(team);
sportsClubContext.Teams.Add(team);
sportsClubContext.SaveChanges();
}
}
/// <summary>
/// Method "Update" finds an existing trainer and changes the information about him
/// </summary>
/// <param name="trainer"></param>
public void Update(Trainer trainer)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Trainers.Find(trainer.Id);
if (item != null)
{
CheckIfTrainerNameIsCorrect(trainer);
sportsClubContext.Entry(item).CurrentValues.SetValues(trainer);
sportsClubContext.SaveChanges();
}
}
}
/// <summary>
/// Method "Update" finds an existing game and changes the information about it
/// </summary>
/// <param name="game"></param>
public void Update(Game game)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Games.Find(game.Id);
if (item != null)
{
CheckIfTeamExists(game.FirstTeamId);
CheckIfTeamExists(game.SecondTeamId);
sportsClubContext.Entry(item).CurrentValues.SetValues(game);
sportsClubContext.SaveChanges();
}
}
}
/// <summary>
/// Method "Update" finds an existing player and changes the information about him
/// </summary>
/// <param name="player"></param>
public void Update(Player player)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Players.Find(player.Id);
if (item != null)
{
CheckIfTeamExists(player.TeamId);
CheckIfPlayerNameIsCorrect(player);
sportsClubContext.Entry(item).CurrentValues.SetValues(player);
sportsClubContext.SaveChanges();
}
}
}
/// <summary>
/// Method "Update" finds an existing sport and changes the information about it
/// </summary>
/// <param name="sport"></param>
public void Update(Sport sport)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Sports.Find(sport.Id);
if (item != null)
{
CheckIfSportExists(sport);
CheckIfSportNameIsCorrect(sport);
sportsClubContext.Entry(item).CurrentValues.SetValues(sport);
sportsClubContext.SaveChanges();
}
}
}
/// <summary>
/// Method "Get" returns the sport to which the given name matches and the information about them
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public Sport Get(string name)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
List <Sport> sports = sportsClubContext.Sports.ToList();
foreach (var item in sports)
{
if (item.Name == name)
{
return(item);
}
}
return(null);
}
}
/// <summary>
/// Method "Get" returns a list of all teams to which the given name matches and the information about them
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Team> Get(string name)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
List <Team> teams = sportsClubContext.Teams.ToList();
List <Team> teamsWithGivenName = new List <Team>();
foreach (var item in teams)
{
if (item.Name == name)
{
teamsWithGivenName.Add(item);
}
}
return(teamsWithGivenName);
}
}
/// <summary>
/// Method "Update" finds an existing team and changes the information about it
/// </summary>
/// <param name="team"></param>
public void Update(Team team)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Teams.Find(team.Id);
if (item != null)
{
CheckIfSportExists(team.SportId);
CheckIfTrainerExists(team.TrainerId);
CheckIfTeamNameIsCorrect(team);
CheckIfTeamExists(team);
sportsClubContext.Entry(item).CurrentValues.SetValues(team);
sportsClubContext.SaveChanges();
}
}
}
/// <summary>
/// Method "Get" returns a list of all trainers to which the given name matches and the information about them
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Trainer> Get(string name)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
List <Trainer> trainers = sportsClubContext.Trainers.ToList();
List <Trainer> trainersWithGivenName = new List <Trainer>();
foreach (var item in trainers)
{
if (item.Name == name)
{
trainersWithGivenName.Add(item);
}
}
return(trainersWithGivenName);
}
}
/// <summary>
/// Method "Delete" finds an existing game to which the given id matches and deletes it
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Games.Find(id);
if (item != null)
{
try
{
sportsClubContext.Games.Remove(item);
}
catch
{
sportsClubContext.Games.Remove(item);
}
sportsClubContext.SaveChanges();
}
}
}
/// <summary>
/// Method "Delete" finds an existing team to which the given id matches and deletes it
/// </summary>
/// <param name="id"></param>
public void Delete(int id)
{
using (sportsClubContext = new SportsClubContext(Connection))
{
var item = sportsClubContext.Teams.Find(id);
if (item != null)
{
foreach (var player in sportsClubContext.Players)
{
if (player.TeamId == item.Id)
{
sportsClubContext.Players.Remove(player);
}
}
foreach (var game in sportsClubContext.Games)
{
if (game.FirstTeamId == item.Id || game.SecondTeamId == item.Id)
{
sportsClubContext.Games.Remove(game);
}
}
try
{
sportsClubContext.Teams.Remove(item);
}
catch
{
sportsClubContext.Teams.Remove(item);
}
sportsClubContext.SaveChanges();
}
}
}
public EFReservationRepositoryAsync(SportsClubContext ctx)
{
this.ctx = ctx;
}
public EFCourtUnitOfWork(SportsClubContext ctx, CourtRepository courtRepository)
{
this.ctx = ctx;
CourtRepository = courtRepository;
}
public EFMemberRepository(SportsClubContext ctx)
{
this.ctx = ctx;
}
public EFReservationUnitOfWorkAsync(SportsClubContext ctx, ReservationRepositoryAsync reservationRepository)
{
this.ctx = ctx;
ReservationRepository = reservationRepository;
}
public EFMemberUnitOfWork(SportsClubContext ctx, MemberRepository memberRepository)
{
this.ctx = ctx;
MemberRepository = memberRepository;
}
public EFCourtRepository(SportsClubContext ctx)
{
this.ctx = ctx;
}
