//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()); }