/**
* Save task
* @param \Todo\Model\Task $task
* @return \Todo\Model\Task
*/
public function saveTask($task)
{
if ($task->getId() == null) {
// Task doesn't exist in database
$query = 'INSERT INTO tasks (`content`,`created_at`) VALUES (:content, :created_at)';
$content = $task->getContent();
$created_at = $task->getCreatedAt();
$stmt = $this->conn->prepare($query);
$stmt->bindParam('content', $content);
$stmt->bindParam('created_at', $created_at);
$stmt->execute();
$task->setId($this->conn->lastInsertId());
} else {
$query = 'UPDATE tasks SET content=:name WHERE id=:id';
$id = $task->getId();
$content = $task->getContent();
$stmt = $this->conn->prepare($query);
$stmt->bindParam('id', $id);
$stmt->bindParam('content', $content);
$stmt->execute();
}
return $task;
}
