public static List <SoloScore> getScores() { try { List <SoloScore> scores = new List <SoloScore>(); SoloScore soloScores; string _conn = MainWindow.connStr; string sqlGetSolo = "SELECT playername, time FROM highscores WHERE mode = \"solo\" ORDER BY time LIMIT 10"; int _rank = 1; using (MySqlConnection connection = new MySqlConnection(_conn)) { connection.Open(); using (MySqlCommand cmdSolo = new MySqlCommand(sqlGetSolo, connection)) using (MySqlDataReader reader = cmdSolo.ExecuteReader()) { while (reader.Read()) { soloScores = new SoloScore(); soloScores.Rank = _rank; soloScores.Name = reader.GetString(0); soloScores.Time = reader.GetString(1); scores.Add(soloScores); _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"); } }