public List <Troca> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_TROCA, ID_USUARIO_SOLICITANTE, ID_USUARIO_DETENTOR, DATA_INCLUSAO, DATA_SITUACAO," + "SITUACAO, POSICAO_SOLICITANTE, POSICAO_DETENTOR FROM TROCA", conn)) { List <Troca> lista = new List <Troca>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Troca t = new Troca(); t.Id_Troca = Convert.ToInt32(reader["ID_TROCA"]); t.Id_Usuario_Solicitante = Convert.ToInt32(reader["ID_USUARIO_SOLICITANTE"]); t.Id_Usuario_Detentor = Convert.ToInt32(reader["ID_USUARIO_DETENTOR"]); t.Data_Inclusao = Convert.ToDateTime(reader["DATA_INCLUSAO"]); t.Data_Situacao = Convert.ToDateTime(reader["DATA_SITUACAO"]); t.Situacao = Convert.ToInt32(reader["SITUACAO"]); t.Posicao_Solicitante = Convert.ToInt32(reader["POSICAO_SOLICITANTE"]); t.Posicao_Detentor = Convert.ToInt32(reader["POSICAO_DETENTOR"]); lista.Add(t); } return(lista); } } }
public List <Usuario> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_USUARIO, NOME, SENHA, DATA_NASCIMENTO, EMAIL, FOTO, FACEBOOK FROM USUARIO", conn)) { List <Usuario> lista = new List <Usuario>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Usuario u = new Usuario(); u.Id_Usuario = Convert.ToInt32(reader["ID_USUARIO"]); u.Nome = Convert.ToString(reader["NOME"]); u.Senha = Convert.ToString(reader["SENHA"]); u.DataNascimento = Convert.ToDateTime(reader["DATA_NASCIMENTO"]); u.Email = Convert.ToString(reader["EMAIL"]); u.Foto = Convert.ToString(reader["FOTO"]); u.Facebook = Convert.ToString(reader["FACEBOOK"]); lista.Add(u); } return(lista); } } }
public List <Produto> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_PRODUTO, ID_USUARIO, ID_ROTULO, DESCRICAO, DATA_INCLUSAO, SITUACAO, DATA_SITUACAO," + "FL_ROUPA, DEFAULT_IMAGEM FROM PRODUTO", conn)) { List <Produto> lista = new List <Produto>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Produto p = new Produto(); p.Id_Produto = Convert.ToInt32(reader["ID_PRODUTO"]); p.Id_Usuario = Convert.ToInt32(reader["ID_USUARIO"]); p.Id_Rotulo = Convert.ToInt32(reader["ID_ROTULO"]); p.Descricao = Convert.ToString(reader["DESCRICAO"]); p.Data_Inclusao = Convert.ToDateTime(reader["DATA_INCLUSAO"]); p.Situacao = Convert.ToInt32(reader["SITUACAO"]); p.Data_Situacao = Convert.ToDateTime(reader["DATA_SITUACAO"]); p.Fl_Roupa = Convert.ToChar(reader["FL_ROUPA"]); p.Imagem = Convert.ToString(reader["IMAGEM"]); lista.Add(p); } return(lista); } } }
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); } } }
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); } } }
public List <Rotulo> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_ROTULO, ID_FABRICANTE, ID_CATEGORIA, NOME, FL_TIPO_ROTULO FROM ROTULO", conn)) { List <Rotulo> lista = new List <Rotulo>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Rotulo r = new Rotulo(); r.Id_Rotulo = Convert.ToInt32(reader["ID_ROTULO"]); r.Id_Fabricante = Convert.ToInt32(reader["ID_FABRICANTE"]); r.Id_Categoria = Convert.ToInt32(reader["ID_CATEGORIA"]); r.Nome = Convert.ToString(reader["NOME"]); r.Fl_Tipo_Rotulo = Convert.ToChar(reader["FL_TIPO_ROTULO"]); lista.Add(r); } return(lista); } } }
public List <Jogo> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_JOGO, NOME FROM JOGO", conn)) { List <Jogo> lista = new List <Jogo>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Jogo j = new Jogo(); j.Id_Rotulo = Convert.ToInt32(reader["ID_ROTULO"]); j.Marca = Convert.ToString(reader["MARCA"]); j.Recursos = Convert.ToString(reader["RECURSOS"]); j.Faixa_Etaria = Convert.ToString(reader["FAIXA_ETARIA"]); j.Id_Plataforma = Convert.ToInt32(reader["ID_PLATAFORMA"]); j.Id_Genero = Convert.ToInt32(reader["ID_GENERO"]); lista.Add(j); } return(lista); } } }
public void Upd(Produto u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("PRODUTO_tapi.upd", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_PRODUTO", u.Id_Produto); cmd.Parameters.Add("p_ID_USUARIO", u.Id_Usuario); cmd.Parameters.Add("p_ID_ROTULO", u.Id_Rotulo); cmd.Parameters.Add("p_DESCRICAO", u.Descricao); cmd.Parameters.Add("p_DATA_INCLUSAO", u.Data_Inclusao); cmd.Parameters.Add("p_SITUACAO", u.Situacao); cmd.Parameters.Add("p_DATA_SITUACAO", u.Data_Situacao); cmd.Parameters.Add("p_FL_ROUPA", u.Fl_Roupa); cmd.Parameters.Add("p_IMAGEM", u.Imagem); //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 void Ins(Usuario u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando //using (OracleCommand cmd = new OracleCommand("USUARIO_tapi.ins", conn)) using (OracleCommand cmd = new OracleCommand("INSERT INTO USUARIO VALUES (p_ID_USUARIO, p_NOME, p_SENHA, p_DATA_NASCIMENTO, p_EMAIL, p_FOTO, p_FACEBOOK)", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_USUARIO", u.Id_Usuario); cmd.Parameters.Add("p_NOME", u.Nome); cmd.Parameters.Add("p_SENHA", u.Senha); cmd.Parameters.Add("p_DATA_NASCIMENTO", u.DataNascimento); cmd.Parameters.Add("p_EMAIL", u.Email); cmd.Parameters.Add("p_FOTO", u.Foto); cmd.Parameters.Add("p_FACEBOOK", u.Facebook); //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 void Upd(Troca u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("TROCA_tapi.upd", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_TROCA", u.Id_Troca); cmd.Parameters.Add("p_ID_USUARIO_SOLICITANTE", u.Id_Usuario_Solicitante); cmd.Parameters.Add("p_ID_USUARIO_DETENTOR", u.Id_Usuario_Detentor); cmd.Parameters.Add("p_DATA_INCLUSAO", u.Data_Inclusao); cmd.Parameters.Add("p_DATA_SITUACAO", u.Data_Situacao); cmd.Parameters.Add("p_SITUACAO", u.Situacao); cmd.Parameters.Add("p_POSICAO_SOLICITANTE", u.Posicao_Solicitante); cmd.Parameters.Add("p_POSICAO_DETENTOR", u.Posicao_Detentor); //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 void Upd(Jogo u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("JOGO_tapi.upd", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_ROTULO", u.Id_Rotulo); cmd.Parameters.Add("p_MARCA", u.Marca); cmd.Parameters.Add("p_RECURSOS", u.Recursos); cmd.Parameters.Add("p_FAIXA_ETARIA", u.Faixa_Etaria); cmd.Parameters.Add("p_ID_PLATAFORMA", u.Id_Plataforma); cmd.Parameters.Add("p_ID_GENERO", u.Id_Genero); //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(); } } } } }
public void Upd(Rotulo u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("ROTULO_tapi.upd", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_ROTULO", u.Id_Rotulo); cmd.Parameters.Add("p_ID_FABRICANTE", u.Id_Fabricante); cmd.Parameters.Add("p_ID_CATEGORIA", u.Id_Categoria); cmd.Parameters.Add("p_NOME", u.Nome); cmd.Parameters.Add("p_FL_TIPO_ROTULO", u.Fl_Tipo_Rotulo); //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 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(); } } } } }
public void Ins(Categoria u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("CATEGORIA_tapi.ins", 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 void Upd(Editora u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("EDITORA_tapi.upd", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_EDITORA", u.Id_Editora); cmd.Parameters.Add("p_NOME", u.Nome); //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(); } } } } }
public void Del(Fabricante u) { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("FABRICANTE_tapi.del", conn)) { cmd.CommandType = CommandType.StoredProcedure; //Define parametros cmd.Parameters.Add("p_ID_FABRICANTE", u.Id_Fabricante); //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 <Assunto> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_ASSUNTO, NOME FROM ASSUNTO", conn)) { List <Assunto> lista = new List <Assunto>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Assunto a = new Assunto(); a.Id_Assunto = Convert.ToInt32(reader["ID_ASSUNTO"]); a.Nome = Convert.ToString(reader["NOME"]); lista.Add(a); } return(lista); } } }
public List <Plataforma> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_PLATAFORMA, NOME FROM PLATAFORMA", conn)) { List <Plataforma> lista = new List <Plataforma>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Plataforma p = new Plataforma(); p.Id_Plataforma = Convert.ToInt32(reader["ID_PLATAFORMA"]); p.Nome = Convert.ToString(reader["NOME"]); lista.Add(p); } return(lista); } } }
public List <Editora> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_EDITORA, NOME FROM EDITORA", conn)) { List <Editora> lista = new List <Editora>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Editora e = new Editora(); e.Id_Editora = Convert.ToInt32(reader["ID_EDITORA"]); e.Nome = Convert.ToString(reader["NOME"]); lista.Add(e); } return(lista); } } }
public List <Idioma> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_IDIOMA, NOME FROM IDIOMA", conn)) { List <Idioma> lista = new List <Idioma>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Idioma i = new Idioma(); i.Id_Idioma = Convert.ToInt32(reader["ID_IDIOMA"]); i.Nome = Convert.ToString(reader["NOME"]); lista.Add(i); } return(lista); } } }
public List <Fabricante> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_FABRICANTE, NOME FROM FABRICANTE", conn)) { List <Fabricante> lista = new List <Fabricante>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Fabricante f = new Fabricante(); f.Id_Fabricante = Convert.ToInt32(reader["ID_FABRICANTE"]); f.Nome = Convert.ToString(reader["NOME"]); lista.Add(f); } return(lista); } } }
public List <Genero> Get() { using (OracleConnection conn = BaseDAO.GetConnection()) { //Define o comando using (OracleCommand cmd = new OracleCommand("SELECT ID_GENERO, NOME FROM GENERO", conn)) { List <Genero> lista = new List <Genero>(); cmd.CommandType = CommandType.Text; //Executando o select OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Genero g = new Genero(); g.Id_Genero = Convert.ToInt32(reader["ID_GENERO"]); g.Nome = Convert.ToString(reader["NOME"]); lista.Add(g); } return(lista); } } }