public ActionResult RemoveSkillSet(int id, [FromQuery] int student) { using (EPortfolioDB database = new EPortfolioDB()) { // obtain assignment as per the given request StudentSkillSet assignment = database.StudentSkillSets .Where(s => s.SkillSetId == id) .Where(s => s.StudentId == student) .FirstOrDefault(); if (assignment == null) { return(NotFound()); } // remove assignment from database database.StudentSkillSets.Remove(assignment); database.SaveChanges(); } return(Ok()); }
public ActionResult AssignSkillSet(int id, [FromQuery] int student) { using (EPortfolioDB database = new EPortfolioDB()) { // check if student skillset already exists in the database IQueryable <StudentSkillSet> matchingAssignments = database .StudentSkillSets .Where(s => s.SkillSetId == id) .Where(s => s.StudentId == student); if (matchingAssignments.Count() >= 1) { return(Ok()); // skillset already assigned to student } // obtain models for the specified by the given request SkillSet skillSetModel = database.SkillSets .Where(s => s.SkillSetId == id).FirstOrDefault(); Student studentModel = database.Students .Where(s => s.StudentId == student).FirstOrDefault(); if (skillSetModel == null || studentModel == null) { return(NotFound()); } // assign the skillset to the student StudentSkillSet assignment = new StudentSkillSet { Student = studentModel, SkillSet = skillSetModel }; database.StudentSkillSets.Add(assignment); database.SaveChanges(); } return(Ok()); }