public ActionResult AddNewSkillsetMember(FormCollection formValues) { int sid = (int)Session["SkillsetID"]; var uid = Int32.Parse(formValues["ID"]); // avoid duplicate entries SkillsetRosterEntry temp = new SkillsetRosterEntry { UserID = uid, SkillsetID = sid }; if (repository.TestSkillsetRoster(temp) == null) repository.AddSkillsetRoster(uid, sid); TempData["message"] = string.Format("User {0} has been added to Skillset {1}.", temp.UserID, temp.SkillsetID); return RedirectToAction("AddSkillsetMember/" + sid.ToString()); }
public ActionResult AddNewSkillsetMemberByID(int id) { int sid = (int)Session["SkillsetID"]; var uid = id; // avoid duplicate entries SkillsetRosterEntry temp = new SkillsetRosterEntry { UserID = uid, SkillsetID = sid }; if (repository.TestSkillsetRoster(temp) == null) { var result = repository.AddSkillsetRoster(uid, sid); if (result > 0) TempData["message"] = string.Format("User {0} has been added to Skillset {1}.", temp.UserID, temp.SkillsetID); else TempData["message"] = string.Format("Failed to add Skillset. Please verify that the ID number is correct and try again."); } return RedirectToAction("AddSkillsetMember/" + sid.ToString()); }
public int AddSkillsetRoster(int uid, int sid) { var returnvalue = -1; var newSkillsetUser = new SkillsetRosterEntry { UserID = uid, SkillsetID= sid }; if (GetUser(uid) != null)//make sure the id number given is a real id number before continuing { context.SkillsetRosterEntries.Add(newSkillsetUser); returnvalue = context.SaveChanges(); } return returnvalue; }
public SkillsetRosterEntry TestSkillsetRoster(SkillsetRosterEntry SkillsetMember) { SkillsetRosterEntry temp = context.SkillsetRosterEntries.FirstOrDefault(u => (u.UserID == SkillsetMember.UserID) && (u.SkillsetID == SkillsetMember.SkillsetID)); return temp; }
public void DropSkillsetRoster(SkillsetRosterEntry SkillsetUser) { SkillsetRosterEntry temp = context.SkillsetRosterEntries.FirstOrDefault(u => (u.UserID == SkillsetUser.UserID) && (u.SkillsetID == SkillsetUser.SkillsetID)); context.SkillsetRosterEntries.Remove(temp); context.SaveChanges(); }
public ActionResult DropSkillsetMember(int id) { int sid = (int)Session["SkillsetID"]; int userID = id; SkillsetRosterEntry temp = new SkillsetRosterEntry { UserID = userID, SkillsetID = sid }; repository.DropSkillsetRoster(temp); repository.SaveChanges(); TempData["message"] = string.Format("User {0} has been dropped from skillset {1}.", temp.UserID, temp.SkillsetID); return RedirectToAction("AddSkillsetMember/" + sid.ToString()); }