USP_SECURITY_WEBDASHBOARDPRIVILEGE_UPDATEASSIGNMENTS

Saves web dashboard privilege assignments for a system role.
Parameters

Parameter	Parameter Type	Mode
@SYSTEMROLEID	uniqueidentifier	IN
@ISGRANTEDPERSONALIZEPAGES	bit	IN
@ISGRANTEDADDPAGES	bit	IN
@ISGRANTEDASSIGNPAGEPERMISSIONS	bit	IN
@ISGRANTEDADDFOLDERS	bit	IN
@ISGRANTEDEDITFOLDERS	bit	IN
@ISGRANTEDDELETEFOLDERS	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


create procedure dbo.USP_SECURITY_WEBDASHBOARDPRIVILEGE_UPDATEASSIGNMENTS(@SYSTEMROLEID uniqueidentifier,
    @ISGRANTEDPERSONALIZEPAGES bit,
    @ISGRANTEDADDPAGES bit,
    @ISGRANTEDASSIGNPAGEPERMISSIONS bit,
    @ISGRANTEDADDFOLDERS bit,
    @ISGRANTEDEDITFOLDERS bit,
    @ISGRANTEDDELETEFOLDERS bit,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    if exists(select ID from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '0A17B2A7-AB84-4F69-8107-8C4696C86A20')
    begin
        update dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE set GRANTORDENY = @ISGRANTEDPERSONALIZEPAGES,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate() 
        where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '0A17B2A7-AB84-4F69-8107-8C4696C86A20';
    end
    else
    begin
        insert into dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE (SYSTEMROLEID,
            SYSTEMPRIVILEGECATALOGID,
            GRANTORDENY,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@SYSTEMROLEID,
            '0A17B2A7-AB84-4F69-8107-8C4696C86A20',
            @ISGRANTEDPERSONALIZEPAGES,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;

    if exists(select ID from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '4BBB38E1-C083-40D5-95D5-B6615E415B2F')
    begin
        update dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE set GRANTORDENY = @ISGRANTEDADDPAGES,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate() 
        where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '4BBB38E1-C083-40D5-95D5-B6615E415B2F';
    end
    else
    begin
        insert into dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE (SYSTEMROLEID,
            SYSTEMPRIVILEGECATALOGID,
            GRANTORDENY,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@SYSTEMROLEID,
            '4BBB38E1-C083-40D5-95D5-B6615E415B2F',
            @ISGRANTEDADDPAGES,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;

    if exists(select ID from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '0ec592a0-416c-4052-b80f-99fc324dd918')
    begin
        update dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE set GRANTORDENY = @ISGRANTEDASSIGNPAGEPERMISSIONS,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate() 
        where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '0ec592a0-416c-4052-b80f-99fc324dd918';
    end
    else
    begin
        insert into dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE (SYSTEMROLEID,
            SYSTEMPRIVILEGECATALOGID,
            GRANTORDENY,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@SYSTEMROLEID,
            '0ec592a0-416c-4052-b80f-99fc324dd918',
            @ISGRANTEDASSIGNPAGEPERMISSIONS,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;

    if exists(select ID from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '59A5486F-E153-4714-A2C7-FD2E521596F3')
    begin
        update dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE set GRANTORDENY = @ISGRANTEDADDFOLDERS,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate() 
        where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '59A5486F-E153-4714-A2C7-FD2E521596F3';
    end
    else
    begin
        insert into dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE (SYSTEMROLEID,
            SYSTEMPRIVILEGECATALOGID,
            GRANTORDENY,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@SYSTEMROLEID,
            '59A5486F-E153-4714-A2C7-FD2E521596F3',
            @ISGRANTEDADDFOLDERS,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;

    if exists(select ID from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '6A5E05FD-72F3-4AE8-B683-4DA1D72A4A3C')
    begin
        update dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE set GRANTORDENY = @ISGRANTEDEDITFOLDERS,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate() 
        where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '6A5E05FD-72F3-4AE8-B683-4DA1D72A4A3C';
    end
    else
    begin
        insert into dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE (SYSTEMROLEID,
            SYSTEMPRIVILEGECATALOGID,
            GRANTORDENY,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@SYSTEMROLEID,
            '6A5E05FD-72F3-4AE8-B683-4DA1D72A4A3C',
            @ISGRANTEDEDITFOLDERS,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;

    if exists(select ID from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '338CCF93-7B86-4BCD-B08A-8D7F0E625769')
    begin
        update dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE set GRANTORDENY = @ISGRANTEDDELETEFOLDERS,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate() 
        where SYSTEMROLEID = @SYSTEMROLEID and SYSTEMPRIVILEGECATALOGID = '338CCF93-7B86-4BCD-B08A-8D7F0E625769';
    end
    else
    begin
        insert into dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE (SYSTEMROLEID,
            SYSTEMPRIVILEGECATALOGID,
            GRANTORDENY,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@SYSTEMROLEID,
            '338CCF93-7B86-4BCD-B08A-8D7F0E625769',
            @ISGRANTEDDELETEFOLDERS,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;