public void RemoverDados(String itemcodigo, Int32 itemid)
{
con = new MySqlConnection();
db = new Helpers.dbs();
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 InserirDados(String itemcodigo, String itemdescricao, Double itempreco)
{
con = new MySqlConnection();
db = new Helpers.dbs();
con.ConnectionString = db.getConnectionString();
String query = "INSERT INTO inventario (itemcodigo, itemdescricao, itempreco) VALUES";
query += "(?itemcodigo, ?itemdescricao, ?itempreco)";
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.ExecuteNonQuery();
cmd.Dispose();
}
finally
{
con.Close();
}
}
public void AtualizarDados(String itemcodigo, String itemdescricao, Double itempreco, Int32 itemid)
{
con = new MySqlConnection();
db = new Helpers.dbs();
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();
}
}