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 List <Player> PlayersTop() { var topPlayers = new List <Player>(); var dt = ConnectionDB.ExecuteQuery("SELECT PLAYER.nickname, SCORES.idscore " + "FROM PLAYER, SCORES " + "WHERE PLAYER.idPlayer = SCORES.idPlayer " + "ORDER BY SCORES.idscore DESC " + "LIMIT 10"); foreach (DataRow dr in dt.Rows) { topPlayers.Add(new Player(dr[0].ToString(), Convert.ToInt32(dr[1]))); } return(topPlayers); }
//Método encargada de guardar en una lista el nickname de los mejores 10 puntajes //ordenados de mayor a menor public static List <string> getNickName() { List <string> listScore = new List <string>(); DataTable dt = null; try { dt = ConnectionDB.ExecuteQuery("SELECT nickname FROM SCORE ORDER BY score DESC, score LIMIT 10"); } catch (Exception e) { MessageBox.Show("Ha ocurrido un error!"); } foreach (DataRow row in dt.Rows) { listScore.Add(row[0].ToString()); } return(listScore); }
//Método que permite el acceso a la base de datos para identificar jugadores existentes public static List <Player> getPlayer() { DataTable dt = null; List <Player> listPlayer = new List <Player>(); try { dt = ConnectionDB.ExecuteQuery("SELECT * FROM PLAYER"); } catch (Exception e) { MessageBox.Show("Ha ocurrido un error!"); } foreach (DataRow row in dt.Rows) { Player p = new Player(); p.nickname = row[0].ToString(); listPlayer.Add(p); } return(listPlayer); }
//Método que permite el acceso a la base de datos para identificar los puntajes //de los jugadores existentes public static List <Score> getPlayerScore() { List <Score> listScore = new List <Score>(); DataTable dt = null; try { dt = ConnectionDB.ExecuteQuery("SELECT * FROM SCORE"); } catch (Exception e) { MessageBox.Show("Ha ocurrido un error!"); } foreach (DataRow row in dt.Rows) { Score s = new Score(); s.idScore = Convert.ToInt32(row[0].ToString()); s.score = Convert.ToInt32(row[1].ToString()); s.nickname = row[3].ToString(); listScore.Add(s); } return(listScore); }