USP_DATAFORMTEMPLATE_VIEW_RE7INTEGRATIONCREDENTIALS

The load procedure used by the view dataform template "RE7 Integration Credentials View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@RE7INTEGRATIONCONFIGURED	bit	INOUT	RE7INTEGRATIONCONFIGURED
@RE7DBID	int	INOUT	RE7DBID
@RE7USERNAME	nvarchar(128)	INOUT	The Raiser's Edge user name
@RE7PASSWORD	nvarchar(128)	INOUT	The Raiser's Edge password
@RE7DBSERIALNUMBER	nvarchar(100)	INOUT	RE7DBSERIALNUMBER

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RE7INTEGRATIONCREDENTIALS (
                    @DATALOADED bit = 0 output,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @RE7INTEGRATIONCONFIGURED bit = null output,
                    @RE7DBID int = null output,
                    @RE7USERNAME nvarchar(128) = null output,
                    @RE7PASSWORD nvarchar(128) = null output,
                    @RE7DBSERIALNUMBER nvarchar(100) = null output
                ) as
                    set nocount on;

                    set @DATALOADED = 1;

                    set @RE7INTEGRATIONCONFIGURED = 0;
                    select
                        @RE7INTEGRATIONCONFIGURED = 1,
                        @RE7DBID = RE7INTEGRATIONCONFIGURATION.RE7DBID,
                        @RE7DBSERIALNUMBER = RE7INTEGRATIONCONFIGURATION.RE7DBSERIALNUMBER
                    from
                        dbo.RE7INTEGRATIONCONFIGURATION;

                    -- Open the symmetric key for decryption
                    exec dbo.USP_GET_KEY_ACCESS;

                    select
                        @RE7USERNAME = RE7INTEGRATIONCREDENTIALS.RE7USERNAME,
                        @RE7PASSWORD = coalesce(convert(nvarchar(128), DecryptByKey(RE7INTEGRATIONCREDENTIALS.RE7PASSWORD)),'')
                    from
                        dbo.RE7INTEGRATIONCREDENTIALS
                    where
                        ID = @CURRENTAPPUSERID;

                    close symmetric key sym_BBInfinity;

                    return 0;