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();
}
