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