how to do manage add cart same product for multiple user at same time ?

Question

3.00/5 (2 votes)

See more:

hello all ,

I am working on add to cart module .I have one product that have only one Product Quantity, and that product have quantity 1 so two person can not buy that product. at the time of AddToCart I have reduced the quantity from the database.

I have a question:

how to do manage same product for multiple user at same time ?
please suggest me how to do this .

Posted 16-Jul-15 20:16pm

manvendra patel

Add a Solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-07-16T22:31:00

You need to use TRANSACTION in the query which inserts the order details in the database.

While adding to the cart, you cannot determine whether any other user has added it or not, if the time is same. While placing the order, your query will allow only one transaction and after the completion of that it will process another request.

So, when both request will hit the database, one will go through first. Then when second goes, you should have a check inside the query to see if there is any quantity left for the product or not. If there is any left, then allow insert, otherwise not and show message to user that the product is not available at this moment.