public async Task <IEnumerable <Store> > GetNearByAsync(double latitude, double longitude, int count) { return(await _context.Stores .OrderBy(s => MathCoordinates.GetDistance(s.Latitude, s.Longitude, latitude, longitude, 'M')) .Take(count) .ToListAsync()); }
public async Task <IEnumerable <Restaurant> > GetNearByAsync(double latitude, double longitude, int count) { return(await _context.Restaurants .OrderBy(r => MathCoordinates.GetDistance(r.Latitude, r.Longitude, latitude, longitude, 'M')) .Select(r => new Restaurant() { RestaurantId = r.RestaurantId, Name = r.Name, Description = r.Description, Address = r.Address, FamilyFriendly = r.FamilyFriendly, FoodType = r.FoodType, Latitude = r.Latitude, Longitude = r.Longitude, LevelOfNoise = r.LevelOfNoise, Phone = r.Phone, PriceLevel = r.PriceLevel, Rating = r.Rating, TakeAway = r.TakeAway }) .Take(count) .ToListAsync()); }
public async Task <IEnumerable <Lift> > GetNearByAsync(double latitude, double longitude) { return(await _context.Lifts .OrderBy(l => MathCoordinates.GetDistance(l.Latitude, l.Longitude, latitude, longitude, 'M')) .ToListAsync()); }