//añade un nuevo jugador a la base
public static void AddPlayer(User u)
{
string sql = String.Format("insert into usuario(nombre) values('{0}');",
u.Name);
ConnectionBDD.ExecuteNonQuery(sql);
}
//verifica si existe el jugador
public static bool ExistPlayer(User user)
{
string sql = String.Format("select * from usuario where nombre = '{0}';", user.Name);
DataTable dt = ConnectionBDD.ExecuteQuery(sql);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
//devuelve lesta de jugadores registrados
public static User GetPlayer(User usu)
{
string sql = String.Format("select * from usuario where nombre = '{0}';", usu.Name);
DataTable dt = ConnectionBDD.ExecuteQuery(sql);
User user_ = new User();
foreach (DataRow fila in dt.Rows)
{
user_.Id_u = Convert.ToInt32(fila[0].ToString());
user_.Name = fila[1].ToString();
}
return(user_);
}
public static List <Score> getLista()
{
string sql = "select * from puntuacion order by puntaje desc limit 10";
DataTable dt = ConnectionBDD.ExecuteQuery(sql);
List <Score> list = new List <Score>();
foreach (DataRow row in dt.Rows)
{
Score p = new Score();
p.Id_p = Convert.ToInt32(row[0].ToString());
p.Id_u = Convert.ToInt32(row[1].ToString());
p.Score_ = Convert.ToInt32(row[2].ToString());
list.Add(p);
}
return(list);
}
public static List <UsserxScore> getTop(List <Score> p)
{
List <UsserxScore> list = new List <UsserxScore>();
foreach (Score score in p)
{
string sql = String.Format("select * from usuario where id_u = {0};", score.Id_u);
DataTable dt = ConnectionBDD.ExecuteQuery(sql);
UsserxScore uxp = new UsserxScore();
foreach (DataRow row in dt.Rows)
{
uxp.Name = row[1].ToString();
}
uxp.Score = score.Score_;
list.Add(uxp);
}
return(list);
}
public static void AddScore(int id, int puntaje)
{
string sql = String.Format("insert into puntuacion(id_u, puntaje) values({0}, {1});", id, puntaje);
ConnectionBDD.ExecuteNonQuery(sql);
}
