Area Code Utility
This is a simple utility that allows a web user to look up an area code for a particular location or, given the area code, a location. This utility will be similar in functionality to [login to view URL]
Non Functional Requirements
I need this to be written in ASP.NET ??" prefer C# but VB is OK as well
Hosted on Win2003 web edition server, .NET 1.1, IIS 6.0
Data stored in Access Database
Functional Requirements
Accessible via form input, query string, or web service
Add two digit state/province name abbreviation to access database
Area Code Data is stored in an MS Access database (attached)
Must be able to send request via a Query String or via the form ?area=312 or area=IL
Detect whether input is valid ??" either a state abbreviation, location name, or a valid area code. If not, display an error message specific to the error - “Area code not recognized?? if a numeric or “location not recognized?? if alpha or alpha/numeric.
Allow for case insensitive search.
Create a database table to the access database that logs each entry ??" date/time, requesting IP, value of entry
Use Cases:
1) User submits an area code (via form, query string, or web service) and is returned the location of that area code
2) User submits a location name (via form, query string, or web service) and is returned the area code/s of that location
3) User submits a state name abbreviation (via form, query string, or web service) and is returned the area code/s of that location
Deliverable:
ASP.NET project file and Web Service Project file
All source code.
Comments for installation
Updated Access Database file
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) 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
ASP.NET ??" prefer C# but VB is OK as well
Hosted on Win2003 web edition server, .NET 1.1, IIS 6.0
Data stored in Access Database