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