/// <summary> /// Get Vehicle Statuses /// </summary> public VehicleStatusSearchRequestResponse Get([FromUri] VehicleStatusSearchRequest oppRequest) { if (oppRequest == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(vehicleStatusService.SearchVehicleStatus(oppRequest).CreateFrom()); }
/// <summary> /// Search Vehicle Status /// </summary> public VehicleStatusSearchRequestResponse SearchVehicleStatus(VehicleStatusSearchRequest request) { int rowCount; return(new VehicleStatusSearchRequestResponse { VehicleStatuses = vehicleStatusRepository.SearchVehicleStatus(request, out rowCount), TotalCount = rowCount }); }
/// <summary> /// SearchD Vehicle Statuse /// </summary> public IEnumerable <VehicleStatus> SearchVehicleStatus(VehicleStatusSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <VehicleStatus, bool> > query = vehicleStatus => (string.IsNullOrEmpty(request.VehicleStatusCodeNameFilterText) || (vehicleStatus.VehicleStatusCode.Contains(request.VehicleStatusCodeNameFilterText)) || (vehicleStatus.VehicleStatusName.Contains(request.VehicleStatusCodeNameFilterText))); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(vehicleStatusOrderByClause[request.VehicleStatusOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(vehicleStatusOrderByClause[request.VehicleStatusOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }