public JsonResult Users() { User currentUser = GlobalVariables.CurrentUser; DatabaseRepository db = new DatabaseRepository(); List<User> users = db.GetMinions(currentUser.user_id, currentUser.user_is_teacher); return Json(users, JsonRequestBehavior.AllowGet); }
public ActionResult Index() { User user = GlobalVariables.CurrentUser; DatabaseRepository db = new DatabaseRepository(); List<Comment> comments = db.GetComments(user.user_id); // Group comments and comma separate the recipients var groupedComments = comments.GroupBy(c => c.id).Select(c => new Comment { recipients = string.Join(", ", c.Select(comment => comment.recipient_first_name + ' ' + comment.recipient_last_name)), commenter = c.Select(comment => comment.commenter_first_name + ' ' + comment.commenter_last_name).First(), comment_text = c.Select(comment => comment.comment_text).First(), user_is_commenter = c.Select(comment => comment.user_is_commenter).First(), created_at = c.Select(comment => comment.created_at).First(), hidden = c.Select(comment => comment.hidden).First(), id = c.Select(comment => comment.id).First() }).ToList(); var commentViewModel = new Comments { comments = groupedComments, commenter_id = user.user_id }; return View(commentViewModel); }
public ActionResult Index() { DatabaseRepository db = new DatabaseRepository(); User user = GlobalVariables.CurrentUser; List<Course> courses = db.GetCourses(user.user_id); List<Module> viewModel = Mapper.Map<List<Course>, List<Module>>(courses); return View(viewModel); }
public ActionResult Delete(int commentId) { // This will delete the comment from the DB and redirect back to the comment page DatabaseRepository db = new DatabaseRepository(); db.DeleteComment(commentId); return RedirectToAction("Index"); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { DatabaseRepository db = new DatabaseRepository(); int teamId = (int) filterContext.ActionParameters["teamId"]; User currentUser = GlobalVariables.CurrentUser; List<Project> teams = db.GetLeaderProjects(currentUser.user_id); if (!teams.Any(t => t.project_id == teamId) && !currentUser.user_is_teacher) filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary( new { action = "Index", controller = "Error" })); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { DatabaseRepository db = new DatabaseRepository(); int commentId = (int) filterContext.ActionParameters["commentId"]; Comment comment = db.GetComment(commentId); // If the user is not the commenter, redirect if (comment.commenter_id != GlobalVariables.CurrentUser.user_id) filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary( new { action = "Index", controller = "Error" })); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { DatabaseRepository db = new DatabaseRepository(); string userId = filterContext.ActionParameters["userId"].ToString(); User currentUser = GlobalVariables.CurrentUser; List<User> users = db.GetMinions(currentUser.user_id, currentUser.user_is_teacher); // If the user is not the commenter, redirect if (!users.Any( u => u.user_id == userId)) filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary( new { action = "Index", controller = "Error" })); }
public ActionResult Create(Comments newComment) { // This will add the comment to the DB and redirect back to the comment page DatabaseRepository db = new DatabaseRepository(); if(!string.IsNullOrEmpty(newComment.comment) && !string.IsNullOrEmpty(newComment.recipients)) { int commentId = db.CreateComment(newComment.commenter_id, newComment.comment, newComment.hidden); db.LinkComment(commentId, newComment.recipients.Split(',')); } return RedirectToAction("Index"); }
public ActionResult Teams(int courseId) { DatabaseRepository db = new DatabaseRepository(); List<Project> projects = db.GetProjects(courseId); List<User> users = db.GetUsersWithoutTeams(courseId); List<User> members = db.GetUsersWithTeams(courseId); var viewModel = new TeamsProjectsAndUsers() { projects = projects, users = users, members = members }; return View(viewModel); }
public ActionResult Create(TeamsProjectsAndUsers course) { DatabaseRepository db = new DatabaseRepository(); int[] allProjectIds = course.teams.Where(t => t.projectId != 0).Select(t => t.projectId).ToArray(); int[] populatedProjectIds = course.teams.Where(t => t.userIds != null && t.projectId != 0).Select(t => t.projectId).ToArray(); if (allProjectIds.Any()) { db.DeleteAllMembers(allProjectIds); if (!string.IsNullOrEmpty(course.projectManager)) { string projectManagerId = course.projectManager.Split(',').First(); db.InsertProjectManager(projectManagerId, populatedProjectIds); } db.InsertTeamMembers(course.teams.ToList()); } return RedirectToAction("Index"); }