Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Basics
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 3.5 Basics If you are new to ASP or ASP.NET programming with version 3.5, this is the forum to begin asking questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old December 6th, 2008, 11:04 PM
Friend of Wrox
Points: 505, Level: 8
Points: 505, Level: 8 Points: 505, Level: 8 Points: 505, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2008
Location: , , .
Posts: 119
Thanks: 26
Thanked 0 Times in 0 Posts
Default Project doesn't update products/

I tested it with a test paypal acct. I had in products database
only 1 of a particular item. I bought it. But then when I ran project
again, it was still there. I checked the database and it had not been taken out of the products database, although it had been added to the orders database. How would I go about updating that products database? I guess there needs to be a sql statement in the project somewhere?

Rachel

  #2 (permalink)  
Old December 7th, 2008, 01:24 AM
Lee Dumond's Avatar
Wrox Author
Points: 4,942, Level: 29
Points: 4,942, Level: 29 Points: 4,942, Level: 29 Points: 4,942, Level: 29
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2008
Location: Decatur, IL, USA.
Posts: 923
Thanks: 12
Thanked 166 Times in 162 Posts
Default

There's already a method that decrements the units in stock for a product.

In the order completion page, the order is retrieved from the ID on the querystring. If the StatusID of the order is "1", then that means the order is "waiting for payment". Then, the order is marked "confirmed", and the order is updated, during which the UnitsInStock for the product should be decremented by 1.

P.S. There are actually a couple of forums dedicated to questions about TheBeerHouse:

http://p2p.wrox.com/forum.asp?FORUM_ID=261

http://forums.asp.net/1115.aspx

_________________________________

Visit my blog at http://leedumond.com
  #3 (permalink)  
Old December 7th, 2008, 01:15 PM
Friend of Wrox
Points: 505, Level: 8
Points: 505, Level: 8 Points: 505, Level: 8 Points: 505, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2008
Location: , , .
Posts: 119
Thanks: 26
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by Lee Dumond
 There's already a method that decrements the units in stock for a product.

In the order completion page, the order is retrieved from the ID on the querystring. If the StatusID of the order is "1", then that means the order is "waiting for payment". Then, the order is marked "confirmed", and the order is updated, during which the UnitsInStock for the product should be decremented by 1.

P.S. There are actually a couple of forums dedicated to questions about TheBeerHouse:

http://p2p.wrox.com/forum.asp?FORUM_ID=261

http://forums.asp.net/1115.aspx

_________________________________

Visit my blog at http://leedumond.com
Thanks. Maybe it didn't update because it wasn't showing as paid.
I'll check out those other forums. I didn't know about them. Thanks.
Rachel

 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using AJax Update Panel With Project Playlist jazzcatone ASP.NET 2.0 Professional 1 July 22nd, 2007 12:35 PM
Catalog for the products FT BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 0 May 19th, 2007 05:41 AM
How to Sell PRODUCTS in the own site? Salar Beginning PHP 1 August 3rd, 2005 02:26 PM
DataGrids Update Project not working John K. King BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 2 July 7th, 2003 04:29 PM



All times are GMT -4. The time now is 10:07 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.