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 { }
}
}
