public function updateStatusAndActivationCode($registeredUserID, $emailAddress, $status, $lastName, $firstName, $middleName)
{
$activationCode = "";
$connection = $this->_connection;
$beginTrans = $connection->beginTransaction();
$sql = "UPDATE accountregisteredusers SET Status = :status, ActivationCode = :activationCode, DateActivated = NOW(6) WHERE RegisteredUserID = :registeredUserID";
$command = $connection->createCommand($sql);
$command->bindValues(array(":status" => $status, ":activationCode" => $activationCode, ":registeredUserID" => $registeredUserID));
$rowCount = $command->execute();
try {
if ($rowCount == 0) {
$status = 2;
$message = "Unable to activate your account! Please try again.";
} else {
$subject = Yii::$app->params['siteName'] . " Activation Successful";
$emailMessage = DefaultForm::emailMessageAccountActivated($lastName, $firstName, $middleName);
$sendEmail = DefaultForm::sendMail($emailAddress, $subject, $emailMessage, $lastName, $firstName, $middleName);
if ($sendEmail['status'] == DefaultForm::ERROR_CODE_NO_ERROR) {
$beginTrans->commit();
} else {
$beginTrans->rollback();
}
return array('status' => $sendEmail['status'], 'message' => $sendEmail['message']);
}
return array('status' => $status, 'message' => $message);
} catch (PDOException $e) {
$beginTrans->rollback();
return array('status' => DefaultForm::ERROR_CODE_SYSTEM_DEFAULT, 'message' => $e);
}
}
