We need the source code
We want lots of relevant comments in the code
Everything (code variable names, function names, comments, documentation, etc) in English
We want a simple application. Nothing complex. Two screens with database. Database is read only
Runs on 7 inch Samsung Galaxy Tab and Android phones
Target Android OS 2.2 (or 2.3?) something that most existing Android tablets can run. You dont need the latest and greatest Android device.
We give you SQL Server database, or CSV file, with the two data tables
Data Table 1: Event Information – will contain one record with columns:
EventID, Event Name, Date and time of Event
Data Table 2: Seat / color information – will contain many records – one record for each seat. Columns are:
EventID, Section, Row, Seat, Color
Source data tables are coming from SQL Server. You have to give us a way to convert from SQL Server database to some database that runs on Android (SQL Lite?). We can export CSV file, Excel, etc from SQL Server.
We need written instructions on how to convert the data (from SQL Server to an Android database), and load the application and database on to Android devices
Screen one is basically a splash screen, except we will not move away from screen until user presses a button. Screen will display our logo, application name, Event Name, Event date and time, and has one button to allow the user to go to the other screen
Display the two fields from the first data table (Event Name and Date of Event) in two lines at top of screen. These are read only on this screen
User enters section on third line, row on fourth line, starting seat on fifth line, and ending seat on sixth line.
When the user enters the starting seat – automatically populate the ending seat – so that the ending seat is the same as the starting seat – there is only one seat
The user may, or may not, change the ending seat
User clicks submit button
You go into database, lookup the color for the given section, row, and seat. Display the color on the screen
If ending seat is not the same as starting seat, then display the color for each seat from starting seat to ending seat
Back button will go back to opening screen