/// <summary> /// Get Occupation Type /// </summary> public OccupationTypeSearchRequestResponse Get([FromUri] OccupationTypeSearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(occupationTypeService.SearchOccupationType(request).CreateFromm()); }
/// <summary> /// Search Occupation Type /// </summary> public OccupationTypeSearchRequestResponse SearchOccupationType(OccupationTypeSearchRequest request) { int rowCount; return(new OccupationTypeSearchRequestResponse { OccupationTypes = occupationTypeRepository.SearchOccupationType(request, out rowCount), TotalCount = rowCount }); }
/// <summary> /// Search Occupation Type /// </summary> public IEnumerable <OccupationType> SearchOccupationType(OccupationTypeSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <OccupationType, bool> > query = occupationType => (string.IsNullOrEmpty(request.OccupationTypeCodeNameText) || (occupationType.OccupationTypeCode.Contains(request.OccupationTypeCodeNameText)) || (occupationType.OccupationTypeName.Contains(request.OccupationTypeCodeNameText))); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(occupationTypeOrderByClause[request.OccupationTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(occupationTypeOrderByClause[request.OccupationTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }