We are looking for some help with a custom, in house application that has a database structure, but needs some logic built into? the triggers/event in database. The database is to have 2 front ends, a normal desktop client and a windows mobile client for the on call engineer.
The aim of the application is primarily for job and parts/stock managament, but auxillary business processes could be added later (mostly financials)
Preferably programmed in? VB.NET (2008).
Server is MS SQL 2005. A 2003? exchange Server is available to integrate.
Generally this is a typical workflow application, we are open to suggestions as to other technologies which will enhance, but not replace the techonolgies descibed.
The work flow generally follows this process (some feature of interest in brackets):
An engineer call is booked
Engineer attends site (diary, booking and reports involved)
Parts used (stock control)
Customer sign off (bitmap capture)
Invoice or details for invoice (reporting)
We have a prototype database structure, which may or may not be used.
Finally, as mentioned before, it would be desirable to have as much code server side as possible/sensible to eliminate duplication in the two clients (mobile & office)
Server OS: windows 2003
Client OS: XP & WM 6 / 6.1 (the touchscreen version)