/// <summary>
 /// Get Business Partner Relation Types
 /// </summary>
 public Models.BusinessPartnerRelationTypeSearchRequestResponse Get([FromUri] BusinessPartnerRelationTypeSearchRequest request)
 {
     if (request == null || !ModelState.IsValid)
     {
         throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
     }
     return(businessPartnerRelationTypeService.SearchBusinessPartnerRelationType(request).CreateFrom());
 }
        /// <summary>
        /// Search Business Partner Relationship Type
        /// </summary>
        public IEnumerable <BusinessPartnerRelationshipType> SearchBusinessPartnerRelationshipType(
            BusinessPartnerRelationTypeSearchRequest request, out int rowCount)
        {
            int fromRow = (request.PageNo - 1) * request.PageSize;
            int toRow   = request.PageSize;
            Expression <Func <BusinessPartnerRelationshipType, bool> > query =
                businessPartnerRelationshipType =>
                (string.IsNullOrEmpty(request.BusinessPartnerRelationTypeFilterText) ||
                 (businessPartnerRelationshipType.BusinessPartnerRelationshpTypeCode.Contains(request.BusinessPartnerRelationTypeFilterText)) ||
                 (businessPartnerRelationshipType.BusinessPartnerRelationshipTypeName.Contains(request.BusinessPartnerRelationTypeFilterText)));

            rowCount = DbSet.Count(query);
            return(request.IsAsc
                ? DbSet.Where(query)
                   .OrderBy(businessPartnerRelationTypeOrderByClause[request.BusinessPartnerRelationTypeGroupOrderBy])
                   .Skip(fromRow)
                   .Take(toRow)
                   .ToList()
                : DbSet.Where(query)
                   .OrderByDescending(businessPartnerRelationTypeOrderByClause[request.BusinessPartnerRelationTypeGroupOrderBy])
                   .Skip(fromRow)
                   .Take(toRow)
                   .ToList());
        }
        /// <summary>
        /// Search Business Partner Relation Type
        /// </summary>
        public BusinessPartnerRelationTypeSearchRequestResponse SearchBusinessPartnerRelationType(BusinessPartnerRelationTypeSearchRequest request)
        {
            int rowCount;

            return(new BusinessPartnerRelationTypeSearchRequestResponse
            {
                BusinessPartnerRelationshipTypes = businessPartnerRelationshipTypeRepository.SearchBusinessPartnerRelationshipType(request, out rowCount),
                TotalCount = rowCount
            });
        }