USP_CURRENCYEXCHANGERATEDOWNLOADPROCESS_GETPROPERTIES

CREATE procedure dbo.[USP_CURRENCYEXCHANGERATEDOWNLOADPROCESS_GETPROPERTIES]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as
begin
    set nocount on;

  declare @SOURCECODEID uniqueidentifier;
  declare @PROVIDERNAME nvarchar(100);

  set @SOURCECODEID = null;

  if (select [SETSOURCECODETOPROVIDER] from dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESS] where [ID] = @ID) = 1
    begin
      if @CHANGEAGENTID is null
        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

      select
        @PROVIDERNAME = [CURRENCYEXCHANGERATEPROVIDER].[NAME]
      from dbo.[CURRENCYEXCHANGERATEPROVIDER]
      inner join dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESS] on [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[CURRENCYEXCHANGERATEPROVIDERID] = [CURRENCYEXCHANGERATEPROVIDER].[ID]
      where [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ID] = @ID;

      set @SOURCECODEID = dbo.[UFN_CURRENCYEXCHANGERATESOURCECODE_GETID](@PROVIDERNAME);
      if @SOURCECODEID is null
        exec dbo.[USP_CURRENCYEXCHANGERATESOURCECODE_CREATEENTRY] @PROVIDERNAME, 1, null, @CHANGEAGENTID, @SOURCECODEID output;
    end

  exec dbo.[USP_GET_KEY_ACCESS];

  select
    [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[NAME],
    [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[TYPECODE],
    [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[SETSOURCECODETOPROVIDER],
    @SOURCECODEID as [SOURCECODEID],
    [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[DELETEHISTORYTHRESHOLDCODE],
    [CURRENCYEXCHANGERATEPROVIDER].[ASSEMBLYNAME],
    [CURRENCYEXCHANGERATEPROVIDER].[CLASSNAME],
    convert(xml, convert(nvarchar(3800), decryptbykey([CURRENCYEXCHANGERATEDOWNLOADPROCESS].[PROVIDERAUTHENTICATION]))) as [AUTHENTICATION],
    [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[PROVIDERPARAMETERS] as [PARAMETERS],
    [CURRENCYEXCHANGERATEPROVIDER].[TIMEZONEENTRYID] as [PROVIDERTIMEZONEENTRYID],
    dbo.[UFN_TIMEZONEENTRY_GETSYSTEMDEFAULT]() as [DEFAULTTIMEZONEENTRYID]
  from dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESS]
  inner join dbo.[CURRENCYEXCHANGERATEPROVIDER] on [CURRENCYEXCHANGERATEPROVIDER].[ID] = [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[CURRENCYEXCHANGERATEPROVIDERID]
  where [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ID] = @ID;

  close symmetric key sym_BBInfinity;

    return 0;
end