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