Small Customer Management Application

  • Posted
  • Proposals 15
  • Remote
  • #23497
  • Archived
Pompy K.Janarthanan V.Rahul P.HireIndianProgrammers H.Sania A. + 10 others have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Small Customer Management Application

Application to be developed in Visual Studio 2008, .NET3.5 & C using SQL Express 2005 for storage of data.

Database

Companies to contain: ID (Int, Primary Key), Name of Organisation, Nature of Business, Address 1, Address 2, Town, Post Code, No of Employees

Contacts to contain: ID (Int, Primary Key), Name, Job Title, Company ID (Int, Linked to Companies table), Daytime Phone No., Mobile Phone No., email address, Contact Type (Enumerated - Operations/IT/Admin/Accounts), Date of initial enquiry (Small Date Time), Source of enquiry (Enumerated Google/Yahoo/MSN/Referral/Other), Comments, Personal Notes,

Demos to contain: ID (Int, Primary Key), Date of demo (Small Date Time), Company (Int, linked to Companies Table), Contact (Int, linked to Contacts Table), Price Quoted, Quote Supplied (Quote Reference with ability to upload file), Contact (Int, linked to Contacts table), Background, Developments, Next Steps

Installations to contain: ID (Int, Primary Key), Install or Upgrade (Enumerated),Superseded By (Int, Link to other record in this table), Date of Install/Upgrade (Small Date Time), Performed By (Int, Linked to Users table),Operations Contact (Int, Linked to Contacts Table), IT Contact (Int, Linked to Contacts Table),Server OS & Version, Database Version, Database Name, sa password, Installed Version, DNS Details, Installation Notes

Users to contain: ID (Int, Primary Key), Name, Telephone No., email address

If not specified field to be nvarchar.

Application

Main login page Username/Password/Password Reminder

Master Page Banner Graphic across the top & menu down left hand Side to contain:
Add Company
Add Contact
Add Demo
Add Installation
Add Upgrade
Review Demos
Review Installations

Add Company Page, Provide Form to add details to Companies table

Add Contact Page, Provide Form to add details to Contact table, with company selected from drop down

Add Demo Page, Provide form to add details to Demo table with Company & Contact details selected from drop down

Add Installation Page, Provide form to add details to Installation table with Company & Contact details selected from drop down.

Add Upgrade Page, Provide list of existing installs, select an existing install, copy record, Record as Upgrade, Upgrade source record to show what record supersedes it, and provide form for editing data.

Review Demos Page, Provide an index of Demos, clickable to select, view and update a record using a suitable form. With a facility to sort by customer or date.

Review Installations, Provide an index of Installations (Showing only the most recent entry for a customer), clickable to select, view and update a record using a suitable form. With a facility to sort by Customer, Date or Installed Version.

All date field to use date pickers. All controls to be standard .NET3.5 or Ajax controls where possible.

Project deliverables to include all source code and Intellectual Property Rights including Copyright.

Clarification Board

    There are no clarification messages.