private void btnEditar_Click(object sender, EventArgs e)
{
CadastroNoticia a = new CadastroNoticia();
a.setId(int.Parse(txtId.Text));
a.setTitulo(txtTitulo.Text);
a.setDescricao(txtDesc.Text);
foreach (string h in clTags.CheckedItems)
{
d.setNome(h.ToString());
consultaDao.associarTag(d, a);
}
consultaDao.atualizarNoticia(a);
listarTable();
txtId.Clear();
txtDesc.Clear();
txtTitulo.Clear();
txtAtt.Clear();
foreach (int i in clTags.CheckedIndices)
{
clTags.SetItemCheckState(i, CheckState.Unchecked);
}
}
public CadastroNoticia listarNoticia(int id)
{
conn = classeConexão.obterConexao();
if (conn.State == ConnectionState.Open)
{
SqlCommand cmd = new SqlCommand("select * from Noticia where idNoticia = @id", conn);
cmd.Parameters.AddWithValue("@id", id);
try
{
CadastroNoticia a = new CadastroNoticia();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
a.setId(id);
a.setId(int.Parse(reader[0].ToString()));
a.setTitulo(reader[1].ToString());
a.setDescricao(reader[2].ToString());
a.setData(DateTime.Parse(reader[3].ToString()));
a.setLink(reader[4].ToString());
return(a);
}
else
{
return(null);
}
}
catch (Exception error)
{
MessageBox.Show("Erro: " + error);
return(null);
}
finally
{
classeConexão.fecharConexao();
}
}
else
{
return(null);
}
}
