private void OrderGridView_MouseDoubleClick(object sender, MouseEventArgs e) { try{ if (MessageBox.Show("Are you sure to delete this order?", "Delete Order", MessageBoxButtons.YesNo) == DialogResult.Yes) { Connection c = new Connection(); dti = c.connect(); int index = OrderGridView.SelectedRows[0].Index; string orderNumber = "SELECT orderID FROM orders WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\""; int orderID = int.Parse(dti.getOneField(orderNumber)); string DeleteQuery = "DELETE FROM orders WHERE orderID=" + orderID; string Deletequery = "DELETE FROM orderitems WHERE orderID="+orderID; dti.executeDMQuery(DeleteQuery); dti.close(); for (int i = 0; i < data.Rows.Count; i = i + 1) { DataRow row = data.Rows[i]; if (int.Parse(row["orderID"].ToString()) == orderID) data.Rows.Remove(row); } OrderGridView.Rows.RemoveAt(index); OrderGridView.Refresh(); } } catch(Exception ee) { } }
private void mtSend_Click(object sender, EventArgs e) { try{ if(OrderGridView.SelectedRows.Count>0){ if(MessageBox.Show("Are you sure to send out this order?", "Send Order", MessageBoxButtons.YesNo) == DialogResult.Yes) { Connection c = new Connection(); dti = c.connect(); int index = OrderGridView.SelectedRows[0].Index; string orderNumber = "SELECT orderID FROM orders WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\""; int orderID = int.Parse(dti.getOneField(orderNumber)); string sendQuery = "UPDATE orders SET shipped=1 WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\""; dti.executeDMQuery(sendQuery); for (int i = 0; i < data.Rows.Count; i = i + 1) { DataRow row = data.Rows[i]; if (int.Parse(row["orderID"].ToString()) == orderID) data.Rows.Remove(row); } OrderGridView.DataSource = data; OrderGridView.Refresh(); } } } catch(Exception ee) { } }
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(); }