Пример #1
0
 /// <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());
 }
Пример #2
0
        /// <summary>
        /// Discount Sub Type Search
        /// </summary>
        public DiscountSubTypeSearchRequestResponse SearchDiscountSubType(DiscountSubTypeSearchRequest request)
        {
            int rowCount;

            return(new DiscountSubTypeSearchRequestResponse
            {
                DiscountSubTypes = discountSubTypeRepository.SearchDiscountSubType(request, out rowCount)
            });
        }
Пример #3
0
        /// <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());
        }