Window Measuring App - Convert [url removed, login to view] web application to an Android app
This project was successfully completed by technotrust for £1159 GBP in 20 days.Get free quotes for a project like this
Project Budget£750 - £1500 GBP
Completed In20 days
We have a working web application written in [url removed, login to view] (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 [url removed, login to view] 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. [url removed, login to view] is the main list of jobs, [url removed, login to view] is the window list, [url removed, login to view] is the measurements page. [url removed, login to view] is the address edit page, while [url removed, login to view] and [url removed, login to view] are obvious.
The web app uses third party [url removed, login to view] controls from Infragistics and certain external function libraries for data access which you probably don't need details about to create the Android app.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online