public bool ModificarPersona(Consecionaria p) { bool todoOk = false; string sql = "UPDATE Consecionaria SET marca = @marca, precio = @precio, tipo = @tipo"; sql += "WHERE id = @id"; try { this.comando = new SqlCommand(); this.comando.CommandType = CommandType.Text; this.comando.Connection = this.conexion; this.comando.Parameters.AddWithValue("@id", p.ID); this.comando.Parameters.AddWithValue("@marca", p.Marca); this.comando.Parameters.AddWithValue("@precio", p.Precio); this.comando.Parameters.AddWithValue("@tipo", p.Tipo); this.comando.CommandText = sql; this.conexion.Open(); this.comando.ExecuteNonQuery(); todoOk = true; } catch (Exception) { todoOk = false; } finally { if (this.conexion.State == ConnectionState.Open) { this.conexion.Close(); } } return(todoOk); }
public bool InsertarPersona(Consecionaria p) { bool todoOk = false; string sql = "INSERT INTO Almacen (marca, precio, tipo) "; sql += "VALUES (@marca, @precio, @tipo)"; try { this.comando = new SqlCommand(); this.comando.CommandType = CommandType.Text; this.comando.Connection = this.conexion; this.comando.Parameters.AddWithValue("@marca", p.Marca); this.comando.Parameters.AddWithValue("@precio", p.Precio); this.comando.Parameters.AddWithValue("@tipo", p.Tipo); this.comando.CommandText = sql; this.conexion.Open(); this.comando.ExecuteNonQuery(); todoOk = true; } catch (Exception) { todoOk = false; } finally { if (this.conexion.State == ConnectionState.Open) { this.conexion.Close(); } } return(todoOk); }
public Consecionaria ObtenerPersonaPorID(int id) { Consecionaria p = null; try { this.comando = new SqlCommand(); this.comando.CommandType = CommandType.Text; this.comando.Connection = this.conexion; this.comando.Parameters.AddWithValue("@id", id); this.comando.CommandText = "SELECT * FROM Consecionaria WHERE id = @id"; this.conexion.Open(); SqlDataReader oDr = this.comando.ExecuteReader(); if (oDr.Read()) { p = new Consecionaria(oDr.GetInt32(0), oDr.GetString(1), oDr.GetFloat(2), oDr.GetString(3)); } oDr.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } finally { if (this.conexion.State == ConnectionState.Open) { this.conexion.Close(); } } return(p); }
public bool EliminarPersona(Consecionaria p) { bool todoOk = false; string sql = "DELETE FROM Consecionaria WHERE id = @id"; try { this.comando = new SqlCommand(); this.comando.CommandType = CommandType.Text; this.comando.Connection = this.conexion; this.comando.Parameters.AddWithValue("@id", p.ID); this.comando.CommandText = sql; this.conexion.Open(); this.comando.ExecuteNonQuery(); todoOk = true; } catch (Exception) { todoOk = false; } finally { if (this.conexion.State == ConnectionState.Open) { this.conexion.Close(); } } return(todoOk); }