/// <summary> /// Get Discount Sub Types /// </summary> public DiscountSubTypeSearchRequestResponse Get([FromUri] DiscountSubTypeSearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(discountSubTypeService.SearchDiscountSubType(request).CreateFrom()); }
/// <summary> /// Discount Sub Type Search /// </summary> public DiscountSubTypeSearchRequestResponse SearchDiscountSubType(DiscountSubTypeSearchRequest request) { int rowCount; return(new DiscountSubTypeSearchRequestResponse { DiscountSubTypes = discountSubTypeRepository.SearchDiscountSubType(request, out rowCount) }); }
/// <summary> /// Search Discount Sub Type /// </summary> public IEnumerable <DiscountSubType> SearchDiscountSubType(DiscountSubTypeSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <DiscountSubType, bool> > query = discountsubType => (string.IsNullOrEmpty(request.DiscountSubTypeFilterText) || (discountsubType.DiscountSubTypeCode.Contains(request.DiscountSubTypeFilterText)) || (discountsubType.DiscountSubTypeName.Contains(request.DiscountSubTypeFilterText))) && ( (!request.DiscountTypeId.HasValue || request.DiscountTypeId == discountsubType.DiscountTypeId)); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(discountSubTypeOrderByClause[request.DiscountSubTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(discountSubTypeOrderByClause[request.DiscountSubTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }