This stored procedure returns all of the site-level settings for the portal, as well as layout and security settings for the specified tab. This data is returned as 3 separate result sets plus 8 OUTPUT parameters, and is used to populate the PortalSettings class returned configuration system.
Definition:CREATE PROCEDURE GetPortalSettings ( @PortalAlias nvarchar(50), @TabID int, @PortalID int OUTPUT, @PortalName nvarchar(128) OUTPUT, @AlwaysShowEditButton bit OUTPUT, @TabName nvarchar (50) OUTPUT, @TabOrder int OUTPUT, @MobileTabName nvarchar (50) OUTPUT, @AuthRoles nvarchar (256) OUTPUT, @ShowMobile bit OUTPUT ) AS /* ---First, get Out Params--- */ IF @TabID = 0 SELECT TOP 1 @PortalID = Portals.PortalID, @PortalName = Portals.PortalName, @AlwaysShowEditButton = Portals.AlwaysShowEditButton, @TabID = Tabs.TabID, @TabOrder = Tabs.TabOrder, @TabName = Tabs.TabName, @MobileTabName = Tabs.MobileTabName, @AuthRoles = Tabs.AuthorizedRoles, @ShowMobile = Tabs.ShowMobile FROM Tabs INNER JOIN Portals ON Tabs.PortalID = Portals.PortalID WHERE PortalAlias=@PortalAlias ORDER BY TabOrder ELSE SELECT @PortalID = Portals.PortalID, @PortalName = Portals.PortalName, @AlwaysShowEditButton = Portals.AlwaysShowEditButton, @TabName = Tabs.TabName, @TabOrder = Tabs.TabOrder, @MobileTabName = Tabs.MobileTabName, @AuthRoles = Tabs.AuthorizedRoles, @ShowMobile = Tabs.ShowMobile FROM Tabs INNER JOIN Portals ON Tabs.PortalID = Portals.PortalID WHERE TabID=@TabID /* ---Next, get Tabs list--- */ SELECT TabName, AuthorizedRoles, TabID, TabOrder FROM Tabs WHERE PortalID = @PortalID ORDER BY TabOrder /* ---Then, get Mobile Tabs list--- */ SELECT MobileTabName, AuthorizedRoles, TabID, ShowMobile FROM Tabs WHERE PortalID = @PortalID AND ShowMobile = 1 ORDER BY TabOrder /* ---Last, get the DataTable of module info--- */ SELECT * FROM Modules INNER JOIN ModuleDefinitions ON Modules.ModuleDefID = ModuleDefinitions.ModuleDefID WHERE TabID = @TabID ORDER BY ModuleOrderDatabase Tables Used:
Portals: The portals table holds site-level settings. The primary key in this table is the PortalID identity field.
The primary key in this table is the ModuleID identity field.