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 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;
}
