/// <summary> /// Get Design Grades /// </summary> public DesignGradeSearchRequestResponse Get([FromUri] DesignGradeSearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(designGradeService.SearchDesignGrade(request).CreateFrom()); }
/// <summary> /// Search Design Grade /// </summary> public DesignGradeSearchRequestResponse SearchDesignGrade(DesignGradeSearchRequest request) { int rowCount; return(new DesignGradeSearchRequestResponse { DesignGrades = desigGradeRepository.SearchDesigGrade(request, out rowCount), TotalCount = rowCount }); }
/// <summary> /// Search Desig Grade /// </summary> public IEnumerable <DesignGrade> SearchDesigGrade(DesignGradeSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <DesignGrade, bool> > query = desigGrade => (string.IsNullOrEmpty(request.DesigGradeFilterText) || (desigGrade.DesigGradeCode.Contains(request.DesigGradeFilterText)) || (desigGrade.DesigGradeName.Contains(request.DesigGradeFilterText))); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(desigGradeOrderByClause[request.DesignGradeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(desigGradeOrderByClause[request.DesignGradeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }