public static bool Modificar(Televisor tele) { SqlConnection conexion = new SqlConnection(Properties.Settings.Default.conexion); SqlCommand comando = new SqlCommand(); comando.CommandType = CommandType.Text; comando.CommandText = "UPDATE dbo.Televisores SET marca='" + tele.marca + "', precio=" + tele.precio + ",pulgadas=" + tele.pulgadas + "," + "pais='" + tele.pais + "' WHERE codigo=" + tele.id + ""; comando.Connection = conexion; try { conexion.Open(); comando.ExecuteNonQuery(); conexion.Close(); return(true); } catch (Exception) { return(false); throw; } }
public static Televisor TraerUno(int id) { Televisor t = null; SqlConnection conexion = new SqlConnection(Properties.Settings.Default.conexion); conexion.Open(); SqlCommand comando = new SqlCommand(); comando.CommandType = CommandType.Text; comando.CommandText = "SELECT * FROM dbo.Televisores WHERE codigo=" + id + ""; comando.Connection = conexion; SqlDataReader reader = comando.ExecuteReader(); //if (reader.HasRows) //{ // t = new Televisor(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2), reader.GetInt32(3), reader.GetString(4)); //} while (reader.Read()) { t = new Televisor(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2), reader.GetInt32(3), reader.GetString(4)); } return(t); }
public static List <Televisor> TraerTodos() { List <Televisor> televisores = new List <Televisor>(); SqlConnection conexion = new SqlConnection(Properties.Settings.Default.conexion); conexion.Open(); SqlCommand comando = new SqlCommand(); comando.CommandType = CommandType.Text; comando.CommandText = "SELECT * FROM dbo.Televisores"; comando.Connection = conexion; SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { Televisor t = new Televisor(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2), reader.GetInt32(3), reader.GetString(4)); televisores.Add(t); } return(televisores); }
public static Televisor TraerUno(int id) { Televisor retorno = null; SqlConnection connection = new SqlConnection(Properties.Settings.Default.Conexion); SqlCommand command = new SqlCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = String.Format("SELECT * FROM Televisores WHERE codigo = {0}", id); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { reader.Read(); retorno = new Televisor(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2), reader.GetInt32(3), reader.GetString(4)); } connection.Close(); return(retorno); }
public static List <Televisor> TraerTodos() { List <Televisor> lista = new List <Televisor>(); SqlConnection connection = new SqlConnection(Properties.Settings.Default.Conexion); SqlCommand command = new SqlCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = "SELECT * FROM TELEVISORES"; command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Televisor televisor = new Televisor(reader.GetInt32(0), reader.GetString(1), reader.GetDouble(2), reader.GetInt32(3), reader.GetString(4)); lista.Add(televisor); } connection.Close(); return(lista); }
public static bool Borrar(Televisor televisor) { bool retorno = true; SqlConnection connection = new SqlConnection(Properties.Settings.Default.Conexion); SqlCommand command = new SqlCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = String.Format("DELETE Televisores WHERE codigo = {0}", televisor.id); command.Connection = connection; try { connection.Open(); command.ExecuteNonQuery(); connection.Close(); } catch (Exception) { retorno = false; } return(retorno); }
public static bool Modificar(Televisor televisor) { bool retorno = true; SqlConnection connection = new SqlConnection(Properties.Settings.Default.Conexion); SqlCommand command = new SqlCommand(); command.CommandType = System.Data.CommandType.Text; command.CommandText = String.Format("UPDATE Televisores SET marca = '{0}', precio = {1}, pulgadas = {2}, pais = '{3}' WHERE codigo = {4}", televisor.marca, televisor.precio, televisor.pulgadas, televisor.pais, televisor.id); command.Connection = connection; try { connection.Open(); command.ExecuteNonQuery(); connection.Close(); } catch (Exception e) { retorno = false; } return(retorno); }
public static bool Borrar(Televisor tele) { SqlConnection conexion = new SqlConnection(Properties.Settings.Default.conexion); SqlCommand comando = new SqlCommand(); comando.CommandType = CommandType.Text; comando.CommandText = "DELETE dbo.Televisores WHERE codigo=" + tele.id + ""; comando.Connection = conexion; try { conexion.Open(); comando.ExecuteNonQuery(); conexion.Close(); return(true); } catch (Exception) { return(false); throw; } }