//Application State auf ausgewaehlten Teilnehmer setzen
private void dg_competitor_list_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (dg_competitor_list.SelectedItem != null)
{
object item = dg_competitor_list.SelectedItem;
string ID = (dg_competitor_list.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text;
ApplicationState.SetValue("SelectedCompetitor", comp.FindCompetitor(Guid.Parse(ID)));
}
}
//Anzeigen des ausgewaehlten Teilnehmers in den Feldern auf der rechten Seite
private void dg_competitor_list_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (dg_competitor_list.SelectedItem != null)
{
object item = dg_competitor_list.SelectedItem;
string ID = (dg_competitor_list.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text;
Guid compID = Guid.Parse(ID);
Competitor competitor = comp.FindCompetitor(compID);
l_compID.Content = ID;
tb_name.Text = competitor.Name;
tb_surname.Text = competitor.Surname;
string gender = competitor.Gender;
if (gender == "männlich")
{
cb_gender.SelectedIndex = 1;
}
if (gender == "weiblich")
{
cb_gender.SelectedIndex = 2;
}
string visibility = competitor.Visibility;
if (visibility == "global")
{
cb_visibility.SelectedIndex = 1;
}
if (visibility == "lokal")
{
cb_visibility.SelectedIndex = 2;
}
}
}
catch
{
MessageBox.Show(
"Es ist ein Fehler aufgetreten. Sie können diesen Teilnehmer im Moment nicht bearbeiten",
"KICKERCUP", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
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());
}
}
