USP_DATAFORMTEMPLATE_PRELOAD_ADD_CURRENCYEXCHANGERATEDOWNLOADPROCESSXIGNITE

The load procedure used by the edit dataform template "Xignite Currency Exchange Rate Download Process Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@WEBSITEURL	UDT_WEBADDRESS	INOUT	Web site
@RATES	xml	INOUT	Rates
@PROVIDERAUTHENTICATION	xml	INOUT	Authentication
@SETPROVIDERAUTHENTICATIONASDEFAULT	bit	INOUT	Set as default authentication for Xignite

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_CURRENCYEXCHANGERATEDOWNLOADPROCESSXIGNITE]
(
  @WEBSITEURL dbo.[UDT_WEBADDRESS] = null output,
  @RATES xml = null output,
  @PROVIDERAUTHENTICATION xml = null output,
  @SETPROVIDERAUTHENTICATIONASDEFAULT bit = null output
)
as
  set nocount on;

  exec dbo.[USP_GET_KEY_ACCESS];

  select
    @WEBSITEURL = [WEBSITEURL],
    @PROVIDERAUTHENTICATION = convert(xml, convert(varbinary(3800), decryptbykey([DEFAULTAUTHENTICATION]))),
    @SETPROVIDERAUTHENTICATIONASDEFAULT = case when len(isnull([DEFAULTAUTHENTICATION], '')) = 0 then 1 else 0 end
  from dbo.[CURRENCYEXCHANGERATEPROVIDER]
  where [ID] = '6E1EAAEF-070F-4F88-B546-036EFA7AE96E';

  close symmetric key sym_BBInfinity;

  set @RATES = dbo.[UFN_CURRENCYEXCHANGERATEDOWNLOADPROCESS_GETDEFAULTRATES]();

  return 0;