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