public static int GetId(String name)
{
String query = $"SELECT PlayerID from PLAYER WHERE nickname = '{name}';";
var user = ConnectionDb.ExecuteQuery(query);
return(Convert.ToInt32(user.Rows[0][0]));
}
private static void InsertPlayer(String username)
{
//Consulta para insertar nuevo usuario con su respectivo nickname
String query = $"INSERT INTO PLAYER(nickname) VALUES('{username}');";
ConnectionDb.ExecuteNonQuery(query);
}
public static DataTable GetTop10PlayersTable()
{
String query = $"SELECT pl.nickname, sc.score FROM PLAYER pl, SCORE sc " +
"WHERE pl.playerID = sc.playerID ORDER BY score DESC LIMIT 10;";
DataTable dt = ConnectionDb.ExecuteQuery(query);
return(dt);
}
public static int BestScore(int id)
{
String query = $"SELECT MAX(score) FROM score WHERE playerid = {id};";
DataTable dt = ConnectionDb.ExecuteQuery(query);
DataRow row = dt.Rows[0];
int score = Convert.ToInt32(row[0].ToString());
return(score);
}
public static List <Player> GetTop10PlayersList()
{
String query = $"SELECT nickname FROM PLAYER pl, SCORE sc WHERE pl.playerID = sc.playerID " +
"ORDER BY score DESC LIMIT 10;";
DataTable dataT = ConnectionDb.ExecuteQuery(query);
var listTop10Players = new List <Player>();
foreach (DataRow row in dataT.Rows)
{
Player pl = new Player();
pl.Name = row[0].ToString();
listTop10Players.Add(pl);
}
return(listTop10Players);
}
public static Player CurrentPlayer(string nick)
{
//Declaración de variable auxiliar utilizada para las distintas consultas.
//Consulta para verificar existencia de nickname ingresado.
String userQuerys = $"SELECT * FROM PLAYER WHERE nickname = '{nick}';";
DataTable dt = ConnectionDb.ExecuteQuery(userQuerys);
if (dt.Rows.Count == 1)
{
Player current = new Player();
DataRow row = dt.Rows[0];
current.PlayerId = Convert.ToInt32(row[0]);
current.Name = row[1].ToString();
return(current);
}
//Si no se encontró el usuario ingresado
InsertPlayer(nick);
return(new Player(nick, 0));
}
public static void InsertPlayerScore(int score, int id)
{
String query = $"INSERT INTO SCORE(score, playerID) VALUES({score}, {id});";
ConnectionDb.ExecuteNonQuery(query);
}