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