public IList <Tag> GetAdvTags(Advert adv) { var tagIds = _context.AdvTags.Where(p => p.AdvID == adv.Id).Select(p => p.TagId).ToList(); List <Tag> tags = new List <Tag>(); foreach (var tagId in tagIds) { tags.Add(_context.Tags.Where(p => p.Id == tagId).FirstOrDefault()); } return(tags); }
public IList <Category> GetAdvCategories(Advert adv) { var categoryIds = _context.AdvCategories.Where(p => p.AdvID == adv.Id).Select(p => p.CatID).ToList(); List <Category> categories = new List <Category>(); foreach (var catId in categoryIds) { categories.Add(_context.Categories.Where(p => p.Id == catId).FirstOrDefault()); } return(categories); }
public IList <AdvImage> GetAdvImages(Advert adv) { var advUrls = _context.AdvImages.Where(p => p.AdvId == adv.Id).ToList(); List <AdvImage> images = new List <AdvImage>(); foreach (var url in advUrls) { images.Add(url); } return(images); }
public IList <Comment> GetAdvComments(Advert advert) { return(_context.Comments.Where(p => p.AdvId == advert.Id).ToList()); }
public void AddNewAdvert(Advert advert) { _context.Adverts.Add(advert); Save(); }