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