This project is to develop create a web application using the Microsoft web stack (ASP.NET MVC4, IIS, and SQL Server) based on the attached specifications.
PDQ Track Project
The goal of this project is to create a web application that will allow organizations to track the training and competencies of their employees.
This application is to be developed using ASP.NET MVC 4 Release Candidate running on the Microsoft Stack (IIS, SQL Server, Windows Server).
Desktop Browsers: test against (and support) the latest versions of Chrome, Firefox, Safari, Opera, and IE8, IE9 and IE10.
Database Structure Requirements
The database should be developed so that the data consistency is guaranteed by the RDBMS itself (i.e. use foreign keys) with cascading deletes. Typically the cascading deletes are accomplished using INSTEAD OF triggers to avoid issues with circular references when using the cascading deletes feature built into SQL Server.
The spec calls for a RESTful URL structure that is built around the entities found in the database.
This application will use forms authentication and will authenticate its users against the data contained in the “Login” table. Form a security viewpoint there are seven security states that must be considered when (or before) displaying a page:
Anonymous users (can only login, create accounts)
Authenticated Users who do not belong to the organization that owns the data being accessed
Authenticated Users who do belong to the organization that owns the data being accessed
Authenticated Users who do belong to the organization that owns the data being accessed and is a Training Assistant (role).
Authenticated Users who do belong to the organization that owns the data being accessed and is a Training Coordinator (role).
Authenticated Users who do belong to the organization that owns the data being accessed and is the supervisor of the worker whose data is being looked at/edited.
Site Admin - Admin (bool) set to true in the login table.
Notes about per-page security are found in square brackets on the Database and URLs document in the attached zip file.
Typical Activities for “normal” Workers:
Review their competency gaps. Gaps are the difference between the competencies they currently have and the competencies their current (or prospective) positions require.
Register themselves for training.
Review the competency gaps of workers who report to them (see the [url removed, login to view] field in the database model) and register them for training.
Typical Activities for Training Assistants:
All of the above plus ...
Creating Training Unit Registrations for Workers
Create Scheduled Courses
Confirm Scheduled Course registrations
Typical Activities for Training Coordinators:
All of the above plus ...
Create Training Units
Create/Manage Training Matrices
Technical Specification Document
I put together a technical specification document by modeling the data entities as they should look in a 3rd normal form database (see the Tables section), and then listing the URLs for the different pages that describe the different data entities (see the URLs section), and then listing the different forms and the data on each form (see the URLs & Data) section. This should provide a good foundation to help you determine the scope of this project.
In addition, there is a PDF that includes wireframes of all the different URLs.
Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.
19 freelancers are bidding on average $749 for this job
I have 10+ years of experience in web development. Confident in HTML, Classic ASP, ASP.NET, Microsoft SQL Server, PHP, MySQL, iOS (iPhone/iPad), and SQLite.
Web for training and competencies of employees using MVC4 and c# I am working on MVC3 for more then 4 months... and also working on MVC 4 I can give you the best result you want.