Ejemplo n.º 1
0
        internal IEnumerable <Location> GetByGeoSearch(double SearchLat, double SearchLong, int MilesDistance, Guid FilterByLocationTypeKey)
        {
            CurrentCollection.Clear();
            var sql = new Sql();

            sql.Select("*")
            .From <LocationDto>()
            .Append(GeographyHelper.GetGeoSearchSql(SearchLat, SearchLong, MilesDistance, FilterByLocationTypeKey));

            var dtoResult = Repositories.ThisDb.Query <LocationDto>(sql).ToList();

            var converter = new DtoConverter();

            CurrentCollection.AddRange(converter.ToLocationEntity(dtoResult));

            FillChildren();

            return(CurrentCollection);
        }