public async Task <DataGetResult <City> > GetByFilterAsync(CityFilter filter) { try { var bson = new BsonDocument { { "CountryId", new ObjectId(filter.CountryId.ToString()) } }; var asyncCursor = await Collection.FindAsync(bson); var dbCities = asyncCursor.ToList(); if (dbCities == null || false == dbCities.Any()) { return(new DataGetResult <City>()); } var entities = dbCities .AsQueryable() .Select(c => mapToEntity(c)) .ToList(); return(new DataGetResult <City>(entities)); } catch (Exception ex) { Logger.Error(ex); return(new DataGetResult <City>(ex)); } }
public AFilterSetBase <IObjectBase> Initialize(IClient client) { var item = new CityFilter("City Filters"); item.Filters.Add(new CityBase()); return(item); }
public async Task <IActionResult> Get([FromQuery] CityFilter filter) { if (!ModelState.IsValid) { return(BadRequest()); } return(Ok(await _cityRepository.SearchAsync(filter))); }
protected virtual async Task <List <City> > GetAllCities() { var filter = new CityFilter { Page = 1, PerPage = 1000, }; var results = await _cityRepository.SearchAsync(filter); return(results.ToList()); }
public async Task <GetResult <City> > GetByFilterAsync(CityFilter filter) { try { var result = await _repository.GetByFilterAsync(filter); return(result.ToBLLResult()); } catch (Exception ex) { Logger.Error(ex); return(new GetResult <City>(ex)); }; }
public async Task <IEnumerable <City> > SearchAsync(CityFilter filter) { var query = entities.AsQueryable(); if (!string.IsNullOrWhiteSpace(filter.Name)) { query = query.Where(c => c.Name.StartsWith(filter.Name)); } query = query.OrderBy(c => c.Name); query = base.SearchAsync(query, filter); return(await query.ToListAsync()); }
protected async Task GetRoutes() { var userId = await LocalStorageManagerService.GetPermanentItemAsync("UserId"); CityFilter cityFilter = new CityFilter { UserId = userId }; var result = (await CitiesDataService.GetRoutes(cityFilter.GetFilter())); if (result?.Routes.Count > 0) { LastRoutes = result; } else { ShowUnSuccessAlert("You have no routes saved in our DB!"); } StateHasChanged(); }
public IHttpActionResult GetByCode(CityFilter filter) { try { var result = DaoCity.GetByCode(filter.IATACode); var respuesta = new { errorCode = 0, messageError = "Consulta correcta.", city = result }; return(Ok(respuesta)); } catch (Exception ex) { CatchError.Log4Net("ERROR", ex); return(BadRequest(ex.Message)); } }
public async Task <IActionResult> Lookup(string countryId) { try { var filter = new CityFilter(); filter.CountryId = countryId; var result = await _service.GetByFilterAsync(filter); if (result.Status == BusinessOperationStatus.Failure) { return(Exception(result)); } return(Ok(result.Entities)); } catch (Exception ex) { Logger.Error(ex); return(Exception(ex)); } }
private async void FilterData(object obj) { Window mainWindow = (Window)obj; List <Specification <People> > SpecList = new List <Specification <People> >(); CheckBox DateCheck = mainWindow.FindName("FilterByDateCheck") as CheckBox; CheckBox NameCheck = mainWindow.FindName("FilterByNameCheck") as CheckBox; CheckBox LNameCheck = mainWindow.FindName("FilterByLastNameCheck") as CheckBox; CheckBox SNameCheck = mainWindow.FindName("FilterBySurNameCheck") as CheckBox; CheckBox CityCheck = mainWindow.FindName("FilterByCityCheck") as CheckBox; CheckBox CountryCheck = mainWindow.FindName("FilterByCountryCheck") as CheckBox; if (DateCheck.IsChecked == true) { if (DateFilter == null || DateFilter.Replace(" ", "").Length == 0) { EmptyFieldMessage(mainWindow, "DateFilter"); } else { SpecList.Add(new FindByDateSpecification(DateTime.Parse(DateFilter))); } } if (NameCheck.IsChecked == true) { if (NameFilter == null || NameFilter.Replace(" ", "").Length == 0) { EmptyFieldMessage(mainWindow, "NameFilter"); } else { SpecList.Add(new FindByNameSpecification(NameFilter)); } } if (LNameCheck.IsChecked == true) { if (LastNameFilter == null || LastNameFilter.Replace(" ", "").Length == 0) { EmptyFieldMessage(mainWindow, "LastNameFilter"); } else { SpecList.Add(new FindByLastNameSpecification(LastNameFilter)); } } if (SNameCheck.IsChecked == true) { if (SurNameFilter == null || SurNameFilter.Replace(" ", "").Length == 0) { EmptyFieldMessage(mainWindow, "SurNameFilter"); } else { SpecList.Add(new FindBySurNameSpecification(SurNameFilter)); } } if (CityCheck.IsChecked == true) { if (CityFilter == null || CityFilter.Replace(" ", "").Length == 0) { EmptyFieldMessage(mainWindow, "CityFilter"); } else { SpecList.Add(new FindByCitySpecification(CityFilter)); } } if (CountryCheck.IsChecked == true) { if (CountryFilter == null || CountryFilter.Replace(" ", "").Length == 0) { EmptyFieldMessage(mainWindow, "CountryFilter"); } else { SpecList.Add(new FindByCountrySpecification(CountryFilter)); } } if (SpecList.Count > 0) { Specification <People> specification = SpecList[0]; SpecList.RemoveAt(0); foreach (var spec in SpecList) { specification.And(spec); } using (IRepository <People> Repository = new PeopleRepository()) PeopleCollection = await Repository.Find(specification); } else { using (IRepository <People> Repository = new PeopleRepository()) PeopleCollection = await Repository.GetObjectsList(); } }