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);
}
}
}
});
});
}
public static string GetConnectionString(PostgreServerDataRepositoryItem serverItem, string dbName)
{
return(GetConnectionString(serverItem.Server
, dbName
, serverItem.Port
, serverItem.UserName
, serverItem.Password));
}
private Collection <PostgreSqlFeatureLayer> GetPostgreSqlFeatureLayers()
{
PostgreSchemaDataRepositoryItem schemaItem = Parent.Parent as PostgreSchemaDataRepositoryItem;
if (schemaItem != null)
{
DatabaseDataRepositoryItem databaseItem = schemaItem.Parent.Parent as DatabaseDataRepositoryItem;
if (databaseItem != null)
{
PostgreServerDataRepositoryItem serverItem = databaseItem.Parent as PostgreServerDataRepositoryItem;
if (serverItem != null)
{
string connectionString = PostgreServerDataRepositoryPlugin.GetConnectionString(serverItem, databaseItem.Name);
if (string.IsNullOrEmpty(idColumnName))
{
try
{
PostgreSqlFeatureSource featureSource = new PostgreSqlFeatureSource(connectionString, Name, "oid");
featureSource.SchemaName = schemaItem.SchemaName;
featureSource.Open();
List <string> newColumnNames = featureSource.GetColumns().Select(c => c.ColumnName).ToList();
featureSource.Close();
FeatureIdColumnWindow featureIdColumnWindow = new FeatureIdColumnWindow(newColumnNames);
featureIdColumnWindow.Owner = Application.Current.MainWindow;
featureIdColumnWindow.WindowStartupLocation = WindowStartupLocation.CenterOwner;
if (featureIdColumnWindow.ShowDialog().GetValueOrDefault())
{
IdColumnName = featureIdColumnWindow.FeatureIdColumn;
}
}
catch { }
}
if (string.IsNullOrEmpty(IdColumnName))
{
return(new Collection <PostgreSqlFeatureLayer>());
}
string[] tableInfo = tableName.Split(':');
string url = "postgreSqlFeatureLayer:{0}|{1}|{2}|{3}";
url = String.Format(CultureInfo.InvariantCulture, url, tableInfo[1], tableInfo[0], connectionString, idColumnName);
Uri layerUri = new Uri(url);
GetLayersParameters layerParameters = new GetLayersParameters();
layerParameters.LayerUris.Add(layerUri);
Collection <PostgreSqlFeatureLayer> newLayers = GisEditor.LayerManager.GetLayers <PostgreSqlFeatureLayer>(layerParameters);
if (newLayers.Count > 0)
{
return(newLayers);
}
}
}
}
return(new Collection <PostgreSqlFeatureLayer>());
}
private void AddServer()
{
PostgreServerConfigureWindow configureWindow = new PostgreServerConfigureWindow();
configureWindow.Owner = Application.Current.MainWindow;
configureWindow.WindowStartupLocation = WindowStartupLocation.CenterOwner;
if (configureWindow.ShowDialog().GetValueOrDefault())
{
PostgreServerDataRepositoryItem serverItem = new PostgreServerDataRepositoryItem();
serverItem.Parent = rootItem;
SyncToServerItem(configureWindow.Result, serverItem);
rootItem.Children.Add(serverItem);
GisEditor.InfrastructureManager.SaveSettings(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 { }
}
}
