/// <summary> /// Get Job Types /// </summary> public JobTypeSearchRequestResponse Get([FromUri] JobTypeSearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(jobTypeService.SearchJobType(request).CreateFrom()); }
/// <summary> /// Search Job Type /// </summary> public JobTypeSearchRequestResponse SearchJobType(JobTypeSearchRequest request) { int rowCount; return(new JobTypeSearchRequestResponse { JobTypes = jobTypeRepository.SearchJobType(request, out rowCount), TotalCount = rowCount }); }
/// <summary> /// Search Job Type /// </summary> public IEnumerable <JobType> SearchJobType(JobTypeSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <JobType, bool> > query = jobType => (string.IsNullOrEmpty(request.JobTypeFilterText) || (jobType.JobTypeCode.Contains(request.JobTypeFilterText)) || (jobType.JobTypeName.Contains(request.JobTypeFilterText))); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(jobTypeOrderByClause[request.JobTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(jobTypeOrderByClause[request.JobTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }