USP_DATAFORMTEMPLATE_VIEW_MANAGEREGISTRATIONFORMSPAGEDATA

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ALLOWADDSECTION	bit	INOUT
@ALLOWUPDATESECTION	bit	INOUT
@ALLOWDELETESECTION	bit	INOUT
@CODETABLENAME	nvarchar(100)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MANAGEREGISTRATIONFORMSPAGEDATA
(
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ALLOWADDSECTION bit = null output,
    @ALLOWUPDATESECTION bit = null output,
    @ALLOWDELETESECTION bit = null output,
    @CODETABLENAME nvarchar(100) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    declare @REGISTRATIONSECTIONCODETABLEID uniqueidentifier = '98d64023-e5cd-4405-9e20-146adcdff8cc';

    declare @ISSYSADMIN as bit = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);

    select 
        @DATALOADED = 1,
        @ALLOWADDSECTION = case @ISSYSADMIN when 1 then 1 else dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYADD_IN_SYSTEMROLE(@CURRENTAPPUSERID, @REGISTRATIONSECTIONCODETABLEID) end,
        @ALLOWUPDATESECTION = case @ISSYSADMIN when 1 then 1 else dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYUPDATE_IN_SYSTEMROLE(@CURRENTAPPUSERID, @REGISTRATIONSECTIONCODETABLEID) end,
        @ALLOWDELETESECTION = case @ISSYSADMIN when 1 then 1 else dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYDELETE_IN_SYSTEMROLE(@CURRENTAPPUSERID, @REGISTRATIONSECTIONCODETABLEID) end,
        @CODETABLENAME = 'Registration Section';    

    return 0;