/** * * @param Item $item * @return type * @throws DaoException */ public function updateItem(Item $item) { try { $query = Doctrine_Query::create()->update('Item i'); $query->set('i.name', '?', $item->getName()); $query->set('i.sales_unit_price', '?', $item->getSalesUnitPrice()); $query->set('i.purchase_unit_price', '?', $item->getPurchaseUnitPrice()); $query->set('i.description', '?', $item->getDescription()); $query->set('i.stock_available', '?', $item->getStockAvailable()); $query->where('i.id = ?', $item->getId()); return $query->execute(); } catch (Exception $e) { throw new DaoException($e->getMessage(), $e->getCode(), $e); } }