1 / 18

Cross Platform Web Based Home Inventory System

Cross Platform Web Based Home Inventory System. Project Team: Jon Garibay , Firas Assaad Faculty Advisor: Dr . Lawrence Thomas. Presentation Agenda. Background information Database Web Service Web Site Android Application. Background.

dahlia
Download Presentation

Cross Platform Web Based Home Inventory System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Cross Platform Web Based Home Inventory System Project Team: Jon Garibay, FirasAssaad Faculty Advisor: Dr. Lawrence Thomas

  2. Presentation Agenda • Background information • Database • Web Service • Web Site • Android Application

  3. Background • Shopping for home consumables is a very time consuming task • In order to make informed decisions while in the store, individuals must know what items they currently have • Needed a solution that was robust and mobile

  4. Background • Designed a home inventory system that is available via web page or Android application • Design effort included Database, API, web application, web service, and Android application

  5. Database Database API Web Service Website High Level Application Architecture Internet Android Application Client Browsers High Level Architecture Server

  6. Database • Microsoft SQL Server 2008 • Table Relationships and Indexing

  7. Web Service • Custom-tailored • TCP Communication • XML Technology • Unified Database Communication

  8. Web Service Flow

  9. Web Site • Admin Side • Manage System • Manage Admin Users • Manage Houses • Client Side • Manage House • Perform Inventory • SMS alerts for low items • Tablet Side • Perform Inventory

  10. Web Site Flow

  11. Android Application Goals • The Android application needed to recreate the functionality of the web application but optimized for the Android smart phone platform. • Needed to be able to scan objects into the inventory for quick data entry

  12. Android Program Flow

  13. Viewing Inventory

  14. Scanning Items (Add Scan) Search for Product name In Database? No Yes Increment Item

  15. Communications • Android application uses TCP connection to connect to web service • Communicates using XML messages • Single class handles web service communication

  16. Future Plans • Move server to a Virtual Private Server (VPS) • Create shopping list prediction engine using product usage data • Rework UI of web site to show a more visual representation of a house and allow for drag and drop interaction. • Creation of a discrete bar code scanner and tablet combination for use in high traffic areas • Geo Reminders

More Related