/**
* This method collects payment for the current transaction.
*
* @param amount the amount of money collected from the customer.
* @param payment no idea what this is (TODO: ask about class diagram)
* @return no idea what this is suppose to return.
* @throws SQLException if sql error.
* @throws ClassNotFoundException if sql error.
* @throws IllegalStateException if there are no items on the invoice.
*/
public double pay(String paymentMethod, int amount)
throws IllegalStateException, SQLException, ClassNotFoundException, Exception {
if (myTransaction.getNumberOfItems() == 0) {
throw new IllegalStateException("There are no items on the Invoice.");
}
JDBCConnection JDBC = new JDBCConnection();
Statement st = JDBC.createStatement();
String table = "invoice";
String column = "invoiceID";
String SQL = "SELECT " + column + " FROM " + table + " GROUP BY " + column;
ResultSet rs = st.executeQuery(SQL);
// rs.last();
int nextInvoiceID = 0;
if (rs.last()) {
int LastID = rs.getInt(column);
nextInvoiceID = LastID + 1;
}
// use these two lines if you want invoices to be numbered 1000 and up
// int starting = 999;
// int nextInvoiceID = mySQLhelper.getTotalNumberOfInvoices() + 1;
// int nextInvoiceID = mySQLhelper.getTotalNumberOfRows(SQLhelper.TRANSACTION_TABLE_NAME,
// SQLhelper.TRANSACTION_TABLE_PK) + 1;
// Payment myPayment = new Payment(amount, paymentMethod);
double change = myTransaction.markPaid(paymentMethod, amount, nextInvoiceID);
myTransaction.UpdateItem();
process();
return change;
}
public Vector<Vector<String>> getReceiptInfo() {
Vector<Vector<String>> receipt = new Vector<Vector<String>>();
for (int i = 0; i < myTransaction.getNumberOfItems(); i++) {
Vector<String> temp = new Vector<String>();
temp.add(myTransaction.getItemBarcode(i));
temp.add(myTransaction.getItemName(i));
temp.add("$ " + Integer.toString(myTransaction.getItemPrice(i) / 100));
receipt.add(temp);
}
return receipt;
}
/**
* This removes a item from the current transaction.
*
* @param barcode the item's barcode number.
* @throws IllegalStateException if there are no items on the invoice to remove.
*/
public void removeItem(String barcode) throws IllegalStateException {
int itemCount = myTransaction.getNumberOfItems();
if (itemCount == 0) {
throw new IllegalStateException("There are no items on the Invoice.");
}
// compare each item that is currently on the invoice with the barcode given
boolean found = false;
int line = 1; // the line in the invoice where this item is, start looking on line 1.
for (line = 1; line <= itemCount; line++) {
TransactionItem itemOnInvoice = myTransaction.getItem(line);
if (itemOnInvoice.getBarcode() == barcode) {
found = true;
break;
}
}
if (!found) throw new IllegalStateException("Item not in list");
else myTransaction.removeTransactionItem(line);
}
/**
* This adds/saves the current transaction to the database.
*
* @throws IllegalStateException if the transaction has not been paid for.
* <dt><b>Precondition:</b>
* <dd>
* <ul>
* <li>Payment for the transaction has been made.
* </ul>
*/
public void process()
throws IllegalStateException, SQLException, ClassNotFoundException, MovieNotFoundException,
Exception {
if (myTransaction.isPaid() == false) {
throw new IllegalStateException("The invoice has not been paid, not saving info.");
}
// mySQLhelper.insertInvoiceTable(myTransaction);
RentalMovieManagement rentalManager = new RentalMovieManagement();
SaleMovieManagement saleManager = new SaleMovieManagement();
for (int i = 1; i <= myTransaction.getNumberOfItems(); i++) {
TransactionItem item = myTransaction.getItem(i);
if (item.getType().equals("for sale")) {
saleManager.sell(item.getBarcode());
} else if (item.getType().trim().toLowerCase().equals("new release")
|| item.getType().trim().toLowerCase().equals("7 day")) {
rentalManager.checkOut(
myTransaction.getCustomerID(), item.getBarcode(), new JDBCConnection());
}
}
}