//Método que agrega un jugador a la base de datos
public static void InsertPlayer(string player)
{
try
{
string query = $"INSERT INTO PLAYER(nickname) VALUES ('{player}')";
ConnectionDB.ExecuteNonQuery(query);
}
catch (PlayerRegistrationException Ex)
{
MessageBox.Show("Ha ocurrido un error!");
}
}
//Método que añade los score a la base de datos
public static void AddScore(int score, string nickname)
{
try
{
string query = $"INSERT INTO SCORE(score, nickname) VALUES ({score},'{nickname}');";
ConnectionDB.ExecuteNonQuery(query);
}
catch (AddScoreException e)
{
MessageBox.Show("Ha ocurrido un error!");
}
}
public static bool CreatePlayer(string nickname)
{
var dt = ConnectionDB.ExecuteQuery($"SELECT * FROM PLAYER WHERE nickname = '{nickname}'");
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
ConnectionDB.ExecuteNonQuery($"INSERT INTO PLAYER(nickname) VALUES ('{nickname}')");
return(false);
}
}
public static void NewScore(string idPlayer, int sc)
{
ConnectionDB.ExecuteNonQuery($"INSERT INTO SCORE(IdPlayer, score) VALUES ({idPlayer},{sc})");
}