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