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