Small Customer Management Application
5110
$$
- Posted:
- Proposals: 15
- Remote
- #23497
- Archived
Front End / Web & Mobile android ios App Developer / Responsive Web Design / WordPress Specialist / Open Source / ASP.NET using C#, VB.NET / single page apps using angular, vue.js, react, node.js etc
Mumbai
AWS EC2, RDS & S3 | NodeJs | Angular | Codeigniter | Laravel | PHP | WordPress | OpenCart | Elastic Search | Apps | MongoDB | Magento | Bootstrap | Shopify | API | JQuery | AWS CloudFront & Lambda
Chennai
Business Analyst - SQL Server and Business Intelligence Developer - Business Solution Designer - Software Architect
Rochester
672152911130367521345482456508585706033670421429804556470898
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.
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.
Brian H.
100% (3)Projects Completed
9
Freelancers worked with
6
Projects awarded
64%
Last project
18 Aug 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies