예제 #1
0
        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;
                }
            }
        }
예제 #2
0
        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(); }
                    }
                }
            }
        }
예제 #3
0
        public void Del(Jogo u)
        {
            using (OracleConnection conn = BaseDAO.GetConnection())
            {
                //Define o comando
                using (OracleCommand cmd = new OracleCommand("JOGO_tapi.del", conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;

                    //Define parametros
                    cmd.Parameters.Add("p_ID_JOGO", u.Id_Rotulo);
                    
                    //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(); }
                    }
                }
            }
        }