public ActionResult MyCourses() { if (Session["Cliente"] == null) { return(RedirectToAction("login", "Home", new { area = "" })); } var user = Convert.ToInt32(Session["Cliente"]); Digital_LearningEntities entities = new Digital_LearningEntities(); List <UserEnrollInCourse> clientes = entities.UserEnrollInCourses.ToList(); List <Course> course = entities.Courses.ToList(); List <Status> status = entities.Status.ToList(); var query = from c in clientes join cou in course on c.CourseId equals cou.courseId into table1 from cou in table1.DefaultIfEmpty() where c.statusId == 2 && c.UserId == user && c.RoleId == 5 select new ViewStatus { usercourse = c, coursename = cou }; return(View(query)); }
public ActionResult viewarticle() { if (Session["Cliente"] == null) { return(RedirectToAction("login", "Home", new { area = "" })); } var user = Convert.ToInt32(Session["Cliente"]); Digital_LearningEntities entities = new Digital_LearningEntities(); List <Article> artis = entities.Articles.ToList(); List <loginTable> logo = entities.loginTables.ToList(); var query = from a in artis join al in logo on a.UserId equals al.UserId join ad in db.SuperAdmins on a.UserId equals ad.ad_Id where a.Role_Id == 1 && al.UserId == user select new ArticleDetail { art = a, log = al, admi = ad }; ViewBag.artis = query; return(View()); }
public ActionResult Enrollment(int courseid) { if (Session["Cliente"] == null) { return(RedirectToAction("login", "Home", new { area = "" })); } using (Digital_LearningEntities entities = new Digital_LearningEntities()) { //Response.Write(submit); return(View(entities.Courses.Single(x => x.courseId == courseid))); } }
public ActionResult viewassignment(int?courseid) { if (Session["Teacher"] == null) { return(RedirectToAction("login", "Home", new { area = "" })); } Digital_LearningEntities entities = new Digital_LearningEntities(); List <SubmitAssignment> sa = entities.SubmitAssignments.ToList(); List <School> s = entities.Schools.ToList(); List <SchoolAssignment> sca = entities.SchoolAssignments.ToList(); List <Course> c = entities.Courses.ToList(); var query = from sas in sa join ss in s on sas.SchoolId equals ss.School_Id into table1 from ss in table1.DefaultIfEmpty() join sss in sca on sas.AssignmentId equals sss.AssignmentId into table2 from sss in table2.DefaultIfEmpty() join ssss in c on sas.CourseId equals ssss.courseId into table3 from ssss in table3.DefaultIfEmpty() select new AssignmentDetail { sub = sas, s = ss, sc = sss, c = ssss }; return(View(query)); }