/**
  * Update transaction
  *
  * @param int $id
  * @param Transaction $transaction
  * @return bool
  */
 public function update($id, Transaction $transaction)
 {
     $this->fpdo->update($this->table, array('transaction_type_id' => $transaction->getTransactionTypeId(), 'closing_method_id' => $transaction->getClosingMethodId(), 'netAmount' => $transaction->getNetAmount(), 'grossAmount' => $transaction->getGrossAmount(), 'qty' => $transaction->getQty(), 'settleDate' => $transaction->getSettleDate(), 'accruedInterest' => $transaction->getAccruedInterest(), 'notes' => $transaction->getNotes(), 'cancelStatus' => $transaction->getCancelStatus(), 'lot_id' => $transaction->getLotId(), 'status' => $transaction->getStatus()), $id)->execute();
     return $id;
 }