Last post Jan 29, 2014 04:01 PM by indyitman
Oct 28, 2013 10:44 AM|indyitman|LINK
I have an MVC4 app that is an employee orientation/training app, but it is a personalized approach. Typical scenario: user (employee) starts work in a specific branch of our company, in a specific role. The user will be assigned an orientation/training
Template for their specific branch and role.
Each orientation Template consists of Modules (Welcome, Benefits, Safety, Hazmat, etc.).
Each Module consists of Components (PowerPoint Slides with Audio, Videos, Online Forms, Online Quizzes).
Both Modules and Components can be in customized order depending on the User and Template ( one User may need Hazmat, another may not, and some Benefits may be different for Users on salary vs hourly, etc.).
New Templates, Modules and Components can be added through an Admin Manager & Dashboard.
The trick is, each entire User orientation/training experience needs persisted in SQL Server, and tracked for both the User and Admin with Progress Bars. If we lose power or something, each User can start where they left off, and the Admin can monitor their
I need to set, count and loop through all the content specific to each User, and a typical orientation/training has more than 150 components. I set up partial views for the Components (one for PowerPointSlide/Audio, one for Video, one for a Quiz, etc.),
with the intent of using Ajax.ActionLink to load components depending on their sequence and content type.
So I was wondering - is there is a way to use XML or JSON to store a User's Admin-assigned Template/Module/Component stream and still log progress?
How should I use Sessions throughout?
Here a sample XML I typed up for illustration:
<TemplateName>New Maintenance Trainee</TemplateName>
<QuestionText>When lifting, always bend at the:</QuestionText>
Oct 30, 2013 12:03 AM|css-chlukito|LINK
You mean you want to replace SQL Server with XML or JSON?
If that the case then you can add another field on XML file that track the progress.
Oct 30, 2013 08:36 AM|indyitman|LINK
Actually, what I had in mind is: writing each user's orientation/training component sequence to a read-only XML file, reading it sequentially to populate the views, then using SQL to log the user clicking "Next" through each component, record quiz answer
Jan 29, 2014 04:01 PM|indyitman|LINK
Just to put this issue to bed (I prefer no question left unanswered): I ended up going ahead and using SQL Server Session State - working great.