public List <AdvertisementSubCategory> GetSubCategories(AdvertismentCateory category) { using (UniversalContext context = new UniversalContext()) { return((from sc in context.AdvertisementSubCategories .Include(m => m.AdvertismentCateory) where sc.AdvertismentCateory.Id == category.Id select sc).ToList()); } }
public List <Advertisement> GetAdvertisementsByCategory(AdvertismentCateory advertisementCategory) { using (UniversalContext context = new UniversalContext()) { return((from adv in context.Advertisements .Include(a => a.SubCategory.AdvertismentCateory) .Include(a => a.Images) .Include(a => a.Type) where adv.SubCategory.AdvertismentCateory.Id == advertisementCategory.Id select adv).ToList()); } }