dbo.Trulioo_Response

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE OR ALTER PROCEDURE  dbo.Trulioo_Response
@FirstName VARCHAR(100),
@SurName VARCHAR(100),
@Gender VARCHAR(1),
@StreetAddress VARCHAR(250),
@ZipCode VARCHAR(20),
@DateOfBirth DATE,
@IDNumber VARCHAR(20)

AS

BEGIN
 SET NOCOUNT ON;

DECLARE @ERRORNUMBER SMALLINT 

/*DEVOLVER COMO JSON BAJO HTTPS PRODUCTO TRULIOO Y RESTRINGIDO A LAS IP 

202.129.137.11 (Disaster Recovery)
117.53.173.226 (Production)
184.70.151.54 (Head Quarters)
207.81.188.13/32 (Head Quarters)


*/

SELECT '<TruliooRequest>
      <FirstName><![CDATA[' + @FirstName +  '] ]></FirstName>
      <SurName><![CDATA[' + @SurName +  ']]></SurName>
      <Gender>' + @Gender +  '</Gender>
      <StreetAddress><![CDATA[' + @StreetAddress +  ']]></StreetAddress>
      <ZipCode><![CDATA[' + @ZipCode +  ']]></ZipCode>
      <DateOfBirth>' + convert(varchar(18),@DateOfBirth) +  '</DateOfBirth>
      <IDNumber>' + @IDNumber +  '</IDNumber>
    </TruliooRequest>
    <FidelitasResponse>
      <Item id="AFIP">
        <FirstName>true</FirstName>
        <SurName>true</SurName>
        <Gender></Gender>
        <StreetAddress>true</StreetAddress>
        <ZipCode>false</ZipCode>
        <DateOfBirth></DateOfBirth>
        <IDNumber>true</IDNumber>
      </Item>
      <Item id="BCRA">
        <FirstName>true</FirstName>
        <SurName>true</SurName>
        <Gender></Gender>
        <StreetAddress></StreetAddress>
        <ZipCode></ZipCode>
        <DateOfBirth></DateOfBirth>
        <IDNumber>true</IDNumber>
      </Item>
      <Item id="OTHER_SOURCES">
        <FirstName>true</FirstName>
        <SurName>true</SurName>
        <Gender>true</Gender>
        <StreetAddress>true</StreetAddress>
        <ZipCode>true</ZipCode>
        <DateOfBirth>true</DateOfBirth>
        <IDNumber>true</IDNumber>
      </Item>
      <GlobalResponseData>
        <Financial>
          <Status>OK</Status>
        </Financial>
        <RequestDate>' + getdate() + '</RequestDate>
        <TransactionID>10000</TransactionID>
        <TransactionStatus>true</TransactionStatus>
        <Period>
          <Year>2018</Year>
          <Month>10</Month>
        </Period>
        <PeriodCount>50</PeriodCount>
      </GlobalResponseData>
    </FidelitasResponse>
  </Trulioo>
</WSFidelitas>' AS FidelitasResponse




END

GO