ASP.NET4 Web Application - SQl 2008 - Editing - LMS - UI - Secure Content Subscriptions

We have an existing functional ASP.Net Web Delivery Interface for Online Training which provides online Lessons and Videos. The current editing interface for the SQL2008R2 database is ASP. The current delivery interface is [login to view URL] Web App. There are 3 schemas that provide the building blocks for the project, with only 150 or so records that require migration. This is detailed later. The system needs to be converted completely to [login to view URL] Editing environment with auditing and security for multiple external editors. The system needs to include subscriptions for teachers and students. The subscription management system is paypal, but data needs to be dynamically updated to my server which controls user access. External Teachers may use the content to deliver courses and enrol their students. ## Deliverables Currently 3 Schemas exist of which two are fully functional. One schema and application provides video navigation and display whereas the other is designed for lessons and export of complete training course content in multiple file formats. These are fully function [login to view URL] Telerik AJAX C# Web Apps. Security for All Apps is ASP.NET membership using the WSAT interface. The 3rd Schema is designed to centralise all information into one, max two tables with various views to extract the data. In the 3rd Schema data is managed hierarchically using the one table to supply Parent/Child lookups as well as content. Video and Image files are stored in folders to reduce database load. The Schemas of existing apps need to be merged to achieve the outcome of minimal footprint, speed, efficiency and robust design. Scipts need to be written to migrate existing data from the other 2 schemas. The system delivers either complete structured courses or individual lessons in response to user requests. Subscription management (including payments) secures course content and other non-public lessons. Trainers or Students may apply for Subscriptions so they can access course content or lesson resources. A basic payment system has been developed to demonstrate the basic requirement for Users only. Trainers pay to use the course material and subscribe their students. Individual users or companies pay for subscriptions for different courses via Paypal which maintains subscription information and automated reminders. All subscriptions need to be transferred or updated on payment to my SQL server. The information on my server then controls access to content and resources. The Training component enables Trainers to register themselves and students against a course. The system records user activity by course as a record for the trainer. The users can conduct basic online exams (multiple choice) which stores against their name. Once they have completed/passed the section of the course they can proceed to the next section. This component may include SCORM LMS compatability for standards management. The current UI is basic and needs to have improved dynamic global user filtering to ensure content and resources are accessible by the role authorised user or subscriber. I would prefer the UI to be developed using JQuery (else AJAX/Telerik) based on popular design and delivery methods to improve the user and editor experience. The overall goal is to streamline the existing system making it easier for editors to update 'live' lessons, whilst subscribers have a common-sensed, intuitively designed modern delivery interfaces. Primary objectives are to reduce the overall footprint to as small as possible in database and web application areas. The exact opposite of modern payment and CMS systems. Welcome filetypes and languages include ASPX/ASCX, CSS, XML, Jquery. Further information on this project will be supplied on request from 17th July.