Android App using Phone Gap and HTML5 offline data. - repost

The project is to develop a small mobile app to do the following: 1. Connect to a WCF service using jaydata (or similar). 2. Store data locally in websql database (or similar). 3. Provide a form to allow a list of products to be compiled and submit as a project costing transaction (eg. similar to creating a purchase order). 4. When connected to the internet again, submit to the backend (via WCF). This app contains 2 forms: 1. Login (we need a strategy for handling login/off while disconnected from internet). 2. Project "list of products" form. Product Table: ProductID ProductName Project Table: ProjectID ProjectName SyncStatus (to indicate if posted to backend) ProjectItem Table: ProjectTableID ProjectID ProductID Quantity