public void CreateRanking(RankingPers ranking)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
cdl.Rankings.Add(ranking);
cdl.SaveChanges();
}
public void DeleteRankingPerCompetitor(Guid competitorID)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
cdl.Rankings.SqlQuery("delete from Rankings where CompetitorID = '" + competitorID.ToString() + "'");
cdl.SaveChanges();
}
public void DeleteAllRankings()
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
cdl.Rankings.RemoveRange(cdl.Rankings);
cdl.SaveChanges();
}
/// <summary>
/// Erstelle ein neues Torunament in der Datenbank
/// </summary>
/// <param name="tournament">Objekt des Toournaments das erstellt werden soll</param>
public void CreateTournament(TournamentPers tournament)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
cdl.Tournaments.Add(tournament);
cdl.SaveChanges();
}
/// <summary>
/// Lösche ein Tournament in der Datenbank
/// </summary>
/// <param name="name">Name des Tournaments das gelöscht werden soll</param>
public void DeleteTournament(String name)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
cdl.Tournaments.Remove(cdl.Tournaments.Find(name));
cdl.SaveChanges();
}
public void SetWinner(String turniername, Guid compID)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
RankingPers rp = cdl.Rankings.Find(compID, turniername);
rp.WonFinal = true;
cdl.SaveChanges();
}
/// <summary>
/// Update Tournament in der Datenbank
/// </summary>
/// <param name="tournament">Objekt des Tournaments das Aktualisiert werden soll</param>
public void UpdateTournament(TournamentPers newTournament)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
TournamentPers oldTournament = cdl.Tournaments.Find(newTournament.Name);
oldTournament.IsFinished = newTournament.IsFinished;
cdl.SaveChanges();
}
public static List <TournamentPers> GetAllTournaments(String username)
{
using (DatabaseContextInstance db = DatabaseContext.GetContext())
{
List <TournamentPers> query = db.Tournaments
.SqlQuery("select * from Tournaments where Username = '******'").ToList();
return(query.OrderByDescending(o => o.Date).ToList());
}
}
public static void DeleteTournamentInDB(String turniername)
{
using (DatabaseContextInstance db = DatabaseContext.GetContext())
{
try
{
db.Database.ExecuteSqlCommand("delete from Rankings where Tournament = " + "'" + turniername + "'");
db.Database.ExecuteSqlCommand("delete from Tournaments where Name = " + "'" + turniername + "'");
} catch
{
throw new Exception("Fehler beim löschen eines Turniers");
}
}
}
public static List <RankingPers> LoadRankings(String turniername)
{
CompetitorIMPL cimpl = new CompetitorIMPL();
using (DatabaseContextInstance db = DatabaseContext.GetContext())
{
List <RankingPers> query = db.Rankings
.SqlQuery("select * from Rankings r where r.Tournament = " + "'" + turniername + "'").ToList();
//Vorname + Nachname der jeweiligen CompetitorID als String anfügen.
foreach (RankingPers rp in query)
{
rp.CVornameNachname = cimpl.FindCompetitor(rp.CompetitorID).Name + " " +
cimpl.FindCompetitor(rp.CompetitorID).Surname;
}
return(query.OrderByDescending(o => o.Wins).ToList());
}
}
public RankingPers FindRanking(String tournament, Guid competitorID)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
return(cdl.Rankings.Find(tournament, competitorID));
}
/// <summary>
/// Ein Turnier finden und zurückgeben
/// </summary>
public TournamentPers FindTournament(String name)
{
DatabaseContextInstance cdl = DatabaseContext.GetContext();
return(cdl.Tournaments.Find(name));
}
