Allow only a single user to use Payment gateway at a time for an item buy

Question

1.00/5 (2 votes)

See more:

Hi All,

I am facing a problem in my application. It's an online shopping portal.
Problem is:
- When a customer choose an item to purchase, it's added to his wishlist. he had some problem to
make payment.
- Now he calls Customer care to purchase ahead.
- At same time he again login to application and tries to make payment.
- So there are 2 persons (Call center user and Customer) trying to make payment for same item.
- Now Call center user does it first and receive a Thank You message.
- Meanwhile Customer also reached to payment gateway and made payment.
- Therefore 2 payments have been done for the same item.
- Payment gateway is 3rd party site so we can not mandate user there.

Is there any solution to allow only the current user(who is is making payment)to proceed and lock other sessions?

Please advise.

Posted 13-Oct-13 19:29pm

chandrayog.2

Add a Solution

Comments

tanweer 14-Oct-13 1:45am

hi, let me know do you have any success message from the 3rd party after payment successfull?

chandrayog.2 14-Oct-13 1:49am

yes, we receive a success token from third party. based on that we redirect user to thankyou page or payment failed page.

Regards,
Chandra

tanweer 14-Oct-13 1:54am

then I suggest you to sore this success/failure message in your database for this transaction ID and lock it for other user to make any transaction for the same trnsaction

chandrayog.2 14-Oct-13 2:16am

Problem is that 2 users are reaching to payment portal simultaneously before the token received. til the time our application page loads, 2 payments have been done.
any other suggestions??

chandrayog.2 14-Oct-13 2:47am

yeah,i am also thinking the same but is there any other solution like using application variable, session IDs, anything where DB table not require?/

Zoltán Zörgő 14-Oct-13 1:54am

You have to implement a locking mechanism in your application.

chandrayog.2 14-Oct-13 2:13am

can you brief any method you have used in past? or any suggestions/

tanweer 14-Oct-13 2:49am

suggession is already given to you...
Create a table in your databse, now insert a record in it whenever a new transaction is made, iether successful or failure. your table will have a column named TransactionResult type of bit will store 1 for success and 0 for failure. Now add some code to check in this table before any transaction, if current transaction status is successfull then give a warning message to user.

chandrayog.2 14-Oct-13 3:10am

thanks Tanweer. i am working on a similar kind of solution as mentioned by you. i am just wondering that is there any option where no DB work is require. thanks for your help :)

tanweer 14-Oct-13 3:13am

yes, there are diffrent kind of solutions there, you may store the succss information in session, application variable or event in hidden fields also, but these are some risky tricks as storing these informations in database is more secure and in e-commerce applications you cannot take any risk.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2013-10-14T11:20:00

Unfortunately there is no magic bullet solution. You'll have to write code to see if a similar order was placed recently and then perhaps warn the user. For example, the user could purchase the item and then decide they want another one so they purchase again. That would be valid but your code wouldn't know.

Probably the best way is to have a shopping card table with an ID and when the customer service rep pays for it the shopping card is emptied and an order created. So, when the user goes back online he no longer has a valid shopping cart.