/// <summary>
/// Get Business Segments from database
/// </summary>
public BusinessSegmentSearchRequestResponse Get([FromUri] BusinessSegmentSearchRequest request)
{
if (request == null || !ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
return(businessSegmentService.SearchBusinessSegment(request).CreateFrom());
}
/// <summary>
/// Search BusinessSegment
/// </summary>
public BusinessSegmentSearchRequestResponse SearchBusinessSegment(BusinessSegmentSearchRequest request)
{
int rowCount;
return(new BusinessSegmentSearchRequestResponse
{
BusinessSegments = businessSegmentRepository.SearchBusinessSegment(request, out rowCount),
TotalCount = rowCount
});
}
/// <summary>
/// Search Business Segment
/// </summary>
public IEnumerable <BusinessSegment> SearchBusinessSegment(BusinessSegmentSearchRequest businessSegmentSearchRequest,
out int rowCount)
{
int fromRow = (businessSegmentSearchRequest.PageNo - 1) * businessSegmentSearchRequest.PageSize;
int toRow = businessSegmentSearchRequest.PageSize;
Expression <Func <BusinessSegment, bool> > query =
businessSeg =>
(string.IsNullOrEmpty(businessSegmentSearchRequest.BusinessSegmentFilterText) ||
(businessSeg.BusinessSegmentCode.Contains(businessSegmentSearchRequest.BusinessSegmentFilterText)) ||
(businessSeg.BusinessSegmentName.Contains(businessSegmentSearchRequest.BusinessSegmentFilterText)));
rowCount = DbSet.Count(query);
return(businessSegmentSearchRequest.IsAsc
? DbSet.Where(query)
.OrderBy(businessSegmentOrderByClause[businessSegmentSearchRequest.BusinessSegmentOrderBy])
.Skip(fromRow)
.Take(toRow)
.ToList()
: DbSet.Where(query)
.OrderByDescending(businessSegmentOrderByClause[businessSegmentSearchRequest.BusinessSegmentOrderBy])
.Skip(fromRow)
.Take(toRow)
.ToList());
}
