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();
}
}
