gonzalezfa (7/28/2015)
First that nothing apologies for my English.The application in the cell aims to facilitate transcription of the data and minimize manual office transcription errors when reading a form.
Our technical staff should be checked on the client each stations traps insects depending on plane and its bar code. You must get a picture, mark the amount of captured insects and fill the amount of added product.
The application must work offline because there is no cellular coverage in some basements of buildings, or they are in a rural town.
The current database is in SQL Server and you want to synchronize both ways data of Id station, type of insect, number, photo and added product quantity.
Another requirement is that a client can be visited by several technicians and on every Smartphone must download all data from the stations and at the end of each Smartphone synchronizes with SQL Server to check if all stations and that customer data are complete.
It is required to be a small handheld device, easy to use.
Thank you for your understanding and help
I think you'll be more dependent on the type of connectivity you can get. Assuming that you can use the SQL Native Client for connectivity, basic ADO code within VB,Net should allow you to create a .NET Windows Forms App that could run on the Windows phone, with menus to select which operation to perform. You'd also need some kind of local database, either SQL Server Compact Edition (I have no idea what version of that is available), or some other database that fits on a Windows phone and is reliable, and can be accessed in VB code. Whether or not it's SQL Server isn't necessarily critical, and given that you need to store photos, you need a database that's capable of at least storing a file system path and filename, if not the photo itself, although be careful, as photos taken by the user, even of an insect, can be several megabytes in size, which could be problematic if kept in the database... you may be better off standardizing the photo for a given insect and including any updates to the "standard list" as part of the synch process. Does any of that help?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)