public void Upd(Categoria u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("CATEGORIA_tapi.upd", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_CATEGORIA", u.Id_Categoria); cmd.Parameters.Add("p_ID_CATEGORIA_MAE", u.Id_Categoria_Mae); cmd.Parameters.Add("p_NOME", u.Nome); //Executa try { conn.Open(); cmd.ExecuteNonQuery(); } catch (OracleException ex) { throw new Exception("Ocorreu o erro(BD): " + ex.Message); } catch (Exception ex) { throw new Exception("Erro: " + ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } } }
public List<Categoria> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT C.ID_CATEGORIA, C.NOME, C.ID_CATEGORIA_MAE, CMAE.NOME FROM CATEGORIA C" +"JOIN CATEGORIA CMAE ON C.ID_CATEGORIA = CMAE.ID_CATEGORIA", conn)) { List<Categoria> lista = new List<Categoria>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Categoria c = new Categoria(); c.Id_Categoria = Convert.ToInt32(reader["ID_CATEGORIA"]); c.Nome = Convert.ToString(reader["NOME"]); c.Id_Categoria_Mae = Convert.ToInt32(reader["ID_CATEGORIA_MAE"]); //c.NomeMae = Convert.ToString(reader["NOME"]); ? lista.Add(c); } return lista; } } }