//Crear jugador y comprobar si ya existe en BD
private bool CreatePlayer(string nickname)
{
var dt = DataBaseController.ExecuteQuery($"SELECT * FROM PLAYER WHERE nickname = '{nickname}'");
if (dt.Rows.Count > 0)
{
var dt2 = DataBaseController.ExecuteQuery($"SELECT idPlayer FROM PLAYER WHERE nickname = '{nickname}'");
foreach (DataRow dr in dt2.Rows)
{
GameData.idPlayer = Convert.ToInt32(dr[0]);
}
return(true);
}
else
{
DataBaseController.ExecuteNonQuery("INSERT INTO PLAYER(nickname) VALUES" +
$"('{nickname}')");
var dt3 = DataBaseController.ExecuteQuery($"SELECT idPlayer FROM PLAYER WHERE nickname = '{nickname}'");
foreach (DataRow dr in dt3.Rows)
{
GameData.idPlayer = Convert.ToInt32(dr[0]);
}
return(false);
}
}
//Obtener la lista Top 10 de BD
private List <Player> ObtainTopPlayers()
{
var topPlayers = new List <Player>();
DataTable dt = DataBaseController.ExecuteQuery("SELECT pl.nickname, sc.score " +
"FROM PLAYER pl, SCORES sc " +
"WHERE pl.idPlayer = sc.idPlayer " +
"ORDER BY sc.score DESC " +
"LIMIT 10");
foreach (DataRow dr in dt.Rows)
{
topPlayers.Add(new Player(dr[0].ToString(), Convert.ToInt32(dr[1])));
}
return(topPlayers);
}