public IEnumerable <BarDto> GetBars(string[] cityParts)
{
if (cityParts == null || cityParts.Length == 0)
{
return((from bar in db.PlanetOsmPoint
where (bar.Amenity == "bar" || bar.Amenity == "pub")
select new BarDto
{
Name = bar.Name,
Id = Convert.ToInt32(bar.Id),
Lon = TransformationUtils.ParseLongtitudeToNormalFormat(bar.Way.X),
Lat = TransformationUtils.ParseLattitudeToNormalFormat(bar.Way.Y),
BarType = bar.Amenity
}).ToList());
}
return((from bar in db.PlanetOsmPoint where bar.Amenity == "bar" || bar.Amenity == "pub"
from cityPart in db.PlanetOsmPolygon where cityParts.Contains(cityPart.Name)
where cityPart.Way.Contains(bar.Way)
select new BarDto
{
Name = bar.Name,
Id = Convert.ToInt32(bar.Id),
Lon = TransformationUtils.ParseLongtitudeToNormalFormat(bar.Way.X),
Lat = TransformationUtils.ParseLattitudeToNormalFormat(bar.Way.Y),
BarType = bar.Amenity
}).ToList());
}
public IEnumerable <BarDto> GetBars(double centerLat, double centerLon, double radius)
{
var centerPoint = GetPoint(centerLon, centerLat);
return((from bar in db.PlanetOsmPoint
where (bar.Amenity == "bar" || bar.Amenity == "pub") && bar.Way.Distance(centerPoint) < radius
select new BarDto
{
Name = bar.Name,
Id = Convert.ToInt32(bar.Id),
Lon = TransformationUtils.ParseLongtitudeToNormalFormat(bar.Way.X),
Lat = TransformationUtils.ParseLattitudeToNormalFormat(bar.Way.Y),
BarType = bar.Amenity
}).ToList());
}
public IEnumerable <ShopDto> GetNearbyShops(int parkId, double radius)
{
var toReturn = (from park in db.PlanetOsmPolygon where park.Id == parkId
from shop in db.PlanetOsmPoint where shop.Shop == "alcohol" || shop.Shop == "wine" || shop.Shop == "supermarket" || shop.Shop == "tobacco" || shop.Shop == "coffe"
where shop.Way.Distance(park.Way) < radius
select new ShopDto
{
Name = shop.Name,
Id = Convert.ToInt32(shop.Id),
Lon = TransformationUtils.ParseLongtitudeToNormalFormat(shop.Way.X),
Lat = TransformationUtils.ParseLattitudeToNormalFormat(shop.Way.Y),
ShopType = shop.Shop
}).ToList();
return(toReturn);
}
public IEnumerable <StreetDto> GetStreetMapProperties(string[] streets)
{
var toReturn = (from street in db.PlanetOsmLine
where streets.Contains(street.Name)
select new StreetDto
{
Name = street.Name,
Id = Convert.ToInt32(street.Id),
Location = street.Way.Coordinates.Select(y => new double[]
{
TransformationUtils.ParseLongtitudeToNormalFormat(y.X),
TransformationUtils.ParseLattitudeToNormalFormat(y.Y)
}).ToList()
}).ToList();
return(toReturn);
}
public IEnumerable <ParkDto> GetParks(double centerLat, double centerLon, double radius)
{
var centerPoint = GetPoint(centerLon, centerLat);
//return (from park in db.PlanetOsmPolygon where park.Leisure == "park" && park.Way.Distance(centerPoint) < radius
var parksWithBenches = (from park in db.PlanetOsmPolygon where park.Leisure == "park" && park.Way.Distance(centerPoint) < radius
from bench in db.PlanetOsmPoint where bench.Amenity == "bench"
where park.Way.Contains(bench.Way)
select new ParkDto
{
Name = park.Name,
Id = Convert.ToInt32(park.Id),
Location = park.Way.Boundary.Coordinates.Select(y => new double[]
{
TransformationUtils.ParseLongtitudeToNormalFormat(y.X),
TransformationUtils.ParseLattitudeToNormalFormat(y.Y)
}).ToList(),
HasBenches = true
}).GroupBy(x => x.Id).Select(x => x.FirstOrDefault()).ToList();
var allParks = (from park in db.PlanetOsmPolygon where park.Leisure == "park" && park.Way.Distance(centerPoint) < radius
select new ParkDto
{
Name = park.Name,
Id = Convert.ToInt32(park.Id),
Location = park.Way.Boundary.Coordinates.Select(y => new double[]
{
TransformationUtils.ParseLongtitudeToNormalFormat(y.X),
TransformationUtils.ParseLattitudeToNormalFormat(y.Y)
}).ToList(),
HasBenches = false
}).ToList();
var toReturn = parksWithBenches;
foreach (var p in allParks)
{
if (toReturn.FirstOrDefault(x => x.Id == p.Id) == null)
{
toReturn.Add(p);
}
}
return(toReturn);
}
public IEnumerable <BarDto> GetBarsOnStreets(string[] streets)
{
if (streets == null || streets.Length == 0)
{
return(new List <BarDto>());
}
var toReturn = (from bar in db.PlanetOsmPoint where bar.Amenity == "bar" || bar.Amenity == "pub"
from street in db.PlanetOsmLine where streets.Contains(street.Name)
where street.Way.Distance(bar.Way) <= 25
select new BarDto
{
Name = bar.Name,
Id = Convert.ToInt32(bar.Id),
Lon = TransformationUtils.ParseLongtitudeToNormalFormat(bar.Way.X),
Lat = TransformationUtils.ParseLattitudeToNormalFormat(bar.Way.Y),
BarType = bar.Amenity
}).ToList();
return(toReturn);
}
public IEnumerable <ParkDto> GetParks(string[] cityParts)
{
var parksWithBenches = new List <ParkDto>();
var allParks = new List <ParkDto>();
var toReturn = new List <ParkDto>();
if (cityParts == null || cityParts.Length == 0)
{
parksWithBenches = (from park in db.PlanetOsmPolygon where park.Leisure == "park"
from bench in db.PlanetOsmPoint where bench.Amenity == "bench"
where park.Way.Contains(bench.Way)
select new ParkDto
{
Name = park.Name,
Id = Convert.ToInt32(park.Id),
Location = park.Way.Boundary.Coordinates.Select(y => new double[]
{
TransformationUtils.ParseLongtitudeToNormalFormat(y.X),
TransformationUtils.ParseLattitudeToNormalFormat(y.Y)
}).ToList(),
HasBenches = true
}).GroupBy(x => x.Id).Select(x => x.FirstOrDefault()).ToList();
allParks = (from park in db.PlanetOsmPolygon where park.Leisure == "park"
select new ParkDto
{
Name = park.Name,
Id = Convert.ToInt32(park.Id),
Location = park.Way.Boundary.Coordinates.Select(y => new double[]
{
TransformationUtils.ParseLongtitudeToNormalFormat(y.X),
TransformationUtils.ParseLattitudeToNormalFormat(y.Y)
}).ToList(),
HasBenches = false
}).ToList();
toReturn = parksWithBenches;
foreach (var p in allParks)
{
if (toReturn.FirstOrDefault(x => x.Id == p.Id) == null)
{
toReturn.Add(p);
}
}
return(toReturn);
}
parksWithBenches = (from park in db.PlanetOsmPolygon where park.Leisure == "park"
from cityPart in db.PlanetOsmPolygon where cityParts.Contains(cityPart.Name)
from bench in db.PlanetOsmPoint where bench.Amenity == "bench"
where park.Way.Within(cityPart.Way)
where park.Way.Contains(bench.Way)
select new ParkDto
{
Name = park.Name,
Id = Convert.ToInt32(park.Id),
Location = park.Way.Boundary.Coordinates.Select(y => new double[]
{
TransformationUtils.ParseLongtitudeToNormalFormat(y.X),
TransformationUtils.ParseLattitudeToNormalFormat(y.Y)
}).ToList(),
HasBenches = true
}).GroupBy(x => x.Id).Select(x => x.FirstOrDefault()).ToList();
allParks = (from park in db.PlanetOsmPolygon where park.Leisure == "park"
from cityPart in db.PlanetOsmPolygon where cityParts.Contains(cityPart.Name)
where park.Way.Within(cityPart.Way)
select new ParkDto
{
Name = park.Name,
Id = Convert.ToInt32(park.Id),
Location = park.Way.Boundary.Coordinates.Select(y => new double[]
{
TransformationUtils.ParseLongtitudeToNormalFormat(y.X),
TransformationUtils.ParseLattitudeToNormalFormat(y.Y)
}).ToList(),
HasBenches = false
}).ToList();
toReturn = parksWithBenches;
foreach (var p in allParks)
{
if (toReturn.FirstOrDefault(x => x.Id == p.Id) == null)
{
toReturn.Add(p);
}
}
return(toReturn);
}
