public async Task <IActionResult> Get([FromQuery] SearchCriteriaDTO criteria) { try { var collection = await _repository.GetCollectionAsync(_mappingService.MapSearchCriteria(criteria)); if (collection == null) { return(NotFound("No Collection data found for specified criteria.")); } // TODO - return urls in pagination ... // page=1 - last & next // page=end - first & prev // all other pages - first, last, prev, next DiscogsDTO result = _mappingService.MapCollection(collection); return(Ok(result)); } catch (Exception ex) { _logger.LogError($"Exception occured while getting Collection: {ex}"); } return(BadRequest()); }
public IActionResult Remove(SearchCriteriaDTO searchCriteria, int phonebookId, int entryId) { _logger.LogInformation($"[Phonebook Controller] Received search request, phonebookId:{phonebookId}"); var PhoneEntries = _phoneService.RemoveContact(searchCriteria.EntryName, searchCriteria.EntryNumber, phonebookId, entryId); return(Ok(PhoneEntries)); }
public IActionResult GetBoughtItems(SearchCriteriaDTO searchDTO, BoughtItemsOrderBy orderBy = BoughtItemsOrderBy.Name) { var userId = User.FindFirst(ClaimTypes.NameIdentifier).Value; searchDTO.UserId = userId; var result = _itemService.GetBoughtItems(orderBy, searchDTO); return(Json(result)); }
public List <ResultsDTO> getResults(LoginDTO credentials, SearchCriteriaDTO criteria) { List <Item> items; using (SearchDAL db = new SearchDAL(credentials.username, credentials.password)) { items = db.getItems(criteria); } return(resultsDTOConversion(items)); }
public List <RestaurantSearchDTO> GetRestaurantsByAnyCriteria(SearchCriteriaDTO criteria, string searchText) { List <RestaurantSearchDTO> RestaurantSearchDTOList = new List <RestaurantSearchDTO>(); try { RestaurantSearchDTOList = this._rawSQLDbContext.GetRestaurantsByAnyCriteria(criteria, searchText); } catch (Exception ex) { throw ex; } return(RestaurantSearchDTOList); }
public List <RestaurantSearchDTO> GetNearRestaurants(SearchCriteriaDTO criteria) { List <RestaurantSearchDTO> RestaurantSearchDTOList = new List <RestaurantSearchDTO>(); try { RestaurantSearchDTOList = this._rawSQLDbContext.GetNearRestaurants(criteria); } catch (Exception ex) { throw ex; } return(RestaurantSearchDTOList); }
public List <MenuItemSearchDTO> GetAllNearByMenuItems(SearchCriteriaDTO criteria) { List <MenuItemSearchDTO> MenuItemSearchDTOList = new List <MenuItemSearchDTO>(); try { MenuItemSearchDTOList = this._rawSQLDbContext.GetAllNearByMenuItems(criteria); } catch (Exception ex) { throw ex; } return(MenuItemSearchDTOList); }
public PagedWaitingItemsDTO GetWaitingItems(WaitingItemsOrderBy orderBy, SearchCriteriaDTO searchDTO) { var c = searchDTO; var orderSpec = new OrderWaitingItemSpecyfication(orderBy); var predicateSpec = new ItemSpecyfication(Status.Waiting, searchDTO.UserId, searchDTO.Phrase); var items = _unitOfWork.ItemRepo.GetSortedItems(predicateSpec, orderSpec); List <Item> list = items.Skip((c.PageIndex - 1) * c.AmountOfPages).Take(c.AmountOfPages).ToList(); var result = new PagedWaitingItemsDTO() { TotalAmount = items.Count(), Items = _mapper.Map <List <Item>, List <WaitingItemDTO> >(list) }; return(result); }
public List <RestaurantDTO> SearchRestaurants(SearchCriteriaDTO searchCriteria) { List <RestaurantDTO> Restaurants = default(List <RestaurantDTO>); if (searchCriteria != null) { using (IEateryDbContext context = _unitOfWork.GetEateryDbContext()) { List <Restaurant> RestaurantList = this._RestaurantRepository.GetAllQuery(context).ToList(); if (RestaurantList != null && RestaurantList.Any()) { Restaurants = ObjectTypeConverter.ConvertList <Restaurant, RestaurantDTO>(RestaurantList).ToList(); } } } return(Restaurants); }
public async Task <IActionResult> Get([FromQuery] SearchCriteriaDTO criteria) { try { var wantlist = await _repository.GetWantlistAsync(_mappingService.MapSearchCriteria(criteria)); if (wantlist == null) { return(NotFound("No Wantlist data found for specified criteria.")); } DiscogsDTO result = _mappingService.MapWantlist(wantlist); return(Ok(result)); } catch (Exception ex) { _logger.LogError($"Exception occured while getting Wantlist: {ex}"); } return(BadRequest()); }
public List <Item> getItems(SearchCriteriaDTO criteria) { String queryString; if (criteria.sortZ == true) { if (criteria.categoryID == 0) { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemName DESC"; } else { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_CategoryID = @categoryKey AND fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemName DESC"; } } else if (criteria.sortHighValue == true) { if (criteria.categoryID == 0) { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemPrice DESC"; } else { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_CategoryID = @categoryKey AND fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemPrice DESC"; } } else if (criteria.sortLowValue == true) { if (criteria.categoryID == 0) { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemPrice ASC"; } else { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_CategoryID = @categoryKey AND fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemPrice ASC"; } } else { if (criteria.categoryID == 0) { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemName ASC"; } else { queryString = @"SELECT ItemName, ItemPrice, Description FROM Item WHERE fk_CategoryID = @categoryKey AND fk_personID = @personKey AND ItemPrice < @maxPrice ORDER BY ItemName ASC"; } } SqlCommand userQuery = new SqlCommand(queryString, conn); userQuery.Parameters.Add(new SqlParameter("@categoryKey", SqlDbType.Int)); userQuery.Parameters.Add(new SqlParameter("@personKey", SqlDbType.Int)); userQuery.Parameters.Add(new SqlParameter("@maxPrice", SqlDbType.Decimal)); userQuery.Parameters["@categoryKey"].Value = criteria.categoryID; userQuery.Parameters["@personKey"].Value = criteria.personID; userQuery.Parameters["@maxPrice"].Value = criteria.maxMoney; return(readItems(userQuery)); }