private async void LoadCities()
{
dialogService.ShowProgress();
RequestCities request = new RequestCities
{
DepartamentCode = DepartamentSelected.Code
};
ResponseCities response = await apiService.GetCities(request);
ValidateResponseCities(response);
dialogService.HideProgress();
}
public ActionResult GetCitiesInVoivoidship(RequestCities voivoidship)
{
// TODO: Sort by popularity?
var result = dbContext.Places
.Where(p => p.Voivoidship == voivoidship.Name || (string.IsNullOrEmpty(voivoidship.Name)))
.Select <Place, string>(p => p.City)
.OrderBy(v => v)
.Distinct()
.Take(10)
.ToList();
return(Json(new {
cities = result
}));
}
public ActionResult GetCitiesInVoivoidshipWithCount(RequestCities voivoidship)
{
// TODO: Sort by popularity?
var result = dbContext.Places
.Where(p => (p.Voivoidship == voivoidship.Name || (string.IsNullOrEmpty(voivoidship.Name))) && p.IsPaid)
.GroupBy(place => place.City)
.Select(group => new CititesInVoivoidshipWithCount {
City = group.Key, PlacesCount = group.Count()
})
.OrderByDescending(cities => cities.PlacesCount)
.Take(10)
.ToList <CititesInVoivoidshipWithCount>();
return(Json(new
{
cities = result
}));
}
