This bid request requires some one who is knowledgeable and experienced with **ASP**, and is familiar with **MS SQL**. A database needs to be built and *integrated* into our web site. 3 sections are needed for Clients, Members, and Admin login; uniquely user/password protected. (see below) Approx. 25 queries or back end processing (and some site pages) are required to be built. Please note: Web site is created in and uploaded using MS Frontpage.
_Clients
_1) Create user account
2) Edit user account info
3) Review shop results
4) List all shops defined for this client
_Members_
1) Create user account
2) Edit user account info
3) View all shop opportunities (list)
4) View a shop's details
5) Apply for shop
6) List of 'Applied for' shops
7) List of 'Assigned' shops
8) View 'Assigned' shop details
9) Complete/Submit results of 'Assigned' shop
10) View special notes
_Admin_
1) User Administration
2) List all shops
3) Review list of pending (shop) assignments
4) List Shop Applicants (by shop/assignment)
5) Assign Shop
6) List Completed Shops pending review
7) Edit Member Shop Feedback & Approve
8) List Overdue Shops
9) Create/Modify Special Notes
10) View/Modify/Remove Members and/or Clients
**_General_**
1) Login Page
2) Logoff
Site pages still needing to be created are nothing fancy and only need our header/logo and navigation links. To view a sample page, please visit [[login to view URL]][1]
## 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).
## Platform
All 3.0+ versions of Internet Explorer, Netscape, Mozilla
Database: Microsoft SQL
ASP/html only