private void button1_Click(object sender, EventArgs e)
{
int id = 0;
label4.Text = id.ToString();
int id2 = 0;
string idUpdate = id2.ToString();
if (listView1.SelectedIndices.Count>0)
{
idUpdate = listView1.SelectedItems[0].Text;
label4.Text = idUpdate;
}
if (idUpdate != id.ToString())
{
Descricao d = new Descricao(textBox1.Text, textBox2.Text);
DescricaoBL.verificarUpdateDescricao(d, Convert.ToInt32(idUpdate));
MessageBox.Show("Dados alterados com sucesso!", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (label4.Text==id.ToString())
{
Descricao d = new Descricao(textBox1.Text, textBox2.Text);
DescricaoBL.verificarAddDescricao(d);
MessageBox.Show("Dados inseridos com sucesso!", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
textBox1.Text = "";
textBox2.Text = "";
label4.Text = "";
}
public static string verificarUpdateDescricao(Descricao desc, int idD)
{
string result = null;
try
{
result = DescricaoDA.updateDescricao(desc, idD);
}
catch (NullReferenceException n)
{
throw n;
}
catch (Exception e)
{
throw e;
}
return result;
}
public static string addDescricao(Descricao d)
{
LigacaoDB l = new LigacaoDB();
l.ligacaoBD();
SqlCommand cmmd = l.Ligacao.CreateCommand();
cmmd.Parameters.Add(new SqlParameter("@descricao", d.Descricao1));
cmmd.Parameters.Add(new SqlParameter("@observacao", d.Observacao));
cmmd.CommandText = "INSERT INTO [Teste] (descricao, observacao) VALUES (@descricao, @observacao)";
cmmd.ExecuteNonQuery();
string command = cmmd.Parameters["@descricao"].Value.ToString() + " " + cmmd.Parameters["@observacao"].Value.ToString();
l.desligarDB();
return command;
}
public static string verificarAddDescricao(Descricao desc)
{
string result = null;
try
{
result = DescricaoDA.addDescricao(desc);
}
catch (NullReferenceException n)
{
throw n;
}
catch (Exception ep)
{
throw ep;
}
return result;
}
public static string updateDescricao(Descricao desc, int idD)
{
LigacaoDB l = new LigacaoDB();
l.ligacaoBD();
SqlCommand cmmd = l.Ligacao.CreateCommand();
desc.Id = idD;
cmmd.Parameters.Add(new SqlParameter("@descricao", desc.Descricao1));
cmmd.Parameters.Add(new SqlParameter("@observacao", desc.Observacao));
cmmd.CommandText = "UPDATE Teste SET descricao= @descricao, observacao=@observacao WHERE Id = " + idD;
cmmd.ExecuteNonQuery();
string command = cmmd.Parameters["@descricao"].Value.ToString() + " " + cmmd.Parameters["@observacao"].Value.ToString();
l.desligarDB();
return command;
}
public static List<Descricao> getDescricao()
{
LigacaoDB l = new LigacaoDB();
l.ligacaoBD();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM dbo.Teste ", l.Ligacao);
DataSet ds = new DataSet();
adapter.Fill(ds, "Teste");
List<Descricao> listDescricao = new List<Descricao>();
foreach (DataRow row in ds.Tables["Teste"].Rows)
{
Descricao desc = new Descricao();
desc.Id = Convert.ToInt32(row["Id"]);
desc.Descricao1 = row["descricao"].ToString().Trim();
desc.Observacao = row["observacao"].ToString().Trim();
listDescricao.Add(desc);
}
return listDescricao;
}
private void button3_Click(object sender, EventArgs e)
{
// int id = 0;
string idUpdate = listView1.SelectedItems[0].Text;
Descricao d = new Descricao(textBox1.Text, textBox2.Text);
DescricaoBL.verificarDeleteDescricao(d, Convert.ToInt32(idUpdate));
MessageBox.Show("Dados eliminado com sucesso!", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox1.Text = "";
textBox2.Text = "";
label4.Text = "";
}
