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); }