public void RemoverEquipamento(String itemcodigo, Int32 itemid) { con = new MySqlConnection(); db = new Helpers.Database(); con.ConnectionString = db.getConnectionString(); String query = "DELETE FROM inventario "; query += "WHERE itemcodigo = ?itemcodigo AND itemid = ?itemid"; try { con.Open(); MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?itemcodigo", itemcodigo); cmd.Parameters.AddWithValue("?itemid", itemid); cmd.ExecuteNonQuery(); cmd.Dispose(); } finally { con.Close(); } }
public void AtualizarEquipamento(String itemcodigo, String itemdescricao, Double itempreco, Int32 itemid) { con = new MySqlConnection(); db = new Helpers.Database(); con.ConnectionString = db.getConnectionString(); String query = "UPDATE inventario SET itemcodigo = ?itemcodigo, itemdescricao = ?itemdescricao, itempreco = ?itempreco"; query += " WHERE itemid = ?itemid"; try { con.Open(); MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?itemcodigo", itemcodigo); cmd.Parameters.AddWithValue("?itemdescricao", itemdescricao); cmd.Parameters.AddWithValue("?itempreco", itempreco); cmd.Parameters.AddWithValue("?itemid", itemid); cmd.ExecuteNonQuery(); cmd.Dispose(); } finally { con.Close(); } }
public void InserirEquipamento(String nome, Int32 numero_serie, Double preco, String data_fabricacao) { con = new MySqlConnection(); db = new Helpers.Database(); con.ConnectionString = db.getConnectionString(); String query = "INSERT INTO equipamentos (nome, numero_serie, preco, data_fabricacao) VALUES " + "(?nome, ?numero_serie, ?preco, ?data_fabricacao)"; try { con.Open(); MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("?nome", nome); cmd.Parameters.AddWithValue("?numero_serie", numero_serie); cmd.Parameters.AddWithValue("?preco", preco); cmd.Parameters.AddWithValue("?data_fabricacao", data_fabricacao); cmd.ExecuteNonQuery(); cmd.Dispose(); } finally { con.Close(); } }