/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param ConnectionInterface $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(ConnectionInterface $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aUser !== null) {
if ($this->aUser->isModified() || $this->aUser->isNew()) {
$affectedRows += $this->aUser->save($con);
}
$this->setUser($this->aUser);
}
if ($this->aNote !== null) {
if ($this->aNote->isModified() || $this->aNote->isNew()) {
$affectedRows += $this->aNote->save($con);
}
$this->setNote($this->aNote);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
$affectedRows += 1;
} else {
$affectedRows += $this->doUpdate($con);
}
$this->resetModified();
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
protected function create()
{
$params = $this->getAllowedKeysForCreate();
$note = new Note();
$note->fromArray($params);
$category = $_POST['category'];
$category = CategoryQuery::create()->filterByUser($this->params['user'])->filterByName($category)->findOne();
if ($category != null) {
$note->setCategory($category);
}
$note->setUser($this->params['user']);
$note->save();
$this->addFlash("success", "Note added");
redirectTo($note->getShowPath());
}
