/**
* Adds student as member of team.
*
* @param Entity\AdministratorImpl $student
* @param Entity\TeamImpl $team
* @throws RDException
*/
public function storeStudentMemberOf($student, $team)
{
$q = 'INSERT INTO is_member_of (user_id, team_id) VALUES(?, ?);';
$stmt = $this->dbConnection->prepare($q);
$studentID = $student->getId();
$teamID = $team->getId();
$stmt->bindParam(1, $studentID, \PDO::PARAM_INT);
$stmt->bindParam(2, $teamID, \PDO::PARAM_INT);
if ($stmt->execute()) {
echo "\n {$student->getFirstName()} {$student->getLastName()} successfully added as team member of: " . $team->getName();
} else {
throw new RDException($student->getUserName() . ' unsuccessfully added as team member of: ' . $team->getName());
}
}
/**
* Restores Administrator in database.
*
* @param Entity\AdministratorImpl $modelAdministrator
* @return AdministratorIterator
* @throws RDException
*/
public function restoreAdministrator($modelAdministrator)
{
$q = 'SELECT * from ' . DB_NAME . '.user WHERE user.user_type = 1';
if ($modelAdministrator != NULL) {
if ($modelAdministrator->getFirstName() != NULL) {
$q .= ' AND first_name = ' . $modelAdministrator->getFirstName();
}
if ($modelAdministrator->getLastName() != NULL) {
$q .= ' AND last_name = ' . $modelAdministrator->getLastName();
}
if ($modelAdministrator->getUserName() != NULL) {
$q .= ' AND user.user_name = "' . $modelAdministrator->getUserName() . '"';
}
if ($modelAdministrator->getPassword() != NULL) {
$q .= ' AND password = '******' AND email_address = ' . $modelAdministrator->getEmailAddress();
}
if ($modelAdministrator->getId() != -1) {
$q .= ' AND user_id = ' . $modelAdministrator->getId();
}
}
$stmt = $this->dbConnection->prepare($q . ';');
if ($stmt->execute()) {
//get results from Query
$resultSet = $stmt->fetchAll(\PDO::FETCH_ASSOC);
// return iterator
return new AdministratorIterator($resultSet, $this->objLayer);
} else {
throw new RDException('Error restoring administrator model error:' . print_r($stmt->errorInfo()));
}
}