//My Progress Page (UntypedViewEmployee)
public ActionResult UntypedViewEmployee(int?id)
{
LMSFinalEntities1 db = new LMSFinalEntities1();
Lesson lesson = db.Lessons.Find(id);
string userID = User.Identity.GetUserId();
//Courses completed by currently logged in user
var empCourse = db.CourseCompletions.Where(oc => oc.UserId == userID);
//Lessons completed by currently logged in user
var empLess = db.LessonViews.Where(oc => oc.UserId == userID);
//All Active Courses so Employees can keep track of what still needs to be completed
var empnoCourse = db.Courses.Where(en => en.CourseId != null && en.IsActive == true);
ViewBag.EmpLess = empLess;
ViewBag.EmpCourse = empCourse;
ViewBag.EmpNoCourse = empnoCourse;
return(View());
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
//var code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
//var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
//await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking this link: <a href=\"" + callbackUrl + "\">link</a>");
//ViewBag.Link = callbackUrl;
//return View("DisplayEmail");
#region Dealing with custom user details
UserDetail newUserDeets = new UserDetail();
newUserDeets.UserId = user.Id;
newUserDeets.FirstName = model.FirstName;
newUserDeets.LastName = model.LastName;
/* newUserDeets.ResumeFile = model.ResumeFile;*///--TODO: handle file upload
LMSFinalEntities1 db = new LMSFinalEntities1(); db.UserDetails.Add(newUserDeets); db.SaveChanges();
#endregion
return(View("Login")); //Forgot this
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
//****************LESSON COMPLETE DOMINO EFFECT*******************
public ActionResult LessonComplete(int id) //called line 80 in LessonIndex
{
LMSFinalEntities1 db = new LMSFinalEntities1();
Lesson lesson = db.Lessons.Find(id);
string userID = User.Identity.GetUserId();
if (User.IsInRole("Employee"))
{
var viewedlessons = db.LessonViews.Where(l => l.UserId == userID);
bool hasviewed = false;
foreach (var Lessonitem in viewedlessons)
{
if (id == Lessonitem.LessonId)
{
hasviewed = true;
}
}
if (hasviewed == false)
{
LessonView lv = new LessonView();
lv.DateViewed = DateTime.Now;
lv.UserId = userID;
lv.LessonId = lesson.LessonId;
db.LessonViews.Add(lv);
db.SaveChanges();
}
//**************CourseCompletion*******************
var coursecompleted = db.CourseCompletions.Where(cou => cou.UserId == userID);
//bool for checking if all lessons done
bool coursecomplete = false;
//variable to find total number of lessons related to specific course
var totallesson = db.Lessons.Where(cl => cl.CourseId == lesson.CourseId).Count();
//variable to grab each LessonID related to course
var courselesson = db.Lessons.Where(cl => cl.CourseId == lesson.CourseId).Select(l => l.LessonId);
//variable that keeps count of employee-viewed lessons // If this equals totallesson, Create CC
var employeeviewedlessons = 0;
foreach (var lessonview in db.LessonViews.Where(l => l.UserId == userID))
{
foreach (var lessonitem in courselesson)
{
if (lessonview.LessonId == lessonitem)
{
employeeviewedlessons++;
}
}
}
foreach (var comp in coursecompleted)
{
if (comp.CourseId == lesson.CourseId)
{
coursecomplete = true;
}
}
if (employeeviewedlessons == totallesson && coursecomplete == false)
{
CourseCompletion cc = new CourseCompletion();
cc.DateCompleted = DateTime.Now;
cc.UserId = userID;
//cc.CourseCompletionId = id;
cc.CourseId = lesson.CourseId;
db.CourseCompletions.Add(cc);
db.SaveChanges();
//Emails to inform Manager of single Course Completion
MailMessage msg = new MailMessage(
"*****@*****.**",
"*****@*****.**",
"A.L.L.O user " + User.Identity.Name + " has completed a course!",
"A.L.L.O user " + User.Identity.Name + " has completed a course! Visit Employee Status page for details.");
msg.IsBodyHtml = true;
msg.Priority = MailPriority.High;
SmtpClient client = new SmtpClient("mail.lancevogel.com");
client.Credentials = new NetworkCredential("*****@*****.**", "Turtle333!");
client.Port = 8889;
try
{
client.Send(msg);
}
catch (System.Exception ex)
{
ViewBag.ErrorMessage = "There was a problem . . . </br>" + ex.StackTrace;
return(View("Index"));
}
}
//When the UserIds in CourseCompletion that match current logged in userId = 6, email annual.
var trainingsDone = db.CourseCompletions.Count(oo => oo.UserId == userID);
if (trainingsDone == 6)
{
MailMessage msg = new MailMessage(
"*****@*****.**",
"*****@*****.**",
"A.L.L.O user " + User.Identity.Name + " has completed training!",
"A.L.L.O user " + User.Identity.Name + " has completed their Annual training! Visit Employee Status page for details.");
msg.IsBodyHtml = true;
msg.Priority = MailPriority.High;
SmtpClient client = new SmtpClient("mail.lancevogel.com");
client.Credentials = new NetworkCredential("*****@*****.**", "Turtle333!");
client.Port = 8889;
try
{
client.Send(msg);
}
catch (System.Exception ex)
{
ViewBag.ErrorMessage = "There was a problem . . . </br>" + ex.StackTrace;
return(View("Index"));
}
}
return(RedirectToAction("Index"));
}//END OF BIG FUNCTION
return(View());
}
