We have a working web application written in ASP.NET (VB) and accessing a SQL Server database on our web server.
The web app is used on smartphones by curtain and blind fitters to record measurements of the windows and doors in various houses. AT the present time the web application works OK, but loss of 3G data connections is causing loss of data.
We want an Android app that will have the same facilities and screens but which will download data from the remote SQL Server at the start of each day - when the Android device has a good Wi-Fi or 3G connection.
During the day the measurements for each property will be entered and then uploaded back to the SQL Server at the end of the day, when the data connection is good.
The screens required can be seen at www.drapesweb.co.uk. Interested bidders can login to the site using:
Username : geofffitter
This brings up a list of measuring jobs for the day. Click 'Measure' on one and it opens a list of windows to be measured. Click 'Measure' against a window and it opens the measuring page for that window.
This contains various bits of header information and a central area in which a list of items appears.
There are also extra pages for editing the address of a property, viewing plans of the property, and adding a new window.
The Android app will not need a login screen, but instead it will need a settings screen into which the login name and password of the fitter and the connection string to the SQL Server database can be saved on the device and then edited if required later on. It will also need a download and upload facility to transfer the data to and from the SQL Server database.
The data to be downloaded each day will include:
Data for the fitter from 3 database tables on the SQL Server.
1. The details of each job (Job No., Customer, Plot, Time, Address, Contact, Tel and Notes)
2. The details of each window within each job (Window No., Room, Items and Measurement Fields)
3. The Width and Drop dimensions for each item to be hung at the window (shown in the Finished Size area)
Also details of Window Types will need downloading to a local database table (these appear in the drop down against Choose the Type of Window on the Add a window page).
One or two image files will also need downloading from the remote server to be displayed in the Plans page. At the moment these are either JPG or PDF files (the plans page includes a PDF Viewer control). If PDF is difficult to display within the Android app we can make them all JPG images.
The web pages currently have some ASP.NET code behind to do checks on valid entries and prevent the 'Confirmed' checkbox being checked until all the measurements are entered or the fitter checks either the Not Measuring this Window or the No Window Exists checkboxes. I have uploaded the relevant code behind files, with a few vb class files that contain relevant code. Default.aspx is the main list of jobs, VisitItems.aspx is the window list, Measure.aspx is the measurements page. EditJob.aspx is the address edit page, while Plan.aspx and NewWindow.aspx are obvious.
The web app uses third party asp.net controls from Infragistics and certain external function libraries for data access which you probably don't need details about to create the Android app.