public IEnumerable <TEntity> Buscar(Expression <Func <TEntity, bool> > condition, string orderBy = "", string sortDirection = "", int take = 0, int skip = 0) { var query = _contexto.Set <TEntity>().Where(condition);// if (!string.IsNullOrEmpty(orderBy)) { if (!string.IsNullOrEmpty(sortDirection)) { if (sortDirection == "asc") { query = OrderByHelper.OrderBy(query, orderBy); } else { query = OrderByHelper.OrderByDescending(query, orderBy); } if (take > 0) { query = query.Take(take); } if (skip > 0) { query = query.Skip(skip); } } } return(query.AsNoTracking().ToList()); }
public SearchResult <ItemMonitoramentoDTO> Buscar(Expression <Func <ItemMonitoramentoDTO, bool> > condition, string orderBy = "", string sortDirection = "", int take = 0, int skip = 0) { var query = QueryBase().Where(condition); int totalRecords = query.Count(); if (!string.IsNullOrEmpty(orderBy)) { if (sortDirection == "asc") { query = OrderByHelper.OrderBy(query, orderBy); } else { query = OrderByHelper.OrderByDescending(query, orderBy); } if (take > 0) { query = query.Take(take); } if (skip > 0) { query = query.Skip(skip); } } return(new SearchResult <ItemMonitoramentoDTO> { Itens = query.ToList(), TotalRecords = totalRecords, RecordsPerPage = take }); }
public SearchResult <TEntity> BuscaAvancada(Expression <Func <TEntity, bool> > condition, string orderBy = "", string sortDirection = "", int take = 0, int skip = 0) { var query = _contexto.Set <TEntity>().AsQueryable(); if (condition != null) { query = query.Where(condition); } int totalRecords = query.Count(); if (!string.IsNullOrEmpty(orderBy)) { if (!string.IsNullOrEmpty(sortDirection)) { if (sortDirection == "asc") { query = OrderByHelper.OrderBy(query, orderBy); } else { query = OrderByHelper.OrderByDescending(query, orderBy); } if (take > 0) { query = query.Take(take); } if (skip > 0) { query = query.Skip(skip); } } } return(new SearchResult <TEntity> { Itens = query.ToList(), TotalRecords = totalRecords, RecordsPerPage = take }); }