USP_DATAFORMTEMPLATE_EDIT_EXTERNALSERVICECONFIGURATION

The save procedure used by the edit dataform template "External Service Configuration Edit".

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@HOST	nvarchar(2048)	IN	Host URL
@USER	nvarchar(2048)	IN	User name
@PASS	nvarchar(2048)	IN	Password
@USESECURE	nvarchar(2048)	IN	Use SSL
@CHUNKSIZE	nvarchar(2048)	IN	Merge Data Chunk Size (in bytes)

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EXTERNALSERVICECONFIGURATION (
              @CHANGEAGENTID uniqueidentifier = null,
              @HOST nvarchar(2048),
              @USER nvarchar(2048),
              @PASS nvarchar(2048),
            @USESECURE nvarchar(2048),
            @CHUNKSIZE nvarchar(2048)
          )
          as

              set nocount on;

            exec dbo.USP_GET_KEY_ACCESS;

              if @CHANGEAGENTID is null  
                  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

              declare @CURRENTDATE datetime
              set @CURRENTDATE = getdate();

              begin try

                  update dbo.EXTERNALSERVICECONFIGURATION set VALUE = @Host
                where NAME = 'BlackbaudServiceHost';
              update dbo.EXTERNALSERVICECONFIGURATION set VALUE = encryptbykey(key_guid('sym_BBInfinity'), @USER)
                where NAME = 'BlackbaudServiceUser';
              update dbo.EXTERNALSERVICECONFIGURATION set VALUE = encryptbykey(key_guid('sym_BBInfinity'), @PASS)
                where NAME = 'BlackbaudServicePassword';
              update dbo.EXTERNALSERVICECONFIGURATION set VALUE = @USESECURE
                where NAME = 'BlackbaudServiceUseSecureServices';
              update dbo.EXTERNALSERVICECONFIGURATION set VALUE = @CHUNKSIZE
                where NAME = 'ChunkSize';

              close symmetric key sym_BBInfinity;
            end try
              begin catch
              close symmetric key sym_BBInfinity;
                  exec dbo.USP_RAISE_ERROR;
                  return 1;
              end catch



          return 0;