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