public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e)
{
FormConnectionString dlg = new FormConnectionString();
dlg.ProviderID = "postgre";
dlg.UseProviderInConnectionString = false;
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
DbConnectionString dbConnStr = dlg.DbConnectionString;
ConfigConnections connStream = new ConfigConnections("postgis", "546B0513-D71D-4490-9E27-94CD5D72C64A");
string connectionString = dbConnStr.ConnectionString;
string id = ConfigTextStream.ExtractValue(connectionString, "database");
id = connStream.GetName(id);
connStream.Add(id, dbConnStr.ToString());
e.NewExplorerObject = new PostGISExplorerObject(this.ParentExplorerObject, id, dbConnStr);
//string connStr = dlg.ConnectionString;
//ConfigTextStream stream = new ConfigTextStream("postgis_connections", true, true);
//string id = ConfigTextStream.ExtractValue(connStr, "Database");
//id += "@" + ConfigTextStream.ExtractValue(connStr, "Server");
//if (id == "@") id = "PostGIS Connection";
//stream.Write(connStr, ref id);
//stream.Close();
//e.NewExplorerObject = new PostGISExplorerObject(id, dlg.ConnectionString);
}
}
private void getConnectionString_Click(object sender, EventArgs e)
{
DbConnectionString dbConnStr = new DbConnectionString();
dbConnStr.FromString(txtConnectionString.Text);
FormConnectionString dlg = new FormConnectionString(dbConnStr);
dlg.UseProviderInConnectionString = true;
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
dbConnStr = dlg.DbConnectionString;
txtConnectionString.Text = dbConnStr.ToString();
}
}
async private void btnChangeConnectionString_Click(object sender, EventArgs e)
{
AccessFDB fdb = null;
switch (_providerId)
{
case "mssql":
fdb = new SqlFDB();
break;
case "postgres":
fdb = new pgFDB();
break;
case "sqlite":
fdb = new SQLiteFDB();
break;
}
if (fdb == null)
{
return;
}
await fdb.Open(_connectionString);
DbConnectionString dbConnStr = new DbConnectionString();
dbConnStr.UseProviderInConnectionString = false;
FormConnectionString dlg = (dbConnStr.TryFromConnectionString("mssql", fdb.ConnectionString) ?
new FormConnectionString(dbConnStr) : new FormConnectionString());
dlg.ProviderID = _providerId;
dlg.UseProviderInConnectionString = false;
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
dbConnStr = dlg.DbConnectionString;
_connectionString = dbConnStr.ConnectionString;
await BuildList();
}
}
public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e)
{
FormConnectionString dlg = new FormConnectionString();
dlg.ProviderID = "oracle";
dlg.UseProviderInConnectionString = false;
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
DbConnectionString dbConnStr = dlg.DbConnectionString;
ConfigConnections connStream = new ConfigConnections("oracle", "546B0513-D71D-4490-9E27-94CD5D72C64A");
string connectionString = dbConnStr.ConnectionString;
string id = ConfigTextStream.ExtractOracleValue(connectionString, "service_name") + "@" + ConfigTextStream.ExtractOracleValue(connectionString, "host");
id = connStream.GetName(id);
connStream.Add(id, dbConnStr.ToString());
e.NewExplorerObject = new OracleExplorerObject(this.ParentExplorerObject, id, dbConnStr);
}
}
/// <summary>
/// Executes this command.
/// </summary>
/// <param name="parameter">The parameter.</param>
public override void Execute(object parameter)
{
using (var f = new FormConnectionString())
{
if (f.ShowDialog(AppCore.FormMain) != DialogResult.OK)
{
return;
}
try
{
var builder = DatabaseSchema.CreateBuilder(f.ProviderType);
var schema = builder.BuildDatabaseSchema(f.ConnectionString);
AppCore.FormMain.SchemaBrowser.ShowSchema(schema);
}
catch (Exception ex)
{
ExceptionForm.ShowException("Open file", "Error open file", ex);
}
}
}
public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e)
{
FormConnectionString dlg = new FormConnectionString();
dlg.ProviderID = "arcsde";
dlg.UseProviderInConnectionString = true;
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string connStr = dlg.ConnectionString;
if (connStr.ToLower().StartsWith("sde:"))
{
connStr = connStr.Substring(4, connStr.Length - 4);
}
ConfigTextStream stream = new ConfigTextStream("sde_connections", true, true);
string id = ConfigTextStream.ExtractValue(connStr, "server").Replace(":", "_").Replace(@"\", "_");
string instance = ConfigTextStream.ExtractValue(connStr, "instance").Replace(":", "_").Replace(@"\", "_");
string database = ConfigTextStream.ExtractValue(connStr, "database").Replace(":", "_").Replace(@"\", "_");
if (String.IsNullOrEmpty(id))
{
id = "ArcSDE Connection";
}
if (!String.IsNullOrEmpty(instance))
{
id += "-" + instance;
}
if (!String.IsNullOrEmpty(database))
{
id += "-" + database;
}
stream.Write(connStr, ref id);
stream.Close();
e.NewExplorerObject = new SdeExplorerObject(this.ParentExplorerObject, id, dlg.ConnectionString);
}
}
void ConnectionProperties_Click(object sender, EventArgs e)
{
if (_connectionString == null)
{
return;
}
FormConnectionString dlg = new FormConnectionString(_connectionString);
dlg.ProviderID = "oracle";
dlg.UseProviderInConnectionString = false;
if (dlg.ShowDialog() == DialogResult.OK)
{
DbConnectionString dbConnStr = dlg.DbConnectionString;
ConfigConnections connStream = new ConfigConnections("oracle", "546B0513-D71D-4490-9E27-94CD5D72C64A");
connStream.Add(_server, dbConnStr.ToString());
_connectionString = dbConnStr;
}
}
public void ExplorerObjectDoubleClick(ExplorerObjectEventArgs e)
{
FormConnectionString dlg = new FormConnectionString();
dlg.ProviderID = "mssql";
dlg.UseProviderInConnectionString = false;
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string connStr = dlg.ConnectionString;
ConfigTextStream stream = new ConfigTextStream("MsSql2008SpatialSde_connections", true, true);
string id = ConfigTextStream.ExtractValue(connStr, "Database");
id += "@" + ConfigTextStream.ExtractValue(connStr, "Server");
if (id == "@")
{
id = "MsSql 2008 Spatial Connection";
}
stream.Write(connStr, ref id);
stream.Close();
e.NewExplorerObject = new MsSql2008SpatialSdeExplorerObject(this.ParentExplorerObject, id, dlg.ConnectionString);
}
}
private void btnChangeConnectionString_Click(object sender, EventArgs e)
{
AccessFDB fdb = (_providerId == "mssql" ? new SqlFDB() : new AccessFDB());
fdb.Open(_connectionString);
DbConnectionString dbConnStr = new DbConnectionString();
dbConnStr.UseProviderInConnectionString = false;
FormConnectionString dlg = (dbConnStr.TryFromConnectionString("mssql", fdb.ConnectionString) ?
new FormConnectionString(dbConnStr) : new FormConnectionString());
dlg.ProviderID = _providerId;
dlg.UseProviderInConnectionString = false;
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
dbConnStr = dlg.DbConnectionString;
_connectionString = dbConnStr.ConnectionString;
BuildList();
}
}
private void btnGetConnectionString_Click(object sender, EventArgs e)
{
if (_domain == null)
{
return;
}
FormConnectionString dlg = new FormConnectionString(_domain.DbConnectionString);
dlg.ProviderID = "mssql,oledb,oracle";
if (dlg.ShowDialog() == DialogResult.OK)
{
_domain.DbConnectionString = dlg.DbConnectionString;
if (_domain.DbConnectionString != null)
{
txtConnection.Text = _domain.DbConnectionString.SchemaName;
}
else
{
txtConnection.Text = String.Empty;
}
}
}
/// <summary>
/// Edition of conncetion sttring
/// </summary>
static public void EditConnectionSrtring()
{
Form form = new FormConnectionString();
form.ShowDialog();
}