public ActionResult Assign(staff obj, int[] projeclist) { if (obj == null) { return(HttpNotFound()); } else { //update database int Sid = Convert.ToInt32(Session["staff_id"]); int cnt = 0; staff_projects projects = new staff_projects(); staff staff = db.staffs.Find(Sid); foreach (var p in projeclist) { projects.project_id = p; projects.staff_id = Sid; db.staff_projects.Add(projects); db.SaveChanges(); cnt = cnt + 1; } TempData["success"] = cnt + " new project(s) added to " + staff.fname + " " + staff.lname + " profile."; return(RedirectToAction("AssignProject", new { id = Sid })); } }
//Delete project from staff public ActionResult DeleteProject(int id) { int sId = Convert.ToInt32(Session["staff_id"]); staff_projects project = db.staff_projects.Where(s => s.staff_id == sId && s.project_id == id).SingleOrDefault(); if (project == null) { TempData["error"] = "An error has occurred while trying to remove the project " + project.project.project_name; } else { TempData["success"] = "1 Project " + project.project.project_name + " has been removed."; db.staff_projects.Remove(project); db.SaveChanges(); } return(RedirectToAction("AssignProject", new { id = sId })); }