/// <summary> /// Get Insurance Types /// </summary> public InsuranceTypeSearchRequestResponse Get([FromUri] InsuranceTypeSearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(insuranceTypeService.SearchInsuranceType(request).CreateFromm()); }
/// <summary> /// Search Insurance Type /// </summary> public InsuranceTypeSearchRequestResponse SearchInsuranceType(InsuranceTypeSearchRequest request) { int rowCount; return(new InsuranceTypeSearchRequestResponse { InsuranceTypes = insuranceTypeRepository.SearchInsuranceType(request, out rowCount), TotalCount = rowCount }); }
/// <summary> /// Search Insurance Type /// </summary> public IEnumerable <InsuranceType> SearchInsuranceType(InsuranceTypeSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <InsuranceType, bool> > query = department => (string.IsNullOrEmpty(request.InsuranceTypeCodeNameText) || (department.InsuranceTypeCode.Contains(request.InsuranceTypeCodeNameText)) || (department.InsuranceTypeName.Contains(request.InsuranceTypeCodeNameText))); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(insuranceTypeOrderByClause[request.InsuranceTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(insuranceTypeOrderByClause[request.InsuranceTypeOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }