USP_LOAD_EXTERNALSERVICECONFIGURATION

Loads the external service configuration form.

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@HOST	nvarchar(2048)	INOUT
@USER	nvarchar(2048)	INOUT
@PASS	nvarchar(2048)	INOUT
@USESECURE	nvarchar(2048)	INOUT
@TRANSACTIONALPATH	nvarchar(2048)	INOUT
@GENERALPURPOSEPATH	nvarchar(2048)	INOUT
@STATUSPATH	nvarchar(2048)	INOUT
@BINDING	nvarchar(2048)	INOUT
@USESHAREDSERVICESCOMMSERVICE	nvarchar(2048)	INOUT

Definition

Copy



      CREATE procedure dbo.USP_LOAD_EXTERNALSERVICECONFIGURATION
      (
        @DATALOADED bit = 0 output,
        @TSLONG bigint = 0 output,
          @HOST nvarchar(2048) = null output,
          @USER nvarchar(2048) = null output,
          @PASS nvarchar(2048) = null output,
        @USESECURE nvarchar(2048) = null output,
        @TRANSACTIONALPATH nvarchar(2048) = null output,
        @GENERALPURPOSEPATH nvarchar(2048) = null output,
        @STATUSPATH nvarchar(2048) = null output,
        @BINDING nvarchar(2048) = null output,
        @USESHAREDSERVICESCOMMSERVICE nvarchar(2048) = null output
      )
      as
      begin
        set nocount on;

        exec dbo.USP_GET_KEY_ACCESS;

        set @DATALOADED = 0
        set @TSLONG = 0

        if exists(select null from EXTERNALSERVICECONFIGURATION where NAME = 'BlackbaudServiceHost')
        begin
          begin try
            select top 1 
                   @DATALOADED = 1,
                   @HOST = BlackbaudServiceHost, 
                   @USER = decryptbykey(BlackbaudServiceUser),
                   @PASS = decryptbykey(BlackbaudServicePassword),
                   @USESECURE = BlackbaudServiceUseSecureServices,
                   @BINDING = ISNULL(EmailServiceBinding, '0'),
                   @USESHAREDSERVICESCOMMSERVICE = ISNULL(UseSharedServicesCommunicationService, 'False'),
                   @TRANSACTIONALPATH = ISNULL(EmailServiceTransactionalPath, ''),
                   @GENERALPURPOSEPATH = ISNULL(EmailServiceGeneralPurposePath, ''),
                   @STATUSPATH = ISNULL(EmailServiceStatusPath, '')

              from (select NAME, VALUE from dbo.EXTERNALSERVICECONFIGURATION)  D
                pivot(max(VALUE) for NAME
                    in(BlackbaudServiceHost, BlackbaudServiceUser, BlackbaudServicePassword, BlackbaudServiceUseSecureServices, EmailServiceBinding,UseSharedServicesCommunicationService,EmailServiceTransactionalPath,EmailServiceGeneralPurposePath,EmailServiceStatusPath)) as P;

            close symmetric key sym_BBInfinity;
          end try
          begin catch
            close symmetric key sym_BBInfinity;
          end catch
         end
         else
          begin
            set @DATALOADED = 1;
            set @HOST = ''; 
            set @USER = '';
            set @PASS = '';
            set @USESECURE = 0;
            set @BINDING = '0';
            set @USESHAREDSERVICESCOMMSERVICE = 'False';
            set @TRANSACTIONALPATH = '';
            set @GENERALPURPOSEPATH = '';
            set @STATUSPATH = '';
          end
          return 0;

      end