/// <summary>to
/// Get OrgGroups
/// </summary>
public OrgGroupRequestResponse Get([FromUri] OrgGroupSearchRequest request)
{
if (!ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
return(orgGroupService.SerchOrgGroup(request).CreateFrom());
}
/// <summary>
/// Search/Get Organization Group
/// </summary>
public OrgGroupResponse SerchOrgGroup(OrgGroupSearchRequest request)
{
int rowCount;
return(new OrgGroupResponse
{
OrgGroups = organizationGroupRepository.SearchOrgGroup(request, out rowCount),
TotalCount = rowCount
});
}
/// <summary>
/// Search Organization Group
/// </summary>
public IEnumerable <OrgGroup> SearchOrgGroup(OrgGroupSearchRequest request, out int rowCount)
{
int fromRow = (request.PageNo - 1) * request.PageSize;
int toRow = request.PageSize;
Expression <Func <OrgGroup, bool> > query =
orgGroup =>
(string.IsNullOrEmpty(request.OrgGroupText) ||
(orgGroup.OrgGroupCode.Contains(request.OrgGroupText)) ||
(orgGroup.OrgGroupName.Contains(request.OrgGroupText)));
rowCount = DbSet.Count(query);
return(request.IsAsc ?
DbSet.Where(query)
.OrderBy(orgGroupOrderByClause[request.OrgGroupOrderBy])
.Skip(fromRow)
.Take(toRow)
.ToList() :
DbSet.Where(query)
.OrderByDescending(orgGroupOrderByClause[request.OrgGroupOrderBy])
.Skip(fromRow)
.Take(toRow)
.ToList());
}
