public static function addRoleToUser(int $userId, int $roleId)
{
$db = Database::getInstance('app');
$result = $db->prepare("\r\n insert into user_roles values(:userId, :roleId);\r\n ");
$result->execute([':userId' => $userId, ':roleId' => $roleId]);
}
private static function insert(Lecture $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO lectures (id,speakerid,hallid,name,startdatatime,enddatatime)\r\n VALUES (':id', ':speakerid', ':hallid', ':name', ':startdatatime', ':enddatatime')";
$result = $db->prepare($query);
$result->execute([':id' => $model->getId(), ':speakerid' => $model->getSpeakerId(), ':hallid' => $model->getHallId(), ':name' => $model->getName(), ':startdatatime' => $model->getStartDateTime(), ':enddatatime' => $model->getEndDateTime()]);
$model->setId((int) $db->lastId());
}
private static function insert(Hall $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO halls (id,name,venueid,userlimit)\r\n VALUES (':id', ':name', ':venueid','userlimit')";
$result = $db->prepare($query);
$result->execute([':id' => $model->getId(), ':name' => $model->getName(), ':venueid' => $model->getVenueId(), ':userlimit' => $model->getUserLimit()]);
$model->setId((int) $db->lastId());
}
private static function insert(Venue $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO venues (id,name,address)\r\n VALUES (':id', ':name', ':address')";
$result = $db->prepare($query);
$result->execute([':id' => $model->getId(), ':name' => $model->getName(), ':address' => $model->getAddress()]);
$model->setId((int) $db->lastId());
}
private static function insert(Conference $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO conferences (ownerid,administratorid,venueid,name,startdatatime,enddatatime)\r\n VALUES (':ownerid', ':administratorid', ':venueid', ':name', ':startdatatime', ':enddatatime')";
$result = $db->prepare($query);
$result->execute([':ownerid' => $model->getOwnerId(), ':administratorid' => $model->getAdministratorId(), ':id' => $model->getId(), ':venueid' => $model->getVenueId(), ':name' => $model->getName(), ':startdatatime' => $model->getStartDateTime(), ':enddatatime' => $model->getEndDateTime()]);
$model->setId((int) $db->lastId());
}
private static function insert(IdentityUser $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO users (username,password) VALUES ('" . $model->getUsername() . "', '" . $model->getPassword() . "')";
$result = $db->prepare($query);
$result->execute([]);
$model->setId((int) $db->lastId());
}
