예제 #1
0
        public virtual TEntity Find(Expression <Func <TEntity, bool> > predicate)
        {
            var name = typeof(TEntity);

            if (UtilRepo.GetMember(name, "habilitado"))
            {
                return(DbSet.Where("habilitado").FirstOrDefault(predicate));
            }
            else
            {
                return(DbSet.FirstOrDefault(predicate));
            }
        }
예제 #2
0
        public bool Contains(Expression <Func <TEntity, bool> > predicate)
        {
            var name = typeof(TEntity);

            if (UtilRepo.GetMember(name, "habilitado"))
            {
                return(DbSet.Where("habilitado").Count(predicate) > 0);
            }
            else
            {
                return(DbSet.Count(predicate) > 0);
            }
        }
예제 #3
0
        public virtual IQueryable <TEntity> Filter(Expression <Func <TEntity, bool> > predicate)
        {
            var name = typeof(TEntity);

            if (UtilRepo.GetMember(name, "habilitado"))
            {
                return(DbSet.Where(predicate).Where("habilitado").AsQueryable <TEntity>());
            }
            else
            {
                return(DbSet.Where(predicate).AsQueryable <TEntity>());
            }
        }
예제 #4
0
        public virtual IQueryable <TEntity> All()
        {
            var name = typeof(TEntity);

            if (UtilRepo.GetMember(name, "habilitado"))
            {
                return(DbSet.Where("habilitado").AsQueryable <TEntity>());
            }
            else
            {
                return(DbSet.AsQueryable());
            }
        }
예제 #5
0
        public virtual IQueryable <TEntity> Filter <Key>(Expression <Func <TEntity, bool> > filter, out int total, int index = 0, int size = 50)
        {
            int skipCount = index * size;
            var name      = typeof(TEntity);

            if (UtilRepo.GetMember(name, "habilitado"))
            {
                var _resetSet = filter != null?DbSet.Where(filter).Where("habilitado") : DbSet;

                _resetSet = skipCount == 0 ? _resetSet.Take(size) : _resetSet.AsEnumerable().Skip(skipCount).Take(size).AsQueryable();
                total     = _resetSet.Where("habilitado").Count();
                return(_resetSet);
            }
            else
            {
                //int skipCount = index * size;
                var _resetSet = filter != null?DbSet.Where(filter) : DbSet;

                _resetSet = skipCount == 0 ? _resetSet.Take(size) : _resetSet.AsEnumerable().Skip(skipCount).Take(size).AsQueryable();
                total     = _resetSet.Count();
                return(_resetSet);
            }
        }