B1 iPayment Server Component - Add Credit Card worker

AddCreditCardMonitor

Runs every 5 minutes (Live) - every 5 seconds (Debug)

Workflow:

 Get all requests of link-type AddCreditCardLink or Unknown for current gateway

SELECT * FROM "@BOY_E0_ADDCCR" WHERE "U_LINKTYPE" = 0 OR "U_LINKTYPE" = 2 AND "U_GATEWAY" = [Gateways value]

(LINKTYPE = 1 are Internal links)

If request is older than 30 days it is deleted (and removed from Cloud connector) “U_TIMESTAMP”
Get visited status from Cloud Connector

SELECT Visited FROM [dbo].[AddCreditCardLinks] WHERE Reference = ‘[Reference sent from addon]’ [Note: iPayment Azure DB]

If link was visited we query Gateway for transaction details (For Cybersource we query the cloud connector)
If details were found we add the card to the database.
---------------------------------------------------------------
Each gateway add cards a bit differently:
Cayan/Moneris: Makes a temporary token into a permanent card before adding it to the database
Square/Eway/Cybersource: Gets a temporary token from the cloud connect, which is used to fetch the card from the gateway
Trust Payments (Secure Trading)/ProPay/Authorize.Net: Refreshes cards for the associated Business Partner based on the Gateway reference for that BP
---------------------------------------------------------------
After the card has been added, we remove the request from the gateway and Cloud connector tables