void showOrganizedPayments()
{
payment = new cPaymentOperations();
payment.sqlQuery = "select explanation as 'Payment Type', SUM(paymentTotal) as 'Total' from PAYMENTS inner join "
+ "PAYMENTTYPE on PAYMENTS.paymentType = PAYMENTTYPE.paymentTypeID inner join TABLES on "
+ "PAYMENTS.tableID = TABLES.tableID where date between @startTime and @finishTime group by explanation";
payment.paymentStartTime = DateTime.Now.Date;
payment.paymentFinishTime = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59);
payment.viewPayments();
dGridView.DataSource = payment.dataTable;
}
void showAllPayments()
{
payment = new cPaymentOperations();
payment.sqlQuery = "select billID as 'Bill No', rowNumber as 'Table No', paymentTotal as 'Total', Date, "
+ "explanation as 'Payment Type', paymentStatus 'Status' from PAYMENTS inner join PAYMENTTYPE "
+ "on PAYMENTS.paymentType = PAYMENTTYPE.paymentTypeID inner join TABLES on PAYMENTS.tableID = TABLES.tableID "
+ "where date between @startTime and @finishTime order by date";
payment.paymentStartTime = DateTime.Now.Date;
payment.paymentFinishTime = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59);
payment.viewPayments();
dGridView.DataSource = payment.dataTable;
}
