I am facing an issue in gridview calculations ie-
I,have created a shopping chart in which there are 4 columns in grid- Product Price,Product discounted Price, Free shipping and Shipping Cost.
I,want to set calculations in such a way that if product discounted price is equal or greater than free-shipping price then shipping cost should be 0.
But i want to set these 3 conditions also ie-
*If by default product is put in cart and user view cart then if product discounted price is already greater or equal to free shipping then shipping cost will be 0
*if user increase quantity of product and if its equal or greater to free shipping price then shipping cost will be 0
*if user purchases multiple products from same Store then if discounted product price is equal or greater to free shipping price then shipping cost will be -
Gridview data is being maintained at session level and not at database level,ie if user sessiontimeout or logout then user need to again put products in cart.
Only those products related to each individual store prices should get updated and to all products in the cart,because user can purchase multiple products from multiple stores having their own set free shipping price and product discounted price and shipping cost. so wouldnt require sum total of gridview in this scenario.
Looking for a good response and a good code writeup in c# and asp.net and let me know the same.