Esempio n. 1
0
        public IEnumerable <Item> Find(ISpec <Item, bool> spec)
        {
            var result = _dbSet
                         .Include(i => i.Subcategory)
                         .Include(i => i.Subcategory.Category)
                         .Where(spec.ToExpression())
                         .OrderBy(x => x.Name)
                         .AsNoTracking();

            return(result);
        }
Esempio n. 2
0
        public IEnumerable <Item> GetLatestAddedItems(ISpec <Item, bool> spec, int amount)
        {
            var result = _dbSet
                         .Include(i => i.Subcategory)
                         .Include(i => i.Subcategory.Category)
                         .Include(i => i.Payment)
                         .Where(spec.ToExpression())
                         .OrderBy(x => x.Name)
                         .Take(amount)
                         .AsNoTracking();

            return(result);
        }
Esempio n. 3
0
        public IEnumerable <Item> Find(ISpec <Item, bool> spec, ISpec <Item, object> orderSpec)
        {
            var result = _dbSet
                         .Include(i => i.Subcategory)
                         .Include(i => i.Subcategory.Category)
                         .Include(i => i.Payment)
                         .Where(spec.ToExpression())
                         .OrderBy(orderSpec.ToExpression())
                         .AsNoTracking()
                         .AsEnumerable();

            return(result);
        }