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