private void MtAdd_Click(object sender, EventArgs e) { aef = new AddEditForm(); aef.setFormText("Add New Item"); try{ if (aef.ShowDialog() == DialogResult.OK) { Connection c = new Connection(); DatabaseConnectionInterface dcf = c.connect(); string MaxQuery = "SELECT MAX(itemNumber) FROM warehouse"; int newItem = int.Parse(dcf.executeScalarQuery(MaxQuery)) + 1; string InsertQuery = "INSERT INTO warehouse(itemNumber,itemName,itemPrice,itemQuantity,itemPic) VALUES(" + newItem + ",\"" + aef.getItemName() + "\"," + aef.getItemPrice() + "," + aef.getItemQuantity() + ",\"" + aef.getItempic() + "\")"; dcf.executeDMQuery(InsertQuery); dcf.close(); data.Rows.Add(newItem, aef.getItemName(), aef.getItemPrice(), aef.getItemQuantity(), aef.getItempic()); data = dti.getToDataTable("SELECT * FROM warehouse"); deldata = dti.getToDataTable("SELECT itemName, itemPrice, itemQuantity FROM warehouse WHERE itemNumber NOT IN (SELECT DISTINCT itemID FROM orderitems)"); StorageGridView.DataSource = data; StorageGridView.Refresh(); } aef.Hide(); } catch (Exception ee) { return; } }
public Warehouse() { InitializeComponent(); c = new Connection(); dti = c.connect(); deletemode = false; data = dti.getToDataTable("SELECT * FROM warehouse"); deldata = dti.getToDataTable("SELECT itemName, itemPrice, itemQuantity FROM warehouse WHERE itemNumber NOT IN (SELECT DISTINCT itemID FROM orderitems)"); StorageGridView.DataSource = data; StorageGridView.Columns["itemNumber"].Visible = false; StorageGridView.Columns["itemPic"].Visible = false; StorageGridView.Columns["itemName"].Width = 297; StorageGridView.Columns["itemName"].HeaderText = "Item Name"; StorageGridView.Columns["itemPrice"].HeaderText = "Item Price"; StorageGridView.Columns["itemQuantity"].HeaderText = "Quantity"; }
public OrderForm() { InitializeComponent(); try{ c = new Connection(); dti = c.connect(); data = dti.getToDataTable("SELECT orders.orderID, orders.buyer, orders.orderDate FROM orders, orderitems, warehouse WHERE warehouse.itemNumber=orderitems.itemID AND orders.orderID=orderitems.orderID AND orders.shipped=0 GROUP BY orders.orderDate"); OrderGridView.DataSource = data; OrderGridView.Columns["orderID"].Visible = false; OrderGridView.Columns["orderDate"].Width = 270; OrderGridView.Columns["orderDate"].HeaderText = "Order Date"; OrderGridView.Columns["buyer"].HeaderText = "Buyer Name"; OrderGridView.Refresh(); } catch(Exception ee) { } }
private void mtRefresh_Click(object sender, EventArgs e) { data = dti.getToDataTable("SELECT orders.orderID, orders.buyer, orders.orderDate FROM orders, orderitems, warehouse WHERE warehouse.itemNumber=orderitems.itemID AND orders.orderID=orderitems.orderID AND orders.shipped=0 GROUP BY orders.orderDate"); OrderGridView.DataSource = data; OrderGridView.Refresh(); }