public static List <Player> getPlayers()
{
string query = "SELECT * FROM players";
DataTable dt = Connection_BD.ExecuteQuery(query: query);
List <Player> lista = new List <Player>();
foreach (DataRow fila in dt.Rows)
{
Player u = new Player();
u.nickname = fila[0].ToString();
u.password = fila[1].ToString();
lista.Add(u);
}
return(lista);
}
public static List <userScore> getScores()
{
//Returns all of the saved scores in the DB
string sql = String.Format(
"SELECT * FROM top");
DataTable dt = Connection_BD.ExecuteQuery(sql);
List <userScore> scoreBoard = new List <userScore>();
foreach (DataRow fila in dt.Rows)
{
userScore user = new userScore();
user.nickname = fila[0].ToString();
user.playerscore = Convert.ToInt32(fila[1].ToString());
scoreBoard.Add(user);
}
return(scoreBoard);
}