public function save(UserDto $user) { if ($user->id > 0) { $sql[] = "UPDATE user"; } else { $sql[] = "INSERT INTO user"; } $sql[] = " SET name = :name,"; $sql[] = " login = :login,"; $sql[] = " password = :password,"; $sql[] = " email = :email"; if ($user->id == 0) { $sql[] = " , date_creation = :date_creation"; $params[':date_creation'] = time(); } else { $sql[] = "WHERE id=:id"; $params[':id'] = $user->id; } $params[':name'] = $user->userName; $params[':login'] = $user->login; $params[':password'] = $user->password; $params[':email'] = $user->email; $result = $this->daoTemplate->queryForUpdate(implode("\n", $sql), $params); if ($user->id == 0) { $user->id = $this->daoTemplate->getLastInsertId(); } return $result; }
public function save(RoleDto $role) { if ($role->id > 0) { $sql[] = "UPDATE role"; } else { $sql[] = "INSERT INTO role"; } $sql[] = " SET title=:title,"; $sql[] = " description=:description"; if ($role->id > 0) { $sql[] = "WHERE id=:id"; $params[':id'] = $role->id; } $params[':title'] = $role->title; $params[':description'] = $role->description; $result = $this->daoTemplate->queryForUpdate(implode("\n", $sql), $params); if ($role->id == 0) { $role->id = $this->daoTemplate->getLastInsertId(); } $this->saveRightForIdRole($role->id, $role->listRight); return $result; }
public function save($cat) { if ($cat->id > 0) { $sql[] = "UPDATE category"; } else { $sql[] = "INSERT INTO category"; } $sql[] = " SET title = :title,"; $sql[] = " description = :description"; if ($cat->id > 0) { $sql[] = "WHERE id=:id"; $params[':id'] = $cat->id; } $params[':title'] = $cat->title; $params[':description'] = $cat->description; $result = $this->daoTemplate->queryForUpdate(implode("\n", $sql), $params); if ($cat->id == 0) { $cat->id = $this->daoTemplate->getLastInsertId(); } return $result; }