示例#1
0
        public async Task <TodoPaginationDTO> GetByFilters(TodoPaginationDTO parameters)
        {
            try
            {
                var data = await this.iTodoDomainObject.GetByFilters(parameters);

                return(data);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
示例#2
0
        public async Task <TodoPaginationDTO> GetByFilters(TodoPaginationDTO parameters)
        {
            List <TodoDTO> listTodo      = new List <TodoDTO>();
            int            limitForPage  = int.Parse(this.config.GetSection("MongoConnection:LimitForPage").Value);
            long           countDocument = 0;
            int            skip          = (parameters.page - 1) * limitForPage;

            try
            {
                var filters = this.SetFilterQuery(parameters.filters);

                if (filters.Count == 0)
                {
                    countDocument = this._context.TodoCollection().CountDocuments(new BsonDocument());
                    var getAll = await _context.TodoCollection().Find(Builders <TodoDTO> .Filter.Empty).Skip(skip).Limit(limitForPage).ToListAsync();

                    return(new TodoPaginationDTO
                    {
                        count = countDocument,
                        data = getAll.ToArray(),
                        page = parameters.page
                    });
                }

                var complexFilter = Builders <TodoDTO> .Filter.And(filters);

                countDocument = this._context.TodoCollection().CountDocuments(complexFilter);
                var data = await _context.TodoCollection().Find(complexFilter).Skip(skip).Limit(limitForPage).ToListAsync();

                return(new TodoPaginationDTO
                {
                    count = countDocument,
                    data = data.ToArray(),
                    page = parameters.page
                });
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message.ToString());
            }
        }