public static SkateParks TraerDestSKP()
{
SkateParks SKP = new SkateParks();
SqlConnection conn = Conectar();
SqlCommand consulta = conn.CreateCommand();
consulta.CommandText = "SELECT * FROM Skateparks where Destacado = " + 1;
consulta.CommandType = System.Data.CommandType.Text;
SqlDataReader lector = consulta.ExecuteReader();
if (lector.HasRows)
{
while (lector.Read())
{
int IdSkatePark = Convert.ToInt32(lector["IdSkatePark"]);
string Nombre = lector["Nombre"].ToString();
string Ubicacion = lector["Ubicacion"].ToString();
string Descripcion = lector["Descripcion"].ToString();
string Imagen = lector["Foto"].ToString();
Boolean Destacada = Convert.ToBoolean(lector["Destacado"] is DBNull ? 0 : lector["Destacado"]);
SKP = new SkateParks(IdSkatePark, Nombre, Imagen, Descripcion, Destacada, Ubicacion);
}
}
Desconectar(conn);
return(SKP);
}
public static List <SkateParks> ListarSkateParks()
{
List <SkateParks> ListaSkateParks = new List <SkateParks>();
SqlConnection Conn = Conectar();
SqlCommand Consulta = Conn.CreateCommand();
Consulta.CommandType = System.Data.CommandType.Text;
Consulta.CommandText = "SELECT * from SkateParks ";
SqlDataReader Lector = Consulta.ExecuteReader();
while (Lector.Read())
{
int IdSKP = Convert.ToInt32(Lector["idSkatePark"]);
string Nom = (Lector["Nombre"].ToString());
string Ub = (Lector["Ubicacion"].ToString());
string Desc = (Lector["Descripcion"].ToString());
string Foto = (Lector["Foto"].ToString());
Boolean Dest = Convert.ToBoolean(Lector["Destacado"] is DBNull ? 0 : Lector["Destacado"]);
SkateParks miSkateParks = new SkateParks(IdSKP, Nom, Foto, Desc, Dest, Ub);
ListaSkateParks.Add(miSkateParks);
}
Desconectar(Conn);
return(ListaSkateParks);
}
public static void InsertarSKP(SkateParks MiSKP)
{
SqlConnection Conn = Conectar();
SqlCommand Consulta = Conn.CreateCommand();
Consulta.CommandType = System.Data.CommandType.Text;
Consulta.CommandText = "INSERT into Skateparks(Nombre,Ubicacion,Descripcion,Foto) VALUES('" + MiSKP.Nombre + "','" + MiSKP.Ubic + "','" + MiSKP.Desc + "','" + MiSKP.Imagen + "')";
Consulta.ExecuteNonQuery();
}
public static void EliminarSKP(int idSKP)
{
SkateParks SKP = new SkateParks();
SqlConnection Conn = Conectar();
SqlCommand Consulta = Conn.CreateCommand();
Consulta.CommandType = System.Data.CommandType.Text;
Consulta.CommandText = "DELETE from Skateparks where IdSkatepark= " + idSKP + "";
Consulta.ExecuteNonQuery();
}
public static void EditarSKP(SkateParks MiSKP)
{
SqlConnection Conn = Conectar();
SqlCommand Consulta = Conn.CreateCommand();
Consulta.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE Skateparks SET ";
SQL += "Nombre = '" + MiSKP.Nombre + "', Foto='" + MiSKP.Imagen + "', " + "Descripcion= '" + MiSKP.Desc + "' WHERE IdSkatePark = " + MiSKP.IdSkatePark;
Consulta.CommandText = SQL;
Consulta.ExecuteNonQuery();
}
public static void DestacarRopa(int IdRopa)
{
SkateParks skpDestacado = new SkateParks();
SqlConnection Conn = Conectar();
SqlCommand Consulta = Conn.CreateCommand();
Consulta.CommandType = System.Data.CommandType.Text;
Consulta.CommandText = "UPDATE Ropa set Destacado = 0 where Destacado = 1";
SqlDataReader Lector = Consulta.ExecuteReader();
Lector.Close();
Consulta = Conn.CreateCommand();
Consulta.CommandType = System.Data.CommandType.Text;
Consulta.CommandText = "UPDATE Ropa set Destacado = 1 where IdRopa = " + IdRopa;
Lector = Consulta.ExecuteReader();
Desconectar(Conn);
}
