public IList <IDictionary <string, object> > FindCities2(IDictionary <string, object> filter) { IList <IDictionary <string, object> > listResult = new List <IDictionary <string, object> >(); WMap wmFilter = new WMap(filter); string countryCode = wmFilter.GetString("countryCode"); if (countryCode == null || countryCode.Length == 0) { return(listResult); } string sSQL = "SELECT ID,NAME FROM CITY WHERE COUNTRYCODE=@countryCode ORDER BY NAME"; DbConnection conn = null; DbCommand cmd = null; DbDataReader dr = null; try { conn = GetDefaultConnection(); cmd = CreateCommand(sSQL, conn); cmd.Prepare(); AddParameter(cmd, "@countryCode", countryCode); dr = cmd.ExecuteReader(); while (dr.Read()) { IDictionary <string, object> record = new Dictionary <string, object>(); record["id"] = dr[0]; record["name"] = dr[1]; listResult.Add(record); } } finally { if (dr != null) { dr.Close(); } if (conn != null) { conn.Close(); } } return(listResult); }
public IslandImportWindow(WMap map) { InitializeComponent(); foreach (WScene scene in map.SceneList) { if (scene is WStage) { continue; } byte room_no = 0; string room_removed = scene.Name.ToLowerInvariant().Replace("room", ""); byte.TryParse(room_removed, out room_no); RoomCombo.Items.Add($"Room { room_no }"); } }
public Waypoint getClosestWaypointForMap(short mapID, Waypoint location) { if (!towns.ContainsKey(mapID)) { return(null); } List <Waypoint> townsForCertainMap = new List <Waypoint>(towns[mapID]); Dictionary <float, Waypoint> distances = new Dictionary <float, Waypoint>(); for (int i = 0; i < townsForCertainMap.Count; i++) { distances.Add(WMap.distance(townsForCertainMap[i].getX(), townsForCertainMap[i].getY(), location.getX(), location.getY()), townsForCertainMap[i]); } distances = distances.OrderBy(k => k.Key).ToDictionary(k => k.Key, k => k.Value); if (distances.Count == 0) { return(null); } return(distances.ElementAt(0).Value); }
protected override void OnElementChanged(ElementChangedEventArgs <View> e) { base.OnElementChanged(e); if (e.OldElement != null) { var nativeMap = Control as MKMapView; nativeMap.GetViewForAnnotation = null; nativeMap.CalloutAccessoryControlTapped -= OnCalloutAccessoryControlTapped; nativeMap.DidSelectAnnotationView -= OnDidSelectAnnotationView; nativeMap.DidDeselectAnnotationView -= OnDidDeselectAnnotationView; } if (e.NewElement != null) { var formsMap = (WMap)e.NewElement; MapView = Control as MKMapView; MapControl = (WMap)e.NewElement; MapView.GetViewForAnnotation = GetViewForAnnotation; MapView.CalloutAccessoryControlTapped += OnCalloutAccessoryControlTapped; MapView.DidSelectAnnotationView += OnDidSelectAnnotationView; MapView.DidDeselectAnnotationView += OnDidDeselectAnnotationView; } }