Example #1
0
        private GeoLocation FindLocation(PointLatLng deviceLocation)
        {
            List <GeoLocation> list;

            using (var context = new NoiseMeterContext())
            {
                list = context.GeoLocations.ToList();
            }

            double lat = deviceLocation.Lat;
            double lng = deviceLocation.Lng;
            string wkt = $"POINT({lng} {lat})";

            DbGeography        selectedLocation = DbGeography.FromText(wkt);
            List <GeoLocation> wantedLocation   = (from location in list
                                                   where location.Location.SpatialEquals(selectedLocation)
                                                   select location).ToList();

            if (wantedLocation.Count > 1)
            {
                //throw new Exception("This should not happen!");
                Console.WriteLine(wantedLocation.Count);
            }

            if (wantedLocation.Count == 0)
            {
                return(null);
            }

            return(wantedLocation[0]);
        }
Example #2
0
        public DBUpdater(PointLatLng location)
        {
            double             lat         = location.Lat;
            double             lng         = location.Lng;
            string             wkt         = $"POINT({lng} {lat})";
            DbGeography        gpslocation = DbGeography.FromText(wkt);
            List <GeoLocation> geoLocationSuggestions;

            thisDeviceLocation = location;
            using (var noiseMeterContext = new NoiseMeterContext())
            {
                geoLocationSuggestions = (from geo in noiseMeterContext.GeoLocations.ToList()
                                          where geo.Location.Distance(gpslocation) < 100
                                          orderby geo.Location.Distance(gpslocation)
                                          select geo).ToList();
            }

            if (geoLocationSuggestions.Count == 0)
            {
                // New needs to be inserted
                MakeNewDeviceLocation(gpslocation);
            }
            else
            {
                thisGeolocation = geoLocationSuggestions[0];
            }
        }
Example #3
0
        public List <double> GetNewReadings(PointLatLng deviceLocation, DateTime filter)
        {
            try
            {
                if (!deviceLocation.Equals(monitoredDeviceLocation))
                {
                    monitoredDeviceLocation = deviceLocation;
                    monitoredGeolocation    = FindLocation(monitoredDeviceLocation);
                }
                List <double> readings;
                using (var context = new NoiseMeterContext())
                {
                    readings = (from reading in context.DeviceReadings
                                where reading.GeoLocationID == monitoredGeolocation.GeoLocationID && reading.Timestamp > filter
                                select reading.Noise).ToList();
                }

                return(readings);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return(null);
            }
        }
Example #4
0
        private void MakeNewDeviceLocation(DbGeography gpsLocation)
        {
            thisGeolocation = new GeoLocation()
            {
                Location = gpsLocation,
            };

            using (var context = new NoiseMeterContext())
            {
                context.GeoLocations.Add(thisGeolocation);
                context.SaveChanges();
            }
        }
Example #5
0
        public async void InsertReading(double decibels)
        {
            DeviceReadings readings = new DeviceReadings()
            {
                GeoLocationID = thisGeolocation.GeoLocationID,
                Noise         = decibels,
                Timestamp     = DateTime.Now
            };

            using (var context = new NoiseMeterContext())
            {
                context.DeviceReadings.Add(readings);
                await context.SaveChangesAsync();
            }
        }
Example #6
0
        public List <PointLatLng> GetDeviceLocations()
        {
            List <PointLatLng> points = new List <PointLatLng>();
            List <GeoLocation> list;

            using (var context = new NoiseMeterContext())
            {
                list = context.GeoLocations.ToList();
            }

            foreach (var location in list)
            {
                var pt = new PointLatLng((double)location.Location.Latitude, (double)location.Location.Longitude);
                points.Add(pt);
            }

            return(points);
        }