public static bool Alterar(Bairros bairro) { try { using (OracleCommand c = ConexaoOracle.ObterConexao().CreateCommand()) { c.CommandType = System.Data.CommandType.Text; c.CommandText = "UPDATE bairros SET nome=:nome, valor=:valor WHERE bairroid = :codigo"; c.Parameters.Add("nome", OracleType.VarChar).Value = bairro.getNome(); c.Parameters.Add("valor", OracleType.Float).Value = bairro.getValor(); c.Parameters.Add("codigo", OracleType.Int32).Value = bairro.getBairroId(); c.ExecuteNonQuery(); return true; } } catch (OracleException e) { throw e; } }
public static bool Inserir(Bairros bairro) { try { using (OracleCommand c = ConexaoOracle.ObterConexao().CreateCommand()) { c.CommandType = System.Data.CommandType.Text; c.CommandText = "INSERT INTO bairros values(BAIRROS_SEQ.NEXTVAL, :nome, :valor)"; c.Parameters.Add("nome", OracleType.VarChar).Value = bairro.getNome(); c.Parameters.Add("valor", OracleType.Float).Value = bairro.getValor(); c.ExecuteNonQuery(); return true; } } catch (OracleException e) { throw e; } }