To take a Visual Studio 2005 Solution for an application which manages three master tables, country, province and city. The solution only has a form with buttons, text boxes , so it needs functionality for the buttons, ADO connections and a pop up find window to allow for basic searches of countries, provinces or cities.
It also requires a printable report in Crystal reports which should list all countries, provinces and cities. The format of this report as well as the search form are up to the developer.
SQL source for database is included.
Here is a review of the buttons:
New - Creates New Country, then disable button.
Open - Make active on entering a County code into the Country Code text box, then allow for opening a single country record from database.
Save - Saves all changes to Country Name, Country Memo, any new Provinces Added or Edited, and any new Cities Added or Edited.
Delete - Delete Country (with "are you sure") and cascade deletes all provinces and cities
Print - Prints Current country with it's provinces and Cities
Close - Close Window (Please disable standard OS Close, minimize buttons)
Find - should bring up a search screen with three text boxes: Country, Province, City. When search results are double clicked, it should display the country found.
1) Ready to complile source code and solution files.
2) 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).
Windows 2000, .net 2.0