protected override IQuery <Group> ApplyWhereClause(IQuery <Group> query, GroupFilterDto filter)
{
var simplePredicate = new SimplePredicate(nameof(Group.Name), ValueComparingOperator.StringContains, filter.SubName);
return(filter.SubName.Equals("")
? query
: query.Where(simplePredicate));
}
protected override IQuery <Group> ApplyWhereClause(IQuery <Group> query, GroupFilterDto filter)
{
var simplePredicate = new SimplePredicate(nameof(Group.Name), ValueComparingOperator.Equal, filter.GroupName);
return(string.IsNullOrEmpty(filter.GroupName)
? query
: query.Where(simplePredicate));
}
protected override IQuery <Group> ApplyWhereClause(IQuery <Group> query, GroupFilterDto filter)
{
return(string.IsNullOrWhiteSpace(filter.Name)
? query
: query.Where(new SimplePredicate(nameof(Group.Name),
ValueComparingOperator.StringContains,
filter.Name)));
}
protected override IQuery <Group> ApplyWhereClause(IQuery <Group> query, GroupFilterDto filter)
{
throw new NotImplementedException();
/*
* if (string.IsNullOrWhiteSpace(filter.Email))
* {
* return query;
* }
* return query.Where(new SimplePredicate(nameof(AppUser.Email), ValueComparingOperator.Equal, filter.Email));
*/
}
public async Task <ActionResult> List(int page = 1)
{
var filter = new GroupFilterDto {
PageSize = PageSize, RequestedPageNumber = page
};
var result = await GroupFacade.GetGroupsByFilterAsync(filter);
// Paging
ViewBag.RequestedPageNumber = result.RequestedPageNumber;
ViewBag.PageCount = (int)Math.Ceiling((double)result.TotalItemsCount / (double)PageSize);
// Paging END
return(View("List", result.Items));
}
// GET: GroupManager
public async Task <ActionResult> Index([FromUri] string subname)
{
var filter = new GroupFilterDto {
SubName = subname
};
var user = await BasicUserFacade.GetUserByNickNameAsync(User.Identity.Name);
var groups = await GroupGenericFacade.GetGroupsContainingSubNameAsync(subname);
var basicUserWithGroups = await BasicUserFacade.GetBasicUserWithGroups(user.Id);
return(View("GroupManagementView", new FindGroupsModel
{
Filter = filter,
Groups = groups,
User = basicUserWithGroups
}));
}
public async Task <IReadOnlyList <GroupDto> > GetGroups(
GroupFilterDto filter,
PaginationDto pagination)
{
var groups = await _uow.Groups.GetQuery()
.Include(group => group.StudentGroupRelations)
.Where(group =>
filter.Name.IsNullOrEmpty() || group.Name.ToUpper().Contains(filter.Name.ToUpper())
)
.Skip(pagination.Skip)
.Take(pagination.Take)
.Select(group => new GroupDto
{
Id = group.Id,
Name = group.Name,
StudentCount = group.StudentGroupRelations.Count
})
.ToListAsync();
return(groups);
}
public async Task <QueryResultDto <GroupDto, GroupFilterDto> > GetGroupsByFilterAsync(GroupFilterDto filter)
{
using (UnitOfWorkProvider.Create())
{
return(await _groupService.ListGroupsAsync(filter));
}
}
