public void ReturnsProperlyFilteredCategories(string searchText, FlashcardsSortingCriterion criterion, bool descending, int pageIndex, int pageSize) { var model = new FlashcardsFilteringModel(searchText, criterion, descending, pageIndex, pageSize); var categories = AddCategories(); var flashards = AddFlashcards(categories[0], 50); var query = Context.Flashcards.AsQueryable(); var filteredFlashcards = FilteringServices.Filter(query, model).ToList(); var expected = flashards.Where(f => f.Key.Contains(model.SearchText) || f.Value.Contains(model.SearchText) || f.KeyDescription.Contains(model.SearchText) || f.ValueDescription.Contains(model.SearchText) || f.Category.Name.Contains(model.SearchText)); var lambda = GetLambda(criterion); expected = descending ? expected.OrderByDescending(lambda) : expected.OrderBy(lambda); var expectedList = expected.Skip(model.PageIndex * model.PageSize).Take(model.PageSize) .ToList(); Assert.Equal(expectedList.Count, filteredFlashcards.Count); for (var i = 0; i < expectedList.Count; i++) { var returned = filteredFlashcards[i]; var exp = new FlashcardDto(expectedList[i]); Assert.True(exp.Id == returned.Id); } }
public void InvalidFilteringModel(bool descending, FlashcardsSortingCriterion criterion) { var model = new FlashcardsFilteringModel("", criterion, descending, 1, 1); var query = Context.Flashcards.AsQueryable(); Assert.Throws <ArgumentOutOfRangeException>(() => FilteringServices.Filter(query, model)); }
public IActionResult Filter([FromBody] UsersFilteringModel model) { var query = _filteringServices.Filter(_services.Get(), model); var list = query.ToList(); return(new JsonResult(list)); }
public void ReturnsProperlyFilteredCategories(string searchText, UsersSortingCriterion criterion, bool descending, int pageIndex, int pageSize) { var model = new UsersFilteringModel(searchText, criterion, descending, pageIndex, pageSize); var users = AddUsers(31); var categories = AddCategories(); var flashards = AddFlashcards(categories[0], 50); var userProgress = AddUserProgress(flashards, users.GetRange(0, 20)); var query = Context.Users.AsQueryable(); var filteredUserDtos = FilteringServices.Filter(query, model).ToList(); var expected = users.Where(u => u.Name.Contains(model.SearchText) || u.Surname.Contains(model.SearchText) || u.UserName.Contains(model.SearchText)); var lambda = GetLambda(criterion); expected = descending ? expected.OrderByDescending(lambda) : expected.OrderBy(lambda); var expectedList = expected.Skip(model.PageIndex * model.PageSize).Take(model.PageSize) .Select(u => new UserDto(u.Name, u.Surname, u.UserName, new Score(userProgress.Where(up => up.UserId == u.Id).Sum(progress => progress.Progress)))) .ToList(); Assert.Equal(expectedList.Count, filteredUserDtos.Count); for (var i = 0; i < expectedList.Count; i++) { Assert.True(expectedList[i].UserName.Equals(filteredUserDtos[i].UserName)); } }
public IActionResult Filter([FromBody] CategoriesFilteringModel model) { var userId = _userManager.GetUserId(this.User); var isAdmin = this.User.IsInRole(_roleNamesOptions.AdminRoleName); var query = _filteringServices.Filter(_services.Get(userId, isAdmin), model); var list = query.ToList(); return(new JsonResult(list)); }
public void ReturnsProperlyFilteredCategories(string searchText, CategoriesSortingCriterion criterion, bool descending, int pageIndex, int pageSize) { var model = new CategoriesFilteringModel(searchText, criterion, descending, pageIndex, pageSize); var categories = AddCategories(30); var query = Context.Categories.AsQueryable(); var filteredCategories = FilteringServices.Filter(query, model).ToList(); var expected = categories.Where(c => c.Name.Contains(searchText)); var lambda = GetLambda(criterion); expected = descending ? expected.OrderByDescending(lambda) : expected.OrderBy(lambda); var expectedList = expected.Skip(model.PageIndex * model.PageSize).Take(model.PageSize).ToList(); Assert.Equal(expectedList.Count, filteredCategories.Count); for (var i = 0; i < expectedList.Count; i++) { Assert.True(expectedList[i].Id == (filteredCategories[i].Id)); } }