ASP with Microsoft SQL database project.
Our company specializes on computer services (repairs, installation, configuration) for Business and Home users. We need this website to be able to service customer across the USA, UK, CANADA and Australia. We plan to expand to other countries as well.
The website will need to be developed with 4 types of logins need: Admin Interface, Call Center, Clients and technicians. Clients will place a service request and technicians will be assigned to the service request. Admins and Call Center will be used by employees of the company.
The standard tools are also required (password reset , username must equal the mail address of the user with ability to change email address later, signup page with validation code (alphanumeric),
This application will be available on the internet, so security is very important. A session id that expires is needed with every login.
Integration with [url removed, login to view] or Google checkout for credit card, check, PayPal authorization is needed.
Monthly automatic recurring billing is available for [url removed, login to view] and needed for some clients and Automatic service calls.
Automatic service calls (weekly, monthly) creation for clients
Sign up page for clients: First Name, Last Name, Email, Password, Confirm Password, Business Name, Billing Address, State, City, Zip Code, Tel., Fax, "How did you hear about us", Enter Service Requested, Accept Terms,
Sign up page for techs: First Name, Last Name, Email, Password, Confirm Password, Business Name, Address, State, City, Zip Code, Tel. , Cell, Fax, Service Location 1 Zip code and Weekly schedule,, Radius of miles, Service Location 2 Zip code and Weekly schedule,, Radius of miles, Notify me of new service calls on/off, Public Profile on/off, Skills/Software/Hardware add/remove from lists, Additional skills text box, Certifications/Classes, webpage, Languages, Hourly Rate, "How did you hear about us", Enter Service Requested, Accept Terms,
Client side capabilities: search for open or closed requests by request number, date range. Client pages will be Open New Call, View Open Calls, View Closed Calls, Edit User Information, Email Us, Logout
Client side Open New Call page needs to have Call Description, select, edit or add new location ( call location postal code, address1, address 2, Address 3, city, state, location contact, telephone1 with EXT, telephone 2 with EXT, email), Type of call urgency (same day < then 4 hours, 4 hours or more, next day or later) Your reference # and Automatic service calls (One time, weekly, monthly)
Technician side capabilities: search for open or closed requests by request number, date range. Pages will be Open New Call, View Open Calls, View Closed Calls, Edit User Information, Email Us, Logout. Open calls page must have the ability to receive files up to 5 MB in size. Technicians will input Appointment Date/Time and later be able to input the Arrival time and departure time with a drop down menu with 15 minutes increment of each hour and total number of minutes should be calculate to give total number of dollar amount to be paid based on service call hourly rate. A box for parts total and upload receipt is also needed. At the time of closing the call, upload a soft copy of the signed work order as well.
An invoice page is also required to report to both clients and technicians of invoices amounts for the month. For clients this page will show service calls completed that need payment(Hourly charges and parts charges listed). For technicians this page will show an invoice number will a group of completed and cancelled calls with total amount to be paid.
When a new work order is created, an email needs to be send out to technicians to reply with a hourly rate bid. The bids can only be viewed and selected by Admin Interface and Call Center users.