USP_DATAFORMTEMPLATE_VIEW_CONFIGUREWEALTHPOINTPAGEDATA_2

The load procedure used by the view dataform template "Configure WealthPoint Page Expression View Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@UNRESOLVEDSEARCHES	bit	INOUT	Unresolved searches
@HASWEALTHPOINTCREDENTIALS	bit	INOUT	Has WealthPoint credentials
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DATAREFRESHENABLED	bit	INOUT	WealthPoint Data Refresh is Enabled
@WEALTHPOINTREGISTERED	bit	INOUT	WealthPoint Registered
@WEALTHPOINTACCOUNTTYPECODE	int	INOUT	WealthPoint Account Type Code
@DATAREFRESHAVAILABLE	bit	INOUT	WealthPoint Data Refresh is available
@UNRESOLVEDDATAREFRESH	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONFIGUREWEALTHPOINTPAGEDATA_2 (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @UNRESOLVEDSEARCHES bit = null output,
                    @HASWEALTHPOINTCREDENTIALS bit = null output,
                    @DATALOADED bit = 0 output,
                    @DATAREFRESHENABLED bit = null output,
                    @WEALTHPOINTREGISTERED bit = null output,
                    @WEALTHPOINTACCOUNTTYPECODE integer = null output,
                    @DATAREFRESHAVAILABLE bit = null output,
                    @UNRESOLVEDDATAREFRESH bit = null output
                ) as
                    set nocount on;

                    set @DATALOADED = 1;

                    if (select count(ID) from WPSEARCHHISTORY where STATUSCODE in(0,1,2)) > 0 begin
                        set @UNRESOLVEDSEARCHES    = 1;    
                        if (select count(ID) from WPSEARCHHISTORY where STATUSCODE in(0,1,2) and SEARCHTYPECODE = 2) > 0
                            set @UNRESOLVEDDATAREFRESH    = 1;    
                        else
                            set @UNRESOLVEDDATAREFRESH = 0;
                        end
                    else
                        set @UNRESOLVEDSEARCHES = 0;

                    --Find if user has wealthcredentials
                    declare @WEALTHPOINTUSERNAME nvarchar(100)
                    declare @WEALTHPOINTPASSWORD nvarchar(100)

                    exec dbo.USP_GET_KEY_ACCESS;

                    select
                        @WEALTHPOINTUSERNAME = USERNAME,
                        @WEALTHPOINTPASSWORD = convert(nvarchar(100), DecryptByKey(PASSWORD))
                    from
                        dbo.WEALTHPOINTCREDENTIALS
                    where
                        ID = @CURRENTAPPUSERID;

                    if @WEALTHPOINTUSERNAME <> '' and @WEALTHPOINTUSERNAME is not null and @WEALTHPOINTPASSWORD <> '' and @WEALTHPOINTPASSWORD is not null
                        set @HASWEALTHPOINTCREDENTIALS = 1;
                    else
                        set @HASWEALTHPOINTCREDENTIALS = 0;    

                    select
                        @DATAREFRESHENABLED =         isnull(DATAREFRESHENABLED,0),
                        @WEALTHPOINTREGISTERED =      isnull(REGISTERED,0),
                        @WEALTHPOINTACCOUNTTYPECODE = isnull(ACCOUNTTYPECODE,0),
                        @DATAREFRESHAVAILABLE =       case when ACCOUNTTYPECODE in (1,2,6,7) then 1 else 0 end
                    from 
                        dbo.WEALTHPOINTCONFIGURATION

                    return 0;