/// <summary> /// Get Rating Types /// </summary> public RatingTypeSearchRequestResponse Get([FromUri] RatingTypeSearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(ratingTypeService.SearchRatingType(request).CreateFrom()); }
/// <summary> /// Search Rating Type /// </summary> public RatingTypeSearchRequestResponse SearchRatingType(RatingTypeSearchRequest request) { int rowCount; return(new RatingTypeSearchRequestResponse { RatingTypes = bpRatingTypeRepository.SearchRatingType(request, out rowCount), TotalCount = rowCount }); }
/// <summary> /// Search Rating Type /// </summary> public IEnumerable <BpRatingType> SearchRatingType(RatingTypeSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <BpRatingType, bool> > query = bpRatingType => (string.IsNullOrEmpty(request.RatingTypeFilterText) || (bpRatingType.BpRatingTypeCode.Contains(request.RatingTypeFilterText)) || (bpRatingType.BpRatingTypeName.Contains(request.RatingTypeFilterText))); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(ratingTypeOrderByClause[request.RatingTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(ratingTypeOrderByClause[request.RatingTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }