USP_DATAFORMTEMPLATE_VIEW_CMSADMINPAGELOGIN

The load procedure used by the view dataform template "CMS Administration Page Login View Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@URL	nvarchar(1024)	INOUT	URL
@CLIENTUSERID	int	INOUT	Client user ID
@TOKEN	nvarchar(1000)	INOUT	Token

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CMSADMINPAGELOGIN
(
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @URL nvarchar(1024) = null output,
    @CLIENTUSERID integer = null output,
    @TOKEN nvarchar(1000) = null output
)
as
  DECLARE @RESULTS xml
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    set @CLIENTUSERID = dbo.UFN_BBNCUSERMAP_GETBBNCUSERID(@CURRENTAPPUSERID);

    set @URL = dbo.UFN_BBNC_URLFORUSER(@CLIENTUSERID);

    set @TOKEN = newid();
    exec dbo.USP_REGISTER_CMS_AUTOLOG_TOKEN @TOKEN, @CLIENTUSERID, 60; --1 minute window


    EXEC dbo.USP_GET_KEY_ACCESS 
    SET @TOKEN  = EncryptByKey(Key_GUID('sym_BBInfinity'), @TOKEN)
    CLOSE symmetric key sym_BBInfinity;
    set @RESULTS = (SELECT CONVERT(varbinary(max), CONVERT(nvarchar(max),@TOKEN))
     FOR XML PATH (''))

      select @TOKEN = @RESULTS.value('.', 'nvarchar(max)')

    select @DATALOADED = 1;

    return 0;