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));
}
}
