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. [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 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.
40 freelancers are bidding on average £1355 for this job
Hi We have read your requirements. We are interested in your project as we have indepth expertise in android app development. Please check private message board for details.
Hello, I have reviewed your project posting and believe that we will be able to assist you in your [url removed, login to view] check PMB for more details about us. Regards
Hi, HTML5, ASP.Net,MVC,HTML5,JQuery,.Net,C#,VB expert here. Please have a look at private message for my portfolio and similar work done. Looking forward to hear from you. Thanks
Hi, We have extensive work experience in iphone, android,ipad application design and development so, we can create this [url removed, login to view] more information see PMB-Thanks.