Payment Gateway » Mexico Banamex TNS

h1. Specification

h1. Activity Diagram

Figure 1 showing the process flow from Mexico mall to TNS Payment Gateway Page.

!gw.png!

Figure 2 showing the process flow of TNS Payment Gateway redirect back to Mexico Mall.

!recv.png!

h1. Programming Guide

h2. Resources

h3. SCM

see [[wiki#SCM]]

h3. Classes

* *my.com.eCosway.tns.commons*      - CommonConstants

* *my.com.eCosway.tns.model*        - Transaction, TransCommon, TransResponse

* *my.com.eCosway.tns.service*      - TNSService (interface)

* *my.com.eCosway.tns.service.impl* - TNSServiceImpl (implementation of interface)

* *my.com.eCosway.tns.tnsInterface* - TNSInterfaces (Data Persistence)

* *my.com.eCosway.tns.utils*        - CommonUtils, SecureHash, URLUtils

* *test.my.com.eCosway.tns.utils*   - SecureHashTest, URLUtilsTest (JUnit Test)

h3. properties file

* *transaction.properties*

   # *vpc_Version*        - The version of the Virtual Payment Client API being used.

   # *vpc_Command*        - Indicates the desired operation to be performed.

   # *vpc_AccessCode*     - Authenticates the merchant on the Payment Server.

   # *vpc_Merchant*       - The Merchant ID identifies the merchant account against which settlements will be made.

   # *vpc_Currency*       - The currency of the order expressed as an ISO 4217 alpha code.

   # *vpc_Locale*         - Specifies the language used on the Payment Server pages that are displayed to the cardholder, in 3-Party transactions.

   # *vpc_SecureHash*     - A secure hash which allows the Virtual Payment Client to authenticate the merchant and check the integrity of the Transaction Request.

   # *vpc_SecureHashType* - The type of hash algorithm used to generate the secure hash.

   # *vpc_ReturnAuthResponseData* - Specifies whether the authorisation response data must be included in the Transaction Response.

   * *tns_url*            - Used to redirect user to TNS Payment Page.

   * *tns.interface.table.name* - table name of TNS interface.

h3. Database Table

<pre>

CREATE TABLE ECOS.TNS_INTERFACE (

	ORDER_ID VARCHAR(100) NOT NULL, 

	CHARGE_AMT DECIMAL(15,2), 

	TRX_TYPE VARCHAR(20), 

	SHOPPER_REF_NO INTEGER, 

	CURRENCY VARCHAR(3),

	ERROR_MESSAGE VARCHAR(255), 

	RESPONSE_CODE CHARACTER, 

	RECEIPT_NO VARCHAR(20), 

	TRANSACTION_NO INTEGER, 

	AUTHORIZE_ID VARCHAR(6), 

	CARD_TYPE VARCHAR(2), 

	TRANSACTION_IDENTIFIER VARCHAR(20), 

	IS_VALID CHARACTER, 

	DATETIME TIMESTAMP,

	MODIFY_DATETIME TIMESTAMP, 

	PRIMARY KEY (ORDER_ID))

</pre>

h3. Integration

*redirect to TNS Payment Page*

<pre>

my.com.eCosway.tns.service.TNSService service = new my.com.eCosway.tns.service.impl.TNSServiceImpl();

String URL = service.getURL(Connection conn, String orderNo, double amount,

			String currency, String locale, String returnURL,

			String transactionType, int shopperRefNo);

</pre>

# *conn*            - Database connection.

# *orderNo*         - The unique order No (1-40 alphanumeric).

# *amount*          - The amount of the transaction (1-12 numeric).

# *currency*        - The currency of the order expressed as an ISO 4217 alpha code.

# *locale*          - Specifies the language used on the Payment Server pages that are displayed to the cardholder.

# *returnURL*       - Used by Payment Server to redirect the user back to merchant's web site.

# *transactionType* - The Type of Transaction.

# *shopperRefNo*    - Member ID.

*To update TNS Response into Database*

<pre>

my.com.eCosway.tns.model.TransResponse res = new my.com.eCosway.tns.tnsInterface.TNSInterfaces().updateTransaction(Connection conn,

			HttpServletRequest request)

</pre>