This is piece 1 of a 2 part project. It is strongly encouraged that you bid on the other piece, but only if you can deliver the entire application within three weeks.
The entire project is an ad management and display system. You will be provided the database script and diagram to use (see attached files). The entire project will consist of using Visual Studio 2005, .Net 2.0, SQL Server 2005, web services, custom controls and written in Visual Basic. Note that each part will not require everything listed.
Part 1 requirements: SQL Server 2005, Visual Studio 2005, written in Visual Basic
You will be creating an internal application that will manage the data entry portion of the ad management system. The three tables you will concern yourself with (see attached database scripts and diagram) is the Customer, Campaign, and Ad tables. The application should consist of only one form. I should be presented with drop down boxes for the Customer and Campaign fields. I should be able to use an open file dialog box to find the graphic I want imported into the database. Once imported it should detect the size of the graphic and fill it in appropriately. All the fields in the ad table should be viewable. All the fields except the ad_id, ad_height, and ad_width should be editable with the appropriate easy to use controls.
Since this is an internal application, exceptions can be made in exchange for the price. All code is to be well commented. It is to be fully tested by you, and only validation by me will be done.
See attached files for more information.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) 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).
4) Well commented code
5) Fully tested by you and will have as few bugs as humanly possible
6) All tasks laid out in the description and attached files completed unless otherwise stated in messages left on the RAC website
## Platform
Visual Studio 2005
Visual Basic
SQL Server 2005
Web Services
Stored Procedures