Cleaning up publishing/subscribing database application

Project: Aeriandi Satalite Skill and Software requierments: c# .net v1.1 Access Sql Server Freelancer will be supplied with: Access to our server’s web services. Document describing the web services. Object models and descriptions of main objects used. Function list and explanations. Examples. Code in a working state. Phone and Email support between 9am-7pm GMT mon-fri should you have queries. We hold client data in a complex database (SQL server) on our servers. To make life easier for our clients and our reporting staff we have created a publishing service and client subscribing application that transmits client data across https from our servers to theirs and stored in a much more simplified database with only the clients data in. The client application is in a working state but needs some finishing off and cleaning up. The project is to do just this, I have 10 tasks detailing interface and extra extended functionality needed . The App consists of 3 forms and less than 3000 lines of code (half of witch you will not have to look at). Basic Description of the app: The app communicates with a set of web services on our server. When the client logs in they are presented with a list of sessions. Session represents a subscription (or synchronisation) between our server database and the client’s database. Clients may have many sessions each synchronising one of the many databases we hold for them. The client can add or edit sessions. The configuration data for the sessions is held locally on a file. The configurations of the session contain: a) Which publication (data base of ours) they need (only one per session/subscription) b) Which tables they need from that database c) Where they want the data to be stored (either a accesses file or a sql database) After configuring a session, the app will keep the client database in sync with our data base. We have lots more work including full projects that could lead from a good completion of this work. ## Deliverables More details will be given after acceptance of this project but in basic the tasks are: 1) The user interface is very simple but messy at the moment. There is a screen shot of each screen uploaded with this document showing each screen in the app. The user selects an existing session from a list to edit or creates a new one, they then go to a form with a tab Control where you can edit/add different options in different tabs. This form needs to be changed to a wizard style interface where you have 1 form and 3 user controls with a next, back and finish buttons at the bottom witch become enabled after user has made the required selections. 2) The tab 'Data Destination' is not on the screen shot because it has not been made yet. You will need to make this page. It is an interface to obtain the following: a) Whether the data is going to be saved in an access or sql server db. b) If access option is selected then we need to obtain the path, any username and password of the file with a brows window to select the file or make a new one (At the moment we just use a hard coded path for all sessions). c) If Sql server is selected then we need a simple interface to make the connection string. - If it could search for the servers and offer them as a list (like logging in to query analyser) that would be a bonus. 3) All our software that is released to clients has to follow a basic company design style with is obtained by using some software called dot net bar - basically means replacing the standard interface components for the dot net bar ones and selecting the right colours. Examples will be given. 4) At the moment the client data is save to access files only, It needs to work for a SQL Server database as well, code has been written to do this but has not been tested so it might have to be played with a bit or the function that outputs to access upgraded to work for sql server as well. 5) At the moment when adding a new session the user select what tables they want in it form a list box with check boxes in it. Another option is to be added that is a ‘select all’ option. If this option is check all tables will be checked and the selection box greyed out. Further to this any new tables that become available at a later date will also be checked. Therefore the web service that supplies the table list will have to be periodically checked for new tables and new tables automatically added. 6) One of the forms shows a list of sessions that the client is subscribed to. The Application goes through each session and checks for updates. If there are no updates then the text in the list box should to change to green. If there were updated then text should be changed to orange. And if there was an error during the process of receiving or updating the client database then the text should be coloured red. 7) Errors trapped should be reported to the Event handler under the heading [login to view URL] ??" They currently are not. 8) There needs to be a special option in the app for internal use. The option will do the following: 1) Download a list from a web service (already made) of a list of usernames passwords and connection strings. 2) Instead of showing just a clients sessions it will use the web service list to show all sessions for all the clients in the list. Instead of just keeping one session up-to-date it will keep them all up to date. 3) There is a web service that shows all the publications available for a client, this should be periodically checked and if there becomes a new publication available the app should automatically make a new session for that publication with the ‘all tables’ option selected. 9) An installer needs to be made for the app. 10) Ideally I would like the application to be converted in to a windows service and a configuration tool but not essential if it is too much hassle 11) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 12) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows with .net v1.1 or 2