コード例 #1
0
ファイル: TagsDao.cs プロジェクト: TCC-CryptoCurrency/C
        public void atualizarTag(CadastroTags a)
        {
            conn = classeConexão.obterConexao();
            if (conn.State == ConnectionState.Open)
            {
                SqlCommand cmd = new SqlCommand("UPDATE Tags SET NomeTag=@1, DescTag=@2 where idTags=@0", conn);
                cmd.Parameters.AddWithValue("@1", a.getNome());
                cmd.Parameters.AddWithValue("@2", a.getDesc());
                cmd.Parameters.AddWithValue("@0", a.getId());


                cmd.CommandType = CommandType.Text;
                //conn.Open();
                try
                {
                    int i = cmd.ExecuteNonQuery();

                    if (i > 0)
                    {
                        MessageBox.Show("Registro atualizado com sucesso!");
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Erro: " + ex.ToString());
                }
                finally
                {
                    conn.Close();
                }
            }
        }
コード例 #2
0
        public void listarTable()
        {
            for (int i = 0; i < grdUsu.RowCount; i++)
            {
                grdUsu.Rows[i].DataGridView.Rows.Clear();
            }
            // Pega os Id da tabela do banco de dados
            int count = consultaDao.quantidade();
            int aa    = 0;

            for (int i = 0; i <= count; i++)
            {
                if (!(consultaDao.listarTags(i) == null))
                {
                    CadastroTags a = consultaDao.listarTags(i);

                    grdUsu.Rows.Add();

                    grdUsu.Rows[aa].Cells[0].Value = a.getId();
                    grdUsu.Rows[aa].Cells[1].Value = a.getNome();
                    grdUsu.Rows[aa].Cells[2].Value = a.getDesc();

                    aa++;
                }
            }
        }
コード例 #3
0
ファイル: TagsDao.cs プロジェクト: TCC-CryptoCurrency/C
        public void criarTag(CadastroTags cad)
        {
            //conn = new SqlConnection(connString);
            conn = classeConexão.obterConexao();
            if (conn.State == ConnectionState.Open)
            {
                try
                {
                    // Insere na tbl Cliente
                    string     queryString = "INSERT INTO Tags (NomeTag,DescTag) VALUES (@1,@2)";
                    SqlCommand cmd         = new SqlCommand(queryString, conn);
                    cmd.Parameters.Add("@1", SqlDbType.NVarChar, 90).Value = cad.getNome();
                    cmd.Parameters.Add("@2", SqlDbType.NVarChar, 90).Value = cad.getDesc();

                    cmd.ExecuteScalar();

                    MessageBox.Show("Registro inserido com sucesso!");
                }
                catch (Exception error)
                {
                    MessageBox.Show("Erro: " + error);
                }
                finally
                {
                    classeConexão.fecharConexao();
                }
            }
        }
コード例 #4
0
        public void listarTags()
        {
            // Pega os Id da tabela do banco de dados
            int count = b.quantidade();

            for (int i = 0; i <= count; i++)
            {
                if (b.listarTags(i) != null)
                {
                    CadastroTags A = b.listarTags(i);

                    clTags.Items.Add(A.getNome());
                }
            }
        }
コード例 #5
0
        public void associarTag(CadastroTags tag)
        {
            if (conn.State == ConnectionState.Open && conn1.State == ConnectionState.Open && conn0.State == ConnectionState.Open)
            {
                try
                {
                    int[] aux = new int[2];


                    // Decobre o id da ultima noticia
                    SqlCommand    cmd = new SqlCommand("select Max(idNoticia) from Noticia", conn);
                    SqlDataReader reader;
                    reader = cmd.ExecuteReader();
                    if (reader.Read())
                    {
                        aux[0] = Convert.ToInt32(reader[0]);
                    }

                    SqlCommand cmd1 = new SqlCommand("select idTags FROM Tags WHERE NomeTag=@1", conn1);
                    cmd1.Parameters.AddWithValue("@1", tag.getNome());
                    SqlDataReader reader1 = cmd1.ExecuteReader();
                    if (reader1.Read())
                    {
                        aux[1] = Convert.ToInt32(reader1[0]);
                    }

                    SqlCommand cmd2 = new SqlCommand("INSERT INTO DetalheTagNoticia (idNoticia,idTags) VALUES (@1,@2)", conn0);
                    cmd2.Parameters.Add("@1", SqlDbType.NVarChar, 90).Value = aux[0];
                    cmd2.Parameters.Add("@2", SqlDbType.NVarChar, 90).Value = aux[1];

                    cmd2.ExecuteScalar();

                    reader.Close();
                    reader1.Close();
                    cmd.Dispose();
                    cmd1.Dispose();
                    cmd2.Dispose();
                }
                catch (Exception error)
                {
                    MessageBox.Show("Erro: " + error);
                }
                finally
                {
                    classeConexão.fecharConexao();
                }
            }
        }
コード例 #6
0
        private void btnEditar_Click(object sender, EventArgs e)
        {
            CadastroTags a = new CadastroTags();

            a.setId(int.Parse(txtId.Text));
            a.setNome(txtNome.Text);
            a.setDesc(txtDesc.Text);

            consultaDao.atualizarTag(a);

            listarTable();

            txtId.Clear();
            txtNome.Clear();
            txtDesc.Clear();
        }
コード例 #7
0
ファイル: TagsDao.cs プロジェクト: TCC-CryptoCurrency/C
        public CadastroTags listarTags(int id)
        {
            conn = classeConexão.obterConexao();
            if (conn.State == ConnectionState.Open)
            {
                SqlCommand    cmd = new SqlCommand("select * from Tags where idTags = @id", conn);
                SqlDataReader reader;
                cmd.Parameters.AddWithValue("@id", id);
                reader = cmd.ExecuteReader();

                try
                {
                    CadastroTags a = new CadastroTags();


                    if (reader.Read())
                    {
                        a.setId(int.Parse(reader[0].ToString()));
                        a.setNome(reader[1].ToString());
                        a.setDesc(reader[2].ToString());
                        return(a);
                    }
                    else
                    {
                        return(null);
                    }
                }
                catch (Exception error)
                {
                    MessageBox.Show("Erro: " + error);

                    return(null);
                }
                finally
                {
                    reader.Close();
                    cmd.Dispose();
                    classeConexão.fecharConexao();
                }
            }
            else
            {
                return(null);
            }
        }
コード例 #8
0
ファイル: NoticiaDao.cs プロジェクト: TCC-CryptoCurrency/C
        public void associarTag(CadastroTags tag, CadastroNoticia not)
        {
            conn  = classeConexão.obterConexao();
            conn1 = classeConexão.obterConexao();
            if (conn.State == ConnectionState.Open && conn1.State == ConnectionState.Open)
            {
                try
                {
                    int[] aux = new int[2];

                    // Decobre o id da ultima noticia
                    SqlCommand    cmd = new SqlCommand("select Max(idNoticia) from Noticia", conn);
                    SqlDataReader reader;
                    reader = cmd.ExecuteReader();
                    if (reader.Read())
                    {
                        aux[0] = Convert.ToInt32(reader[0]);
                    }
                    conn.Dispose();

                    conn = classeConexão.obterConexao();
                    SqlCommand cmd1 = new SqlCommand("select idTags FROM Tags WHERE NomeTag=@1", conn);
                    cmd1.Parameters.AddWithValue("@1", tag.getNome());
                    SqlDataReader reader1 = cmd1.ExecuteReader();
                    if (reader1.Read())
                    {
                        aux[1] = Convert.ToInt32(reader1[0]);
                    }
                    conn.Dispose();

                    conn = classeConexão.obterConexao();
                    SqlCommand cmd0 = new SqlCommand("select * from DetalheTagNoticia where idNoticia = @1 and idTags = @2", conn1);
                    cmd0.Parameters.AddWithValue("@1", not.getId());
                    cmd0.Parameters.AddWithValue("@2", aux[1]);
                    SqlDataReader reader0;
                    reader0 = cmd0.ExecuteReader();
                    if (reader0.Read())
                    {
                        conn = classeConexão.obterConexao();
                        cmd0 = new SqlCommand("DELETE from DetalheTagNoticia where idNoticia = @1 and idTags = @2", conn);
                        cmd0.Parameters.AddWithValue("@1", not.getId());
                        cmd0.Parameters.AddWithValue("@2", aux[1]);
                        int i = cmd0.ExecuteNonQuery();
                    }
                    conn.Dispose();
                    conn1.Dispose();

                    conn = classeConexão.obterConexao();
                    SqlCommand cmd2 = new SqlCommand("INSERT INTO DetalheTagNoticia (idNoticia,idTags) VALUES (@1,@2)", conn);
                    if (not.getId() == 0)
                    {
                        cmd2.Parameters.Add("@1", SqlDbType.NVarChar, 90).Value = aux[0];
                    }
                    else
                    {
                        cmd2.Parameters.Add("@1", SqlDbType.NVarChar, 90).Value = not.getId();
                    }
                    cmd2.Parameters.Add("@2", SqlDbType.NVarChar, 90).Value = aux[1];

                    cmd2.ExecuteScalar();

                    reader.Close();
                    reader1.Close();
                    conn.Dispose();
                }
                catch (Exception error)
                {
                    MessageBox.Show("Erro: " + error);
                }
                finally
                {
                }
            }
        }