/// <summary> /// Get Vehicle CheckLists /// </summary> public VehicleCheckListSearchRequestResponse Get([FromUri] VehicleCheckListSearchRequest request) { if (request == null || !ModelState.IsValid) { throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request"); } return(vehicleCheckListService.SearchVehicleCheckList(request).CreateFrom()); }
/// <summary> /// Search Vehicle CheckList /// </summary> public VehicleCheckListSearchRequestResponse SearchVehicleCheckList(VehicleCheckListSearchRequest request) { int rowCount; return(new VehicleCheckListSearchRequestResponse { VehicleCheckLists = vehicleCheckListRepository.SearchVehicleCheckList(request, out rowCount), TotalCount = rowCount }); }
/// <summary> /// Search Vehicle CheckList /// </summary> public IEnumerable <VehicleCheckList> SearchVehicleCheckList(VehicleCheckListSearchRequest request, out int rowCount) { int fromRow = (request.PageNo - 1) * request.PageSize; int toRow = request.PageSize; Expression <Func <VehicleCheckList, bool> > query = vehicleCheckList => (string.IsNullOrEmpty(request.VehicleCheckListFilterText) || (vehicleCheckList.VehicleCheckListCode.Contains(request.VehicleCheckListFilterText)) || (vehicleCheckList.VehicleCheckListName.Contains(request.VehicleCheckListFilterText))); rowCount = DbSet.Count(query); return(request.IsAsc ? DbSet.Where(query) .OrderBy(vehicleCheckListOrderByClause[request.VehicleCheckListOrderBy]) .Skip(fromRow) .Take(toRow) .ToList() : DbSet.Where(query) .OrderByDescending(vehicleCheckListOrderByClause[request.VehicleCheckListOrderBy]) .Skip(fromRow) .Take(toRow) .ToList()); }