private void btnInventory_Click(object sender, EventArgs e) { var inventory = new InventoryDetails(); inventory.Show(); Hide(); }
private void btnReorder_Click(object sender, EventArgs e) { int newStock = InventoryDetails.setstockonhand + Convert.ToInt32(txtReorder.Text); try { Connection.Connection.DB(); Functions.Function.gen = "UPDATE product SET stockonhand = '" + newStock + "' WHERE productid = '" + InventoryDetails.setproductid + "' ; UPDATE product SET reorderstock = '" + txtReorder.Text + "' WHERE productid = '" + InventoryDetails.setproductid + "' "; Functions.Function.command = new SqlCommand(Functions.Function.gen, Connection.Connection.con); Functions.Function.command.ExecuteNonQuery(); MessageBox.Show("Saved.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); Connection.Connection.con.Close(); var inventory = new InventoryDetails(); inventory.Show(); Hide(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }