void showDeliveredOrders() { showOrder = new cOrderOperations(); showOrder.sqlQuery = "select staffNameSurname as 'Staff', productName as 'Product', ORDERS.tableID as 'Table No', " + "ORDERS.billID as 'Bill No', Quantity, openingTime as 'Bill Time' from ORDERS inner join STAFFS on " + "ORDERS.staffID = STAFFS.staffID inner join PRODUCTS on ORDERS.productID = PRODUCTS.productID " + "inner join BILLS on ORDERS.billID = BILLS.billID where orderStatus = 1 and openingTime between @startTime and @finishTime"; showOrder.billStartTime = DateTime.Now.Date; showOrder.billFinishTime = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); showOrder.getDataFromOrders(); dGridView.DataSource = showOrder.dataTable; }
void showNewOrders() { showOrder = new cOrderOperations(); showOrder.sqlQuery = "select orderID, staffNameSurname as 'Staff', productName as 'Product', ORDERS.tableID as 'Table No', Quantity, " + "case when orderStatus = 1 then 'Delivered' else 'Undelivered' end as 'Delivery Status', " + "case when preparationStatus is null then 'New Order' when preparationStatus = 1 then 'Ready' else 'Preparing' end as 'Preparation Status', " + "billID from ORDERS inner join STAFFS on ORDERS.staffID = STAFFS.staffID inner join " + "PRODUCTS on ORDERS.productID = PRODUCTS.productID where orderStatus = 0 and preparationStatus is NULL"; showOrder.showNewOrders(); dGridView.DataSource = showOrder.dataTable; hideDGridViewColumns(); }
void showReadyOrders() { showOrder = new cOrderOperations(); showOrder.sqlQuery = "select orderID, staffNameSurname as 'Staff', productName as 'Product', Quantity, " + "case when preparationStatus is NULL then 'New Order' when preparationStatus = 1 then 'Ready' else 'Preparing' end " + "as 'Preparation Status', ORDERS.tableID as 'Table No', ORDERS.billID from ORDERS inner join STAFFS on ORDERS.staffID = STAFFS.staffID " + "inner join PRODUCTS on ORDERS.productID = PRODUCTS.productID inner join BILLS on ORDERS.billID = BILLS.billID " + "where orderStatus = 0 and preparationStatus = 1 and openingTime between @startTime and @finishTime"; showOrder.billStartTime = DateTime.Now.Date; showOrder.billFinishTime = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); showOrder.getDataFromOrders(); dGridView.DataSource = showOrder.dataTable; hideDGridViewColumns(); }