/**
* @static
* @param $userId
* @param $roleId
* @return bool|Model_Entity_UserRole
*/
public static function insert($userId, $roleId)
{
$retVal = false;
if (!self::has($userId, $roleId)) {
$userRole = new Model_Entity_UserRole();
$userRole->user_id = $userId;
$userRole->role_id = $roleId;
$userRole->save();
$retVal = $userRole;
unset($userRole);
}
return $retVal;
}
public static function activate($userName, $password, $fullName, $key)
{
$retVal = false;
Doctrine_Manager::connection()->beginTransaction();
try {
$id = Doctrine_Core::getTable('Model_Entity_User')->findOneByactivationKey($key)->id;
$user = new Model_Entity_User();
$user->assignIdentifier($id);
$user->userName = $userName;
$user->fullName = $fullName;
$user->password = md5($password);
$user->activationKey = NULL;
$user->status = 'approved';
$user->active = 1;
$user->save();
$userRole = new Model_Entity_UserRole();
$userRole->role_id = 1;
$userRole->user_id = $user->id;
$userRole->save();
$retVal = Doctrine_Manager::connection()->commit() ? $user : false;
unset($userRole);
unset($id);
} catch (Zend_Exception $e) {
Doctrine_Manager::connection()->rollback();
throw $e;
} catch (Doctrine_Exception $e) {
Doctrine_Manager::connection()->rollback();
throw $e;
}
return $retVal;
}
