USP_DATAFORMTEMPLATE_VIEW_EMAIL_EXTERNALSERVERCONFIGURATION

The load procedure used by the view dataform template "Email Services External Server Configuration View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@HOST	nvarchar(2048)	INOUT	Host URL
@USER	nvarchar(2048)	INOUT	User name
@PASS	nvarchar(2048)	INOUT	Password
@USESECURE	nvarchar(2048)	INOUT	Use SSL
@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_DATAFORMTEMPLATE_VIEW_EMAIL_EXTERNALSERVERCONFIGURATION
        (
            @DATALOADED bit = 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

        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,
                     @TRANSACTIONALPATH = ISNULL(EmailServiceTransactionalPath, ''),
                     @GENERALPURPOSEPATH = ISNULL(EmailServiceGeneralPurposePath, ''),
                     @STATUSPATH = ISNULL(EmailServiceStatusPath, ''),
                     @BINDING = ISNULL(EmailServiceBinding, '0'),
                     @USESHAREDSERVICESCOMMSERVICE = ISNULL(UseSharedServicesCommunicationService, 'False')
                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
              select @DATALOADED = 1, @HOST = '', @USER = '',@PASS = '',@USESECURE = 0, @BINDING = '0',@USESHAREDSERVICESCOMMSERVICE = 'False',
              @TRANSACTIONALPATH = '0', @GENERALPURPOSEPATH = '', @STATUSPATH = '';
            end

            return 0;

        end