This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have following question regarding credit card processing.. 1. You want to deliver PIN number when credit card is valid & deduct your inventory of PIN accordingly. I mean credit card validation is done by someone else & how you will update customer account for order info & deduct your inventory? a. Client disconnected before we can update our inventory database but credit card is valid & charged. What we should do to avoid this situation or store something in database for temp transaction & look at that data if above situation occur. b. If everything is good like you get YES from card validation take out that product from inventory & enter order info to user account. All done IN database MySQL. I know many card processing agency provide API & reply which indicate CC validation. If someone can give me idea about first problem that will be great. Thank you