public void inserirPatrimonio(Patrimonio patrimonio)
{
try
{
SqlCommand cmmd = new SqlCommand();
cmmd.CommandText = "INSERT INTO Patrimonio (NOME, DESCRICAO, CODIGO_MARCA) VALUES ('" + patrimonio.nome + "'," +
"'" + patrimonio.descricao + "','" + patrimonio.marca.codigo + "')";
cmmd.Connection = con.conexao;
con.conexao.Open();
cmmd.ExecuteNonQuery();
}
catch (Exception E)
{
}
finally
{
con.conexao.Close();
}
}
public void atualizarPatrimonio(Patrimonio patrimonio)
{
try
{
SqlCommand cmmd = new SqlCommand();
cmmd.CommandText = "UPDATE PATRIMONIO" +
" SET NOME = '" + patrimonio.nome + "'," +
" DESCRICAO = '" + patrimonio.descricao + "'," +
" CODIGO_MARCA = " + patrimonio.codigo + " " +
" WHERE CODIGO = ('" + patrimonio.codigo + "')";
cmmd.Connection = con.conexao;
con.conexao.Open();
cmmd.ExecuteNonQuery();
}
catch (Exception E)
{
}
finally
{
con.conexao.Close();
}
}
