public static List <TimedScore> getScores()
{
try {
List <TimedScore> scores = new List <TimedScore>();
TimedScore timedScores;
string _conn = MainWindow.connStr;
string sqlGetTimed = "SELECT playername, score FROM highscores WHERE mode = \"timed\" ORDER BY score DESC LIMIT 10";
int _rank = 1;
using (MySqlConnection connection = new MySqlConnection(_conn)) {
connection.Open();
using (MySqlCommand cmdTimed = new MySqlCommand(sqlGetTimed, connection))
using (MySqlDataReader reader = cmdTimed.ExecuteReader()) {
while (reader.Read())
{
timedScores = new TimedScore();
timedScores.Rank = _rank;
timedScores.Name = reader.GetString(0);
timedScores.Score = reader.GetString(1);
scores.Add(timedScores);
_rank++;
}
reader.Close();
}
return(scores);
}
} catch (Exception ex) {
throw new Exception(ex.Message);
}
}
private void HighscoresButton_Click(object sender, RoutedEventArgs e)
{
try {
MenuButtons.Visibility = Visibility.Hidden;
highscoresCanvas.Visibility = Visibility.Visible;
topSoloScores.ItemsSource = SoloScore.getScores();
topTimedScores.ItemsSource = TimedScore.getScores();
} catch (Exception ex) {
MessageBox.Show(ex.Message, "Highscores buttons");
}
}
