Project

General

Profile

Programming Guide for Batch Program » History » Revision 3

Revision 2 (chin-yeh, 09/29/2011 10:49 AM) → Revision 3/5 (chin-yeh, 09/29/2011 10:51 AM)

{{toc}} 

 h1. Programming Guide for Batch Program 

 > Refer to [[Programming Guide]] if integrating in other environment, e.g. web app 

 All of the APIs mentioned below will not invoke the DP web services at all. Instead it will insert record into [[Specification#DP_INTERFACE|interface table]] and then those records will be picked up by a specific batch program and send it to DP on daily basis. 

 The Javadoc of *dp-client*: 
 > http://192.168.2.13:50000/dp_client_apidocs/ 

 The binary or source files of *dp-client*: 
 > [[wiki#SCM|SCM]] 

 Demo application of *dp-client*: 
 > There is no demo application for these APIs but these API usage is very similiar with the one that mentioned in [[Programming Guide]] 

 h2. Commit Sales 

 This method is used to deduct DP balance.  

 _This And, this method *will only persist* the transaction details into database._ database. 

 _Method Signature:_ 
 <pre> 
 <code class="JAVA"> 
 public static int persistSalesCommit(java.sql.Connection dbConnection, 
                                      java.lang.String transactionId, 
                                      java.lang.String countryCode, 
                                      java.lang.String memberId, 
                                      java.util.Date trxDate, 
                                      java.math.BigDecimal dpAmount, 
                                      java.math.BigDecimal invoiceAmount) 
                               throws java.sql.SQLException 
 </code> 
 </pre> 


 h3. Input Parameters 

 See "persistSalesCommit":http://192.168.2.13:50000/dp_client_apidocs/com/ecosway/dp_client/DPServicesUtils.html 

 h3. Output Parameters 

 The number of affected rows 

 h3. Code Snippets 

 <pre> 
 <code class="JAVA"> 
 Connection dbConnection = DBConnectionFactory.createDbConnection("java:/DB2DS2"); 
 TransactionResponse dpResponse = new TransactionResponse(); 
 try { 
	 dpResponse = DPServicesUtils.persistSalesCommit(dbConnection, 
				 trxId, countryCode, shopperId, 
				 trxDate, dpAmount, invoiceAmount); 
 } catch (SQLException ex) { 
	 LOGGER.error("Error in persisting the event", ex); 
 } finally { 		
	 if (dbConnection != null) { 
	    dbConnection.close(); 
	 } 
 } 
 </code> 
 </pre> 

 h2. Sales Return / Cancel Sales 

 This method is used to adjust the DP balance. 

 _This method *will only persist* the transaction details into database._ 

 _Method Signature:_ 
 <pre> 
 <code class="JAVA"> 
 public static int persistSalesReturn(java.sql.Connection connection, 
                                      java.lang.String transactionId, 
                                      java.lang.String countryCode, 
                                      java.lang.String memberId, 
                                      java.util.Date trxDate, 
                                      java.math.BigDecimal dpAmount, 
                                      java.math.BigDecimal invoiceAmount) 
                               throws java.sql.SQLException 
 </code> 
 </pre> 

 h3. Input Parameters 

 See "persistSalesReturn":http://192.168.2.13:50000/dp_client_apidocs/com/ecosway/dp_client/DPServicesUtils.html 

 h3. Output Parameters 

 The number of affected rows 

 h3. Code Snippets 

 <pre> 
 <code class="JAVA"> 
 Connection dbConnection = DBConnectionFactory.createDbConnection("java:/DB2DS2"); 
	
 TransactionResponse dpResponse = new TransactionResponse(); 

 try { 
	 dpResponse = DPServicesUtils.persistSalesReturn(dbConnection, trxId, countryCode,  
			 shopperId,trxDate, dpAmount, invoiceAmount); 	

 } catch (SQLException ex) { 
	 LOGGER.error("Error in persisting the event", ex); 
 } finally { 
	 if (dbConnection != null) { 
		 dbConnection.close(); 
	 } 
 } 
 </code> 
 </pre> 


 h2. VIP Upgrade to BO 

 This method upgrades the VIP to BO. One must utilize all of the remaining DP balance in the limited period of time. The validity period is determined by DP. 

 _This method *will only persist* the transaction details into database._ 

 _Method Signature:_ 
 <pre> 
 <code class="JAVA"> 
 public static int persistVipUpgrade(java.sql.Connection connection, 
                                     java.lang.String trxId, 
                                     java.lang.String countryCode, 
                                     java.lang.String memberName, 
                                     java.lang.String memberId, 
                                     java.lang.String newMemberId, 
                                     java.util.Date trxDate) 
                              throws java.sql.SQLException 
 </code> 
 </pre> 

 h3. Input Parameters 

 See "persistVipUpgrade":http://192.168.2.13:50000/dp_client_apidocs/com/ecosway/dp_client/DPServicesUtils.html 

 h3. Output Parameters 

 The number of affected rows 

 h3. Code Snippets 

 <pre> 
 <code class="JAVA"> 
 Connection dbConnection = DBConnectionFactory.createDbConnection("java:/DB2DS2"); 
	
 TransactionResponse dpResponse = new TransactionResponse(); 

 try { 
	 dpResponse = DPServicesUtils.persistVipUpgrade(dbConnection, trxId, countryCode, 
			 memberName, shopperId, newShopperId, trxDate); 

 } catch (SQLException ex) { 
	 LOGGER.error("Error in persisting the event", ex); 
 } finally { 
	 if (dbConnection != null) { 
		 dbConnection.close(); 
	 } 
 } 
 </code> 
 </pre>