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