public static void AddtoScoreboard(string nickname, int score)
{
//Adds score to db
try
{
Connection_BD.ExecuteNonQuery($"INSERT INTO top VALUES('{nickname}', {score})");
}
catch (Exception exception)
{
Console.WriteLine("Ha ocurrido un error");
}
}
public static void changePassword(Player u, string newPassword)
{
try
{
string nQ = $"UPDATE players SET password = '******' WHERE nickname = '{u.nickname}' ";
Connection_BD.ExecuteNonQuery(nQ);
MessageBox.Show($"Updated Password successfully. Be careful Padawan!");
}
catch (Exception e)
{
Console.WriteLine(e.Message);
MessageBox.Show("Ha ocurrido un error. Intentelo de nuevo.");
}
}
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 bool addUser(Player u)
{
try
{
string nQ = $"INSERT INTO players(nickname, password) VALUES(" +
$"'{u.nickname}', " +
$"'{u.password}')";
Connection_BD.ExecuteNonQuery(nQ);
MessageBox.Show($"Player '{u.nickname}' added correctly. " +
$"May the force be with you, young padawan");
return(true);
}
catch (Exception e)
{
Console.WriteLine(e); Console.WriteLine(e.Message);
MessageBox.Show("Ha ocurrido un error. Intentelo de nuevo.");
return(false);
}
}
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);
}