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));
        }
Example #2
0
        public async Task <ActionResult> Get(InventoryItemFilter filter)
        {
            var items = await _service.Collection(filter);

            return(new OkObjectResult(items));
        }
Example #3
0
        public async Task <List <InventoryItem> > Collection(InventoryItemFilter filter)
        {
            var query = _db.InventoryItems.AsQueryable().Filter(filter);

            return(await Task.FromResult(query.ToList()));
        }