/** * Deletes an associated RoleModuleAuthorization * @param RoleModuleAuthorization $objRoleModuleAuthorization * @return void */ public function DeleteAssociatedRoleModuleAuthorization(RoleModuleAuthorization $objRoleModuleAuthorization) { if (is_null($this->intAuthorizationLevelId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateRoleModuleAuthorization on this unsaved AuthorizationLevel.'); } if (is_null($objRoleModuleAuthorization->RoleModuleAuthorizationId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateRoleModuleAuthorization on this AuthorizationLevel with an unsaved RoleModuleAuthorization.'); } // Get the Database Object for this Class $objDatabase = AuthorizationLevel::GetDatabase(); // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `role_module_authorization` WHERE `role_module_authorization_id` = ' . $objDatabase->SqlVariable($objRoleModuleAuthorization->RoleModuleAuthorizationId) . ' AND `authorization_level_id` = ' . $objDatabase->SqlVariable($this->intAuthorizationLevelId) . ' '); // Journaling if ($objDatabase->JournalingDatabase) { $objRoleModuleAuthorization->Journal('DELETE'); } }