use [TISNet]
GO

DECLARE @uzivatelId uniqueidentifier
DECLARE @dbStatusCode nchar(4)
DECLARE @dbStatusRefNumber nvarchar(50)
DECLARE @dbStatusMessage nvarchar(max)

--set @uzivatelId = 'GUID-UZIVATELE-TESTOVANE-SCHRANKY'
--set @dmIDReceived = 'ID_DOSLE_DATOVE-ZPRAVY'
--set @dmID = 'ID_ODESLANE_DATOVE-ZPRAVY'
set @uzivatelId = 'E8E6630D-558C-45CF-9EA2-EA4F955733B1'

-- DataBoxSearchWebService

-- ostre DS

EXECUTE [ISDS].[FindDataBox] 
   @uzivatelId
  ,'f8jah9r'
  ,@dbStatusCode OUTPUT
  ,@dbStatusRefNumber OUTPUT
  ,@dbStatusMessage OUTPUT
select @dbStatusCode,@dbStatusRefNumber,@dbStatusMessage

EXEC [ISDS].[FindDataBoxDetail]
		@uzivatelId = @uzivatelId,
		@dbStatusCode = @dbStatusCode OUTPUT,
		@dbStatusRefNumber = @dbStatusRefNumber OUTPUT,
		@dbStatusMessage = @dbStatusMessage OUTPUT,
		@dbType = 'OVM',
		@firmName = 'mar'
select @dbStatusCode,@dbStatusRefNumber,@dbStatusMessage

-- testovaci DS

EXECUTE [ISDS].[FindDataBoxWs] 
   @uzivatelId
  ,'f8jah9r'
  ,@dbStatusCode OUTPUT
  ,@dbStatusRefNumber OUTPUT
  ,@dbStatusMessage OUTPUT
  , @wsSadaId = '274EDC2F-C820-4B72-9202-F4A54B76F218'
select @dbStatusCode,@dbStatusRefNumber,@dbStatusMessage

EXEC [ISDS].[FindDataBoxDetailWs]
		@uzivatelId = @uzivatelId,
		@dbStatusCode = @dbStatusCode OUTPUT,
		@dbStatusRefNumber = @dbStatusRefNumber OUTPUT,
		@dbStatusMessage = @dbStatusMessage OUTPUT,
		@dbType = 'OVM',
		@firmName = 'mar',
		@wsSadaId = '274EDC2F-C820-4B72-9202-F4A54B76F218'
select @dbStatusCode,@dbStatusRefNumber,@dbStatusMessage
