public static async Task <IEnumerable <CarModel> > FindModelsByBrandIdAsync(this IOrderedQueryable <CarBrand> brands, int brandId) { CarBrand brand = await brands .Include(b => b.CarModels).FirstOrDefaultAsync(b => b.Id == brandId); return(brand == null ? null : brand.CarModels); }
public static IEnumerable <Car> FindCarsByBrandId(this IOrderedQueryable <Car> carsSet, int brandId) { IEnumerable <Car> cars = carsSet .Include(c => c.Model) .Include(c => c.Model.CarBrand) .Include(c => c.Color) .Include(c => c.Owner) .Where(c => c.Model.BrandId == brandId) .AsNoTracking(); return(cars); }
public ActionResult Index() { IOrderedQueryable <Payment> orderByDescending = _db.Payments.OrderByDescending(payment => payment.Date); IQueryable <Payment> queryable = orderByDescending.Include("MenuItem"); if (Roles.IsUserInRole("Customer")) { return(View(queryable.Where(payment => payment.UserId == WebSecurity.CurrentUserId))); } else { return(View(queryable.Where(payment => payment.MenuItem.UserId == WebSecurity.CurrentUserId))); } }