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