I need a small system developed for our Mobile Phone repair Shop.
This system should be developed using .net and sql server.
Database tables and fields can be found in the database attached. Also there is a flow diagram describing how the process should flow.
In a search results page; if the technician has searched by repair number then the page should show client details and repair details.
If the technician has searched by client surname then the page should show client details and all their repair numbers beneath their name.
The system also needs reports so technicians can see which repairs have been completed, booked in, customer contacted etc.
There may be a time in the future when this application would be connected to a webservice which will allow the technician to select all the completed repairs and the system would send an sms to the client letting them know that their repair is ready - THIS IS FUTURE DEVELOPMENT...
Any questions please let me know.