public List<Desejo> Get()
{
using (OracleConnection conn = BaseDAO.GetConnection())
{
//Define o comando
using (OracleCommand cmd = new OracleCommand("SELECT ID_USUARIO, ID_ROTULO, ID_FABRICANTE, ID_CATEGORIA, ID_DESEJO FROM DESEJO", conn))
{
List<Desejo> lista = new List<Desejo>();
cmd.CommandType = CommandType.Text;
//Executando o select
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Desejo d = new Desejo();
d.Id_Desejo = Convert.ToInt32(reader["ID_DESEJO"]);
d.Id_Usuario = Convert.ToInt32(reader["ID_USUARIO"]);
d.Id_Rotulo = Convert.ToInt32(reader["ID_ROTULO"]);
d.Id_Fabricante = Convert.ToInt32(reader["ID_FABRICANTE"]);
lista.Add(d);
}
return lista;
}
}
}
protected void AddDesejo(object sender, EventArgs e)
{
DesejoDAO desejoDAO = new DesejoDAO();
Desejo desejo = new Desejo();
desejo.Id_Rotulo = Convert.ToInt32(RotuloDD.SelectedValue.ToString());
if (Session["IdUsuario"] != null)
desejo.Id_Usuario = Convert.ToInt32(Session["IdUsuario"].ToString());
else
desejo.Id_Usuario = 0;
}
public void Upd(Desejo u)
{
using (OracleConnection conn = BaseDAO.GetConnection())
{
//Define o comando
using (OracleCommand cmd = new OracleCommand("DESEJO_tapi.upd", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
//Define parametros
cmd.Parameters.Add("p_ID_DESEJO", u.Id_Desejo);
cmd.Parameters.Add("p_ID_USUARIO", u.Id_Usuario);
cmd.Parameters.Add("p_ID_ROTULO", u.Id_Rotulo);
cmd.Parameters.Add("p_ID_FABRICANTE", u.Id_Fabricante);
//Executa
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException 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(); }
}
}
}
}
