public void AssignTags(List <string> tags, int id) { TagProject.RemoveRange(TagProject.Where(t => t.ProjectId == id)); foreach (var tag in tags) { if (Tags.Any(t => t.Naam.ToLower() == tag.ToLower().Trim())) { //Projecten // .Include(x => x.TagProjects).ThenInclude(x => x.Tag) // .SingleOrDefault(p => p.Id == id) // .TagProjects.Add(new TagProject { TagId = Tags.SingleOrDefault(t => t.Naam.ToLower() == tag.ToLower().Trim()).Id, ProjectId = Projecten.SingleOrDefault(p => p.Id == id).Id }); TagProject.Add(new TagProject { TagId = Tags.SingleOrDefault(t => t.Naam.ToLower() == tag.ToLower().Trim()).Id, ProjectId = Projecten.SingleOrDefault(p => p.Id == id).Id }); } else { Tag newTag = new Tag { Naam = tag.Trim().ToLower() }; Tags.Add(newTag); //Projecten // .Include(x=>x.TagProjects).ThenInclude(x=>x.Tag) // .SingleOrDefault(p => p.Id == id) // .TagProjects.Add(new TagProject { Tag = new Tag { Naam = tag.ToLower().Trim() }, ProjectId = Projecten.SingleOrDefault(p => p.Id == id).Id }); TagProject.Add(new TagProject { Tag = new Tag { Naam = tag.ToLower().Trim() }, ProjectId = Projecten.SingleOrDefault(p => p.Id == id).Id }); } } this.SaveChanges(); }
public Project GetProject(int id) { return(Projecten .Include(x => x.Status) .Include(p => p.TagProjects).ThenInclude(p => p.Tag) .SingleOrDefault(p => p.Id == id)); }
public void Delete(int id) { var project = Projecten.SingleOrDefault(x => x.Id == id); if (project != null) { Projecten.Remove(project); this.SaveChanges(); } }
public void Update(int id, Project updatedProject) { var project = Projecten.SingleOrDefault(p => p.Id == id); if (project != null) { project.Titel = updatedProject.Titel; project.Beschrijving = updatedProject.Beschrijving; project.Status = updatedProject.Status; } this.SaveChanges(); }
public Project Insert(Project project) { Projecten.Add(project); this.SaveChanges(); return(project); }
public IEnumerable <Project> GetProjecten() { return(Projecten .Include(x => x.Status) .Include(x => x.TagProjects).ThenInclude(x => x.Tag)); }