public async Task <IActionResult> Index(InventoryItemFilter filter) { var inventoryQuery = _dbContext.Inventory.AsQueryable <InventoryItem>(); if (filter != null) { if (filter.Category > 0) { inventoryQuery = inventoryQuery.Where(item => item.Category == filter.Category); } if (!string.IsNullOrWhiteSpace(filter.Query)) { inventoryQuery = inventoryQuery.Where(item => item.Title.Contains(filter.Query)); } } var result = inventoryQuery.ToList(); return(Ok(result)); }
public async Task <ActionResult> Get(InventoryItemFilter filter) { var items = await _service.Collection(filter); return(new OkObjectResult(items)); }
public async Task <List <InventoryItem> > Collection(InventoryItemFilter filter) { var query = _db.InventoryItems.AsQueryable().Filter(filter); return(await Task.FromResult(query.ToList())); }