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