// GET: Course public ActionResult Index() { if (Session["CurrentUser"] != null) { UserViewModel Current = (UserViewModel)Session["CurrentUser"]; PleDBEntities db = new PleDBEntities(); var CourseList = db.Courses.Select(course => new CourseViewModel { CourseID = course.CourseID, CourseCode = course.CourseCode, CourseDescription = course.CourseDescription, CourseName = course.CourseName, DateCreated = course.DateCreated, IsCurrentlyAvailable = course.IsCurrentlyAvailable, NeedApproval = course.NeedApproval, }).ToList(); ViewBag.Courses = CourseList; return(View(Current)); } else { return(RedirectToAction("Login", "Account")); } }
public List <UserViewModel> GetUsers(int CourseID) { PleDBEntities db = new PleDBEntities(); var Users = db.CourseParticipations.Where(cp => cp.CourseID == CourseID).Select(cp => new UserViewModel { UserID = cp.User.UserID, FullName = cp.User.FullName, Email = cp.User.Email }).ToList(); return(Users); }
public List <AssignmentViewModel> GetAssignments(int CourseID) { PleDBEntities db = new PleDBEntities(); var Assignments = db.Assignments.Where(assignment => assignment.CourseID == CourseID).Select(assignment => new AssignmentViewModel { AssignmentID = assignment.AssignmentID, CourseID = assignment.CourseID, CreatedDate = assignment.CreatedDate, MustDeliveryDate = assignment.MustDeliveryDate, Description = assignment.Description, Title = assignment.Title }).ToList(); return(Assignments); }
public ActionResult SignUp(UserViewModel signupUser) { if (ModelState.IsValid) { PleDBEntities db = new PleDBEntities(); User signupUserDb = new User(); signupUserDb.UserID = signupUser.UserID; signupUserDb.UserPassword = signupUser.UserPassword; signupUserDb.FullName = signupUser.FullName; signupUserDb.Email = signupUser.Email; signupUserDb.UserTypeID = 3; db.Users.Add(signupUserDb); db.SaveChanges(); } return(RedirectToAction("Login")); }
public CourseViewModel GetCurrentCourse(int CourseID) { PleDBEntities db = new PleDBEntities(); var CurrentCourse = db.Courses.Where(course => course.CourseID == CourseID).Select(course => new CourseViewModel { CourseID = course.CourseID, CourseCode = course.CourseCode, CourseDescription = course.CourseDescription, CourseName = course.CourseName, DateCreated = course.DateCreated, IsCurrentlyAvailable = course.IsCurrentlyAvailable, NeedApproval = course.NeedApproval }).SingleOrDefault(); return(CurrentCourse); }
public ActionResult Login(UserViewModel Current) { PleDBEntities db = new PleDBEntities(); User user = db.Users.SingleOrDefault(x => x.UserID == Current.UserID && x.UserPassword == Current.UserPassword); if (user != null) { Current.UserID = user.UserID; Current.FullName = user.FullName; Current.UserTypeID = user.UserTypeID; Current.ParticipatedCourses = (from cp in db.CourseParticipations join course in db.Courses on cp.CourseID equals course.CourseID where cp.UserID == Current.UserID select new CourseViewModel { CourseID = course.CourseID, CourseCode = course.CourseCode, CourseDescription = course.CourseDescription, CourseName = course.CourseName, DateCreated = course.DateCreated, IsCurrentlyAvailable = course.IsCurrentlyAvailable, NeedApproval = course.NeedApproval }).ToList(); Current.ParticipatedCourses.AddRange((from course in db.Courses where course.OwnerID == Current.UserID select new CourseViewModel { CourseID = course.CourseID, CourseCode = course.CourseCode, CourseDescription = course.CourseDescription, CourseName = course.CourseName, DateCreated = course.DateCreated, IsCurrentlyAvailable = course.IsCurrentlyAvailable, NeedApproval = course.NeedApproval })); Session["CurrentUser"] = Current; return(RedirectToAction("Index", "Home")); } else { ViewBag.Message = "Failed to login."; return(View()); } }
public List <GradeViewModel> GetCourseGrades(int CourseID) { PleDBEntities db = new PleDBEntities(); var Grades = from grade in db.Grades where grade.Assignment.CourseID == CourseID orderby grade.AssignmentID select new GradeViewModel { AssignmentID = grade.AssignmentID, GradeID = grade.GradeID, Points = grade.Points, UserID = grade.UserID }; return(Grades.ToList()); }
public List <CourseViewModel> GetCourses(string UserID) { PleDBEntities db = new PleDBEntities(); var Courses = from cp in db.CourseParticipations join course in db.Courses on cp.CourseID equals course.CourseID where cp.UserID == UserID select new CourseViewModel { CourseID = course.CourseID, CourseCode = course.CourseCode, CourseDescription = course.CourseDescription, CourseName = course.CourseName, DateCreated = course.DateCreated, IsCurrentlyAvailable = course.IsCurrentlyAvailable, NeedApproval = course.NeedApproval }; return(Courses.ToList()); }
private ActionResult CourseDetail(int CourseID) { if (Session["CurrentUser"] != null) { UserViewModel Current = (UserViewModel)Session["CurrentUser"]; PleDBEntities db = new PleDBEntities(); var CurrentCourse = db.Courses.Where(course => course.CourseID == CourseID).Select(course => new CourseViewModel { CourseID = course.CourseID, CourseCode = course.CourseCode, CourseDescription = course.CourseDescription, CourseName = course.CourseName, DateCreated = course.DateCreated, IsCurrentlyAvailable = course.IsCurrentlyAvailable, NeedApproval = course.NeedApproval }).SingleOrDefault(); ViewBag.CurrentCourse = CurrentCourse; return(View("Detail", Current)); } else { return(RedirectToAction("Login", "Account")); } }