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