public File AddFile(File file)
{
_context.Files.Add(file);
_context.SaveChanges();
return(file);
}
public Link AddLink(Link link)
{
_context.Links.Add(link);
_context.SaveChanges();
return(link);
}
public void SaveIssuesByTraineeId(int traineeId)
{
ClearExistingReport(traineeId);
var issues = SearchIssuesByTraineeId(traineeId);
_context.Issues.AddRange(issues);
_context.SaveChanges();
}
public void UpdateSelectedMainSkills(int profileId, List <int> mainSkillsId)
{
TraineeProfile profile = _context.TraineeProfiles.Find(profileId);
List <MainSkill> availableMainSkills = GetAvailableMainSkills(profileId);
if (mainSkillsId == null || mainSkillsId.Count == 0)
{
profile.MainSkills.Clear();
}
else
{
var deletingSkills = profile.MainSkills.Where(skill => !mainSkillsId.Contains(skill.Id)).ToList();
foreach (var skill in deletingSkills)
{
profile.MainSkills.Remove(skill);
}
var addingSkills = availableMainSkills.Where(skill => mainSkillsId.Contains(skill.Id) && !profile.MainSkills.Any(s => s.Id == skill.Id));
foreach (var skill in addingSkills)
{
profile.MainSkills.Add(skill);
}
}
_context.SaveChanges();
}
public List <SoftSkill> UpdateSoftSkills(List <SoftSkill> softSkills)
{
foreach (var softSkill in softSkills)
{
if (softSkill.Id == 0)
{
_context.SoftSkills.Add(softSkill);
}
else
{
_context.Entry(softSkill).State = EntityState.Modified;
}
}
_context.SaveChanges();
return(softSkills);
}
/// <summary>
/// Attaches the given entities list to the context underlying the set
/// and updates changed fields in appropriate database entities
/// that searches by the primary key value or adds new record to
/// the database context if key value is absent.
///
/// </summary>
/// <param name="coursesToUpdate">Entities list to update courses information.</param>
/// <returns>Updated entities list if exists or null.</returns>
public List <Course> UpdateCourses(List <Course> coursesToUpdate)
{
foreach (var course in coursesToUpdate)
{
if (course.Id == 0)
{
_context.Courses.Add(course);
}
else
{
_context.Entry(course).State = EntityState.Modified;
}
}
_context.SaveChanges();
return(coursesToUpdate);
}
public void SetRoles(int[] userIds,
List <RoleType> roles,
int?specializationId = default(int?))
{
var users = _context.Users.Where(u => userIds.Contains(u.Id)).ToList();
var specialization = specializationId.HasValue ?
_context.Specializations.Find(specializationId.Value) :
null;
foreach (var user in users)
{
foreach (var newRole in roles)
{
user.Roles.Clear();
CreateUserBlankByRole(user, newRole, specialization);
AddToRole(user, newRole);
}
}
_context.SaveChanges();
}
public int Put(User user)
{
return(_profileContext.SaveChanges());
}
