public override void FinalizeRun() { TotalProcessTime.Start(); List <GSAKWrapper.MapProviders.GeocachePoco> gcl = null; double?cLat = null; double?cLon = null; using (var db = new NPoco.Database(DatabaseConnection.Connection, NPoco.DatabaseType.SQLite)) { gcl = db.Fetch <GSAKWrapper.MapProviders.GeocachePoco>(string.Format("select Code, Name, CacheType, Found, IsOwner, Latitude, Longitude, kAfterLat, kAfterLon from Caches inner join {0} on Caches.Code={0}.gccode left join Corrected on Caches.Code=Corrected.kCode", ActionInputTableName)); } if (gcl.Count > 0) { var dr = DatabaseConnection.ExecuteReader(string.Format("select AVG(Latitude), AVG(Longitude) from Caches inner join {0} on Caches.Code={0}.gccode left join Corrected on Caches.Code=Corrected.kCode", ActionInputTableName)); if (dr.Read()) { cLat = dr.GetDouble(0); cLon = dr.GetDouble(1); } } _context.Send(new SendOrPostCallback(delegate(object state) { var wnd = new Dialogs.WindowOSMOfflineMap(gcl, cLat, cLon, 16); wnd.Show(); }), null); TotalProcessTime.Stop(); base.FinalizeRun(); }
public override void FinalizeRun() { TotalProcessTime.Start(); List<GSAKWrapper.MapProviders.GeocachePoco> gcl = null; double? cLat = null; double? cLon = null; using (var db = new NPoco.Database(DatabaseConnection.Connection, NPoco.DatabaseType.SQLite)) { gcl = db.Fetch<GSAKWrapper.MapProviders.GeocachePoco>(string.Format("select Code, Name, CacheType, Found, IsOwner, Latitude, Longitude, kAfterLat, kAfterLon from Caches inner join {0} on Caches.Code={0}.gccode left join Corrected on Caches.Code=Corrected.kCode", ActionInputTableName)); } if (gcl.Count > 0) { var dr = DatabaseConnection.ExecuteReader(string.Format("select AVG(Latitude), AVG(Longitude) from Caches inner join {0} on Caches.Code={0}.gccode left join Corrected on Caches.Code=Corrected.kCode", ActionInputTableName)); if (dr.Read()) { cLat = dr.GetDouble(0); cLon = dr.GetDouble(1); } } _context.Send(new SendOrPostCallback(delegate(object state) { var wnd = new Dialogs.WindowOSMOfflineMap(gcl, cLat, cLon, 16); wnd.Show(); }), null); TotalProcessTime.Stop(); base.FinalizeRun(); }
void b_Click(object sender, RoutedEventArgs e) { var wnd = new Dialogs.WindowOSMOfflineMap(null, null, null, 13); wnd.Show(); }