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()); } }
/// <summary> /// Verteilt das Gewonnene / Verlorene gleichmäßig SkillLevel auf die beiden Spieler /// </summary> public void DistribiuteSkillLevel() { CompetitorIMPL cimpl = new CompetitorIMPL(); int distributedSkillLevel = NewSkillLevel - SkillLevel; if (SpielerListe.Count == 2) { SpielerListe.ElementAt(0).SetSkillLevel(distributedSkillLevel / 2); SpielerListe.ElementAt(1).SetSkillLevel(distributedSkillLevel / 2); Competitor c1 = (Competitor)SpielerListe.ElementAt(0); Competitor c2 = (Competitor)SpielerListe.ElementAt(1); cimpl.UpdateCompetitor(c1.CompetitorID, (distributedSkillLevel / 2)); cimpl.UpdateCompetitor(c2.CompetitorID, (distributedSkillLevel / 2)); } else { SpielerListe.ElementAt(0).SetSkillLevel(distributedSkillLevel); Competitor c1 = (Competitor)SpielerListe.ElementAt(0); cimpl.UpdateCompetitor(c1.CompetitorID, (distributedSkillLevel / 2)); } }