public IEnumerable<AdvertisementItem> GetAdvertisementsFromDeclaredArea(CoordinatesForSearchingAdvertisementsModel coordinatesForSearchModel, int page) {
return dbContext.AdvertisementItem.Include(a => a.AdvertisementPhotos).Where(a => a.Latitude >= coordinatesForSearchModel.LatitudeStart
&& a.Latitude <= coordinatesForSearchModel.LatitudeEnd
&& a.Longitude >= coordinatesForSearchModel.LongitudeStart
&& a.Longitude <= coordinatesForSearchModel.LongitudeEnd)
.Skip(10 * page).Take(10);
}
public CoordinatesForSearchingAdvertisementsModel GetCoordinatesForSearchingAdvertisements(double lat, double lon, int distanceInKm) {
double radius = ((double)distanceInKm) / 2;
var model = new CoordinatesForSearchingAdvertisementsModel();
model.LatitudeStart = lat - (radius * DEGRESS_PER_KILOMETER);
model.LatitudeEnd = lat + (radius * DEGRESS_PER_KILOMETER);
model.LongitudeStart = lon - (radius * DEGRESS_PER_KILOMETER);
model.LongitudeEnd = lon + (radius * DEGRESS_PER_KILOMETER);
return model;
}
