USP_DATAFORMTEMPLATE_VIEW_APPLICATIONUSER_SUMMARY

The load procedure used by the view dataform template "Application User Summary View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DISPLAYNAME	nvarchar(255)	INOUT	Display name
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@CONSTITUENTNAME	nvarchar(154)	INOUT	Linked to constituent
@ISSYSADMIN	bit	INOUT	Is system administrator
@CANCUSTOMIZEHOMEPAGE	bit	INOUT	Can customize home page
@SITENAME	nvarchar(1024)	INOUT	Site
@CURRENCYSETNAME	nvarchar(100)	INOUT	Currency set
@ISACTIVE	bit	INOUT
@PROXYOWNER	nvarchar(128)	INOUT
@PROXYOWNERID	uniqueidentifier	INOUT
@ISPROXYUSER	bit	INOUT
@HASRUNASRIGHTS	bit	INOUT
@LINKEDTOBBID	bit	INOUT

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_APPLICATIONUSER_SUMMARY
        (
          @ID uniqueidentifier,
          @DATALOADED bit = 0 output,
          @DISPLAYNAME nvarchar(255) = null output,
          @CONSTITUENTID uniqueidentifier = null output,
          @CONSTITUENTNAME nvarchar(154) = null output,
          @ISSYSADMIN bit = null output,
          @CANCUSTOMIZEHOMEPAGE bit = null output,
          @SITENAME nvarchar(1024) = null output,
          @CURRENCYSETNAME nvarchar(100) = null output,
          @ISACTIVE bit = null output,
          @PROXYOWNER nvarchar(128) = null output,
          @PROXYOWNERID uniqueidentifier = null output,
          @ISPROXYUSER bit = null output,
          @HASRUNASRIGHTS bit = null output,
          @LINKEDTOBBID bit = null output
        ) as
          set nocount on;

          set @DATALOADED = 0

          select
            @DATALOADED = 1,
            @DISPLAYNAME = APPUSER.DISPLAYNAME,
            @CONSTITUENTID = APPUSER.CONSTITUENTID,
            @CONSTITUENTNAME = NF.NAME,
            @ISSYSADMIN = APPUSER.ISSYSADMIN,
            @CANCUSTOMIZEHOMEPAGE = 
              case when APPUSER.ISSYSADMIN = 1 then 1 
              else dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@ID, '691E1971-13B1-4947-AAD5-1D47103124F4')
              end,
            @SITENAME = (SELECT NAME FROM dbo.SITE WHERE ID = APPUSER.SITEID),
            @ISACTIVE = isnull(APPUSER.ISACTIVE, 1),
            @PROXYOWNER = 
                case when APPUSER.ISPROXYUSER = 1 then ( select case when len(APPUSERPROXYOWNER.CUSTOM_AUTHENTICATION_USERID) = 0 then coalesce(APPUSERPROXYOWNER.USERNAME, APPUSERPROXYOWNER.DISPLAYNAME) else APPUSERPROXYOWNER.CUSTOM_AUTHENTICATION_USERID end 
                                                         from dbo.APPUSER as APPUSERPROXYOWNER
                                                         where APPUSERPROXYOWNER.ID = APPUSER.PROXYOWNERID)
                else null end,
            @PROXYOWNERID = case when APPUSER.ISPROXYUSER = 1 then APPUSER.PROXYOWNERID else null end,
            @ISPROXYUSER = APPUSER.ISPROXYUSER,
            @HASRUNASRIGHTS = isnull(APPUSER.HASRUNASRIGHTS, 0),
            @LINKEDTOBBID = case when exists (select 1 from dbo.APPUSERCLAIMSLINK where APPUSERCLAIMSLINK.APPUSERID = APPUSER.ID and ISREGISTERED = 1) then 1 else 0 end
          from
            dbo.APPUSER
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(APPUSER.CONSTITUENTID) NF
          where
            APPUSER.ID = @ID;

          if @DATALOADED = 1
            select
              @CURRENCYSETNAME = CURRENCYSET.NAME
            from
              dbo.APPUSERCURRENCYSET
              left join dbo.CURRENCYSET on CURRENCYSET.ID = APPUSERCURRENCYSET.CURRENCYSETID
            where
              APPUSERCURRENCYSET.APPUSERID = @ID;

          return 0;