void showTablesOrders() { ordersOfTable = new cGetOrdersOfTable(); ordersOfTable.sqlQuery = "select productName as 'Product', SUM(Quantity) as 'Quantity' from ORDERS inner join " + "PRODUCTS on PRODUCTS.productID = ORDERS.productID where tableID = @tableId and billId = @billId group by productName"; ordersOfTable.tableId = dGridView.CurrentRow.Cells["Table No"].Value.ToString(); ordersOfTable.billId = Convert.ToInt32(dGridView.CurrentRow.Cells["Bill No"].Value); ordersOfTable.GetOrdersFromSql(); fillLViewOrders(); }
void loadTableOrders(string tableId) { getTableOrders = new cGetOrdersOfTable(); getTableOrders.sqlQuery = "select orderID, productName as 'Product', Quantity, tableID as 'Table', orderStatus as 'Is Delivered', " + "staffNameSurname as 'Staff' from ORDERS inner join STAFFS on STAFFS.staffID = ORDERS.staffID " + "inner join PRODUCTS on PRODUCTS.productID = ORDERS.productID where tableID = @tableId and billId = @billId"; getTableOrders.tableId = tableId; getTableOrders.billId = billId; getTableOrders.GetOrdersFromSql(); dGridView.DataSource = getTableOrders.dataTable; dGridView.Columns["orderId"].Visible = false; writeTableNumber(); }
private void btnPendingOrders_Click(object sender, EventArgs e) { LViewUndelivered.Items.Clear(); LViewUndelivered.Visible = true; getTableOrders = new cGetOrdersOfTable(); getTableOrders.sqlQuery = "select orderID, productName, case when orderStatus = 0 then 'Undelivered' else 'Delivered' end " + "as 'orderStatus', case when preparationStatus is NULL then 'New Order' when preparationStatus = 0 then 'Preparing' " + "else 'Ready' end as 'preparationStatus' from ORDERS inner join PRODUCTS on ORDERS.productID = PRODUCTS.productID " + "where orderStatus = 0 and tableID = @tableId and billId = @billId"; getTableOrders.tableId = PBoxClicked.Tag.ToString(); getTableOrders.billId = billId; getTableOrders.GetOrdersFromSql(); LViewUndelivered.View = View.Details; showUndeliveredOrders(); }