prs/prs.desktop/Panels/GPSTrackers/GPSTrackerLocationGrid.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Controls;
using Comal.Classes;
using Comal.Stores;
using InABox.Clients;
using InABox.Core;
using InABox.DynamicGrid;
using InABox.WPF;

namespace PRSDesktop
{
    internal class GPSTrackerLocationGrid : DynamicOneToManyGrid<GPSTracker, GPSTrackerLocation>
    {
        private static List<Tuple<double, double, string>> _cache;

        public GPSTrackerLocationGrid()
        {
            Options.AddRange(
                DynamicGridOption.SelectColumns, 
                DynamicGridOption.RecordCount,
                DynamicGridOption.FilterRows
            );
            Criteria.Add(
                new Filter<GPSTrackerLocation>(x => x.Location.Timestamp).IsGreaterThanOrEqualTo(DateTime.Now.AddDays(-1))
            );

            ActionColumns.Add(new DynamicMapColumn<GPSTrackerLocation>(this, x => x.Location));

            AddButton("Get Addresses", null, GetAddressClick);
        }

        public string ReverseGeocode(double latitude, double longitude)
        {
            if (_cache == null)
                _cache = new Client<GPSTrackerLocation>().Query(
                    new Filter<GPSTrackerLocation>(x => x.Location.Address).IsNotEqualTo(""),
                    new Columns<GPSTrackerLocation>(
                        x => x.Location.Address,
                        x => x.Location.Longitude,
                        x => x.Location.Latitude
                    )
                ).Rows.Select(r => new Tuple<double, double, string>(
                    r.Get<GPSTrackerLocation, double>(c => c.Location.Latitude),
                    r.Get<GPSTrackerLocation, double>(c => c.Location.Longitude),
                    r.Get<GPSTrackerLocation, string>(c => c.Location.Address)
                )).ToList();
            var tuple = _cache.FirstOrDefault(x => Equals(x.Item1, latitude) && Equals(x.Item2, longitude));
            if (tuple == null)
            {
                var address = StoreUtils.ReverseGeocode(latitude, longitude);
                if (!string.IsNullOrWhiteSpace(address))
                {
                    tuple = new Tuple<double, double, string>(latitude, longitude, address);
                    _cache.Add(tuple);
                }
            }

            return tuple != null ? tuple.Item3 : "";
        }

        private bool GetAddressClick(Button arg1, CoreRow[] arg2)
        {
            var result = false;
            var rows = Data.Rows.Where(r =>
                string.IsNullOrWhiteSpace(r.Get<GPSTrackerLocation, string>(c => c.Location.Address))
                && !Equals(r.Get<GPSTrackerLocation, double>(c => c.Location.Latitude), 0.0F)
                && !Equals(r.Get<GPSTrackerLocation, double>(c => c.Location.Longitude), 0.0F)
            );
            Progress.ShowModal("Updating Addresses", progress =>
            {
                foreach (var row in rows)
                {
                    var item = LoadItem(row);
                    var address = ReverseGeocode(
                        row.Get<GPSTrackerLocation, double>(x => x.Location.Latitude),
                        row.Get<GPSTrackerLocation, double>(x => x.Location.Longitude)
                    );
                    if (!string.IsNullOrWhiteSpace(address))
                    {
                        item.Location.Address = address;
                        UpdateRow<GPSTrackerLocation, string>(row, x => x.Location.Address, address, false);
                        result = true;
                    }
                }
            });
            return result;
        }
    }
}