internal static void SyncToServerItem(PostgreConfigureInfo configureInfo, PostgreServerDataRepositoryItem serverItem, bool resetDatabases = false) { serverItem.Name = configureInfo.Server; serverItem.Server = configureInfo.Server; serverItem.Port = configureInfo.Port; serverItem.UserName = configureInfo.UserName; serverItem.Password = configureInfo.Password; GetDatabasesParameter parameter = new GetDatabasesParameter(); parameter.ServerItem = serverItem; parameter.ResetDatabases = resetDatabases; foreach (var item in configureInfo.DbaseNames) { parameter.DatabaseNames.Add(item); } Task <Collection <DatabaseModel> > task = new Task <Collection <DatabaseModel> >(GetDatabaseItems, parameter); task.Start(); task.ContinueWith(t => { Application.Current.Dispatcher.BeginInvoke(() => { if (t.Result.Count > 0) { serverItem.Children.Clear(); foreach (var databaseItem in t.Result) { if (databaseItem.TableModels.Count > 0) { DatabaseDataRepositoryItem dbItem = new DatabaseDataRepositoryItem(); dbItem.Name = databaseItem.Name; var groupItems = databaseItem.TableModels.GroupBy(g => g.SchemaName); DataRepositoryItem schemaItem = new DataRepositoryItem(); schemaItem.Name = String.Format(CultureInfo.InvariantCulture, "{0} ({1})", "Schemas", groupItems.Count()); schemaItem.Icon = new BitmapImage(new Uri("/GisEditorPluginCore;component/Images/schemas.png", UriKind.RelativeOrAbsolute)); dbItem.Children.Add(schemaItem); foreach (var group in groupItems) { IEnumerable <string> tableGroup = group.Where(v => !v.IsView).Select(g => g.Name); IEnumerable <string> viewGroup = group.Where(v => v.IsView).Select(g => g.Name); AddSchemaChildrens(schemaItem, tableGroup, viewGroup, "/GisEditorPluginCore;component/Images/tablefolder.png", group.Key, databaseItem.Name); } serverItem.Children.Add(dbItem); DataRepositoryContentViewModel.RestoreChildrenExpandStatus(new ObservableCollection <DataRepositoryItem> { serverItem }, GisEditor.DataRepositoryManager.ExpandedFolders); } } } }); }); }
protected override void RefreshCore() { Task.Factory.StartNew(new Action(() => { PostgreConfigureInfo postgreInfo = new PostgreConfigureInfo(); Collection <string> newDbNames = PostgreSqlFeatureSource.GetDatabaseNames(Server, Port, UserName, Password); foreach (var item in newDbNames) { postgreInfo.DbaseNames.Add(item); } postgreInfo.Server = server; postgreInfo.Port = port; postgreInfo.UserName = userName; postgreInfo.Password = password; PostgreServerDataRepositoryPlugin.SyncToServerItem(postgreInfo, this); })); }
protected override void ApplySettingsCore(StorableSettings settings) { base.ApplySettingsCore(settings); if (settings.GlobalSettings.ContainsKey("Servers")) { try { if (rootItem != null) { rootItem.Children.Clear(); XElement serversElement = XElement.Parse(settings.GlobalSettings["Servers"]); serversElement.Elements("Server").ForEach(item => { string serverString = item.Value; serverString = StringProtector.Instance.Decrypt(serverString); string[] server = serverString.Split('|'); PostgreServerDataRepositoryItem serverItem = new PostgreServerDataRepositoryItem(); serverItem.Name = server[0]; serverItem.Server = server[0]; serverItem.Port = Int32.Parse(server[1]); serverItem.UserName = server[2]; serverItem.Password = server[3]; rootItem.Children.Add(serverItem); PostgreConfigureInfo configureInfo = new PostgreConfigureInfo(); configureInfo.Server = serverItem.Server; configureInfo.Port = serverItem.Port; configureInfo.UserName = serverItem.UserName; configureInfo.Password = serverItem.Password; SyncToServerItem(configureInfo, serverItem, true); }); } } catch { } } }