Пример #1
0
        public static Televisor TraerUno(int codigo)
        {
            Televisor     retorno  = null;
            SqlConnection conexion = new SqlConnection(Televisor.conexion);
            SqlCommand    comando  = new SqlCommand();

            comando.CommandText = string.Format("SELECT * FROM Televisores WHERE codigo={0}", codigo);
            comando.CommandType = System.Data.CommandType.Text;
            comando.Connection  = conexion;
            try
            {
                conexion.Open();
                SqlDataReader lector = comando.ExecuteReader();
                //if(lector.HasRows)
                if (lector.Read())
                {
                    //lector.Read();
                    retorno = new Televisor(lector.GetInt32(0), lector.GetString(1), lector.GetDouble(2), lector.GetInt32(3), lector.GetString(4));
                }
                conexion.Close();
            }
            catch (Exception)
            {
            }
            return(retorno);
        }
Пример #2
0
        public static bool Borrar(Televisor t)
        {
            bool          retorno  = false;
            SqlConnection conexion = new SqlConnection(Televisor.conexion);
            SqlCommand    comando  = new SqlCommand();

            comando.CommandText = string.Format("DELETE FROM Televisores WHERE codigo={0}", t.codigo);
            comando.CommandType = System.Data.CommandType.Text;
            comando.Connection  = conexion;
            try
            {
                conexion.Open();
                comando.ExecuteNonQuery();
                conexion.Close();
                retorno = true;
            }
            catch (Exception)
            {
            }
            return(retorno);
        }
Пример #3
0
        public static bool Modificar(Televisor t)
        {
            bool          retorno  = false;
            SqlConnection conexion = new SqlConnection(Televisor.conexion);
            SqlCommand    comando  = new SqlCommand();

            comando.CommandText = string.Format("UPDATE Televisores SET marca='{0}',precio={1},pulgadas={2},pais='{3}' WHERE codigo={4}", t.marca, t.precio, t.pulgadas, t.pais, t.codigo);
            comando.CommandType = System.Data.CommandType.Text;
            comando.Connection  = conexion;
            try
            {
                conexion.Open();
                comando.ExecuteNonQuery();
                conexion.Close();
                retorno = true;
            }
            catch (Exception)
            {
            }
            return(retorno);
        }