Ejemplo n.º 1
0
        public Item GetById(int id)
        {
            ItemFilterCriterio filter = new ItemFilterCriterio();

            filter.Id = id;
            List <Item> items = this.GetList(filter, 0, 1);

            if (items.Count > 0)
            {
                return(items[0]);
            }
            return(null);
        }
Ejemplo n.º 2
0
        public List <Item> GetList(ItemFilterCriterio filter, int page, int pageSize)
        {
            List <Item> list = new List <Item>();

            if (pageSize == 0)
            {
                pageSize = Constants.PAGE_SIZE;
            }

            IQueryable <Item> query = _appDbContext.Item;

            if (filter.Id != 0)
            {
                query.Where(m => m.Id == filter.Id);
            }
            if (filter.IdCompany != 0)
            {
                query.Where(m => m.Id_company == filter.IdCompany);
            }
            query = query.Skip((page - 1) * pageSize).Take(pageSize);
            list  = query.ToList();
            return(list);
        }