void createNewPayment()
{
newPayment = new cPaymentOperations();
newPayment.sqlQuery = "insert into PAYMENTS (billID, tableID, paymentTotal, paymentStatus) "
+ "values(@billId, @tableId, 0, 0)";
newPayment.billId = billId;
newPayment.tableId = Convert.ToInt32(PBoxClicked.Tag);
newPayment.addNewPayment();
}
void executePayment()
{
payment = new cPaymentOperations();
payment.sqlQuery = "update PAYMENTS set paymentTotal = @total, date = @payTime, paymentType = @pType, "
+ "paymentStatus = 1 where billID = @billId and tableID = @tableId";
payment.billId = Convert.ToInt32(dGridView.CurrentRow.Cells["Bill No"].Value);
payment.tableId = Convert.ToInt32(dGridView.CurrentRow.Cells["tableID"].Value);
payment.total = Convert.ToInt32(dGridView.CurrentRow.Cells["Total"].Value);
payment.paymentTime = DateTime.Now;
payment.paymentType = (CBoxPType.SelectedIndex) + 1;
payment.closePayment();
}
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;
}
