Need a software for android phones (Version 3+).
1- I got a table for customers hosted on my web site database.
2- Application should connect to it using ASMX or WCF Web service
3- The application should work offline too.
4- Customer registration form is where users enter data or load a customer to edit details.
5- Several users will enter data from several phones.
6- all customers should be available offline and when ever any change to a customer or a new customer is added, the phone should be updated if internet connection available.
7- Application got multiple forms.
8- Users must log-in to enter data.
9- User data table should be in the phone, created with a default user as - user - 123
10- User can change password after he loges in.
11- The customer should be available to another form to search.
12- That form is with one text box, when user types a part of the name, multiple column customer selection list should appear with id, name and city fields.
13- Once the user clicks a name, should fill the text box with the id field.
14- Data in customer table sync cannot be done with replication.
15- Can use a timestamp field instead.
16- customer table fields are
16-1- Company_ID - smallint(5)
16-2- device_ID - smallint(5) - this is unique id for each phone i will assign
16-3- cus_ID - bigint(19)
16-4- cus_Name - varchar (100)
16-5- cus_Route - varchar(10)
16-6- cus_Address - varchar(100)
16-7- cus_Area - varchar(20) - "this is like City"
16-8- cus_Tel - varchar(20)
16-9- cus_Fax - varchar(20)
16-10- cus_Email - varchar(50)
16-11- Valid - smallint(5)
16-12- cus_Vat - varchar(50)
16-13- cus_SVat - varchar(50)
16-14- rowguid - char(56)
17- Should be developed using IntelliJ IDEA 11 +
18- Asmx or WCF in C# or VB.NET
19- Databases Mysql for Server Sqlite for android.