I finally finished the prototype for the HomeControl barcode scanner project. I added a local database (SQLExpress) to store all the products we use or have scanned in the past. I found that some of the UPC data from Amazon and UPCdatabase was inaccurate and I needed to override the descriptions, pricing, and images if they were wrong. This ended up being a good enhancement because now I can override the descriptions and create my own images.
The UPC lookup is as follows
- Look in my local SQLExpress database
- Try Amazon if it cant be found locally and add image, ASIN, and price info
- Try UPCDatabase if it cant be found at Amazon
- Popup an option to add to UPCDatabase if it still cant be found.
(UPCDatabase will accept name and description information if the UPC does not exist in their database)
|
I added the option to increment or decrement the quantity at the time of the barcode scan. |
Added a shopping list form. |
|
|
|
|
|
Created a mobile shopping list for use with a Blackberry (i tried to create an MDS app but it was taking too long, next version maybe) |
|
|
 |