public void criarNoticia(CadastroNoticia cad) { //conn = new SqlConnection(connString); conn = classeConexão.obterConexao(); if (conn.State == ConnectionState.Open) { try { // Insere na tbl Cliente string queryString = "INSERT INTO Noticia (Titulo,DescNot,DataNot,LinkNot) VALUES (@1,@2,@3,@4)"; SqlCommand cmd = new SqlCommand(queryString, conn); cmd.Parameters.Add("@1", SqlDbType.NVarChar, 90).Value = cad.getTitulo(); cmd.Parameters.Add("@2", SqlDbType.NVarChar, 90).Value = cad.getDescricao(); cmd.Parameters.Add("@3", SqlDbType.Date, 90).Value = DateTime.Now; cmd.Parameters.Add("@4", SqlDbType.NVarChar, 90).Value = cad.getLink(); cmd.ExecuteScalar(); } catch (Exception error) { MessageBox.Show("Erro: " + error); } finally { classeConexão.fecharConexao(); } } }
public void atualizarNoticia(CadastroNoticia a) { conn = classeConexão.obterConexao(); if (conn.State == ConnectionState.Open) { SqlCommand cmd = new SqlCommand("UPDATE Noticia SET Titulo=@1, DescNot=@2, DataNot=@3, LinkNot=@4 where idNoticia=@0", conn); cmd.Parameters.AddWithValue("@1", a.getTitulo()); cmd.Parameters.AddWithValue("@2", a.getDescricao()); cmd.Parameters.AddWithValue("@3", DateTime.Now); cmd.Parameters.AddWithValue("@4", a.getLink()); 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(); } } }