#region Disclaimer / License
// Copyright (C) 2009, Kenneth Skovhede
// http://www.hexad.dk, opensource@hexad.dk
//
// This library is free software; you can redistribute it and/or
// modify it under the terms of the GNU Lesser General Public
// License as published by the Free Software Foundation; either
// version 2.1 of the License, or (at your option) any later version.
//
// This library is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
// Lesser General Public License for more details.
//
// You should have received a copy of the GNU Lesser General Public
// License along with this library; if not, write to the Free Software
// Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
//
#endregion
using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Windows.Forms;
using OSGeo.MapGuide.Maestro;
namespace OSGeo.MapGuide.Maestro.ResourceEditors.FeatureSourceEditors.OGR
{
///
/// Summary description for Oracle.
///
public class Oracle : System.Windows.Forms.UserControl
{
private System.Windows.Forms.TextBox Table;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.TextBox Database;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label7;
///
/// Required designer variable.
///
private System.ComponentModel.Container components = null;
private OSGeo.MapGuide.MaestroAPI.FeatureSource m_item;
private bool m_isUpdating = false;
private ResourceEditors.FeatureSourceEditors.ODBC.Credentials credentials;
private EditorInterface m_editor;
private string m_username;
private string m_password;
public void SetItem(ResourceEditors.EditorInterface editor, OSGeo.MapGuide.MaestroAPI.FeatureSource item)
{
m_editor = editor;
m_item = item;
UpdateDisplay();
}
public void UpdateDisplay()
{
if (m_item == null)
return;
try
{
m_isUpdating = true;
string connectionstring = m_item.Parameter["DataSource"];
if (connectionstring == null)
connectionstring = "";
if (!connectionstring.StartsWith("OCI:"))
connectionstring = "";
else
connectionstring = connectionstring.Substring("OCI:".Length);
if (connectionstring.IndexOf("@") > 0)
{
string usernamepassword = connectionstring.Substring(0, connectionstring.IndexOf("@"));
connectionstring = connectionstring.Substring(usernamepassword.Length + 1);
string[] parts = usernamepassword.Split('/');
if (parts.Length > 1)
{
m_username = parts[0];
m_password = parts[1];
}
else
{
m_username = "";
m_password = "";
}
}
credentials.SetCredentials(m_username, m_password);
if (connectionstring.IndexOf(":") > 0)
{
Database.Text = connectionstring.Substring(0, connectionstring.IndexOf(":"));
connectionstring = connectionstring.Substring(Database.Text.Length + 1);
}
Table.Text = connectionstring;
}
finally
{
m_isUpdating = false;
}
}
private void UpdateConnectionString()
{
if (m_item == null)
return;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("OCI:");
sb.Append(m_username);
sb.Append("/");
sb.Append(m_password);
sb.Append("@");
sb.Append(Database.Text);
if (Table.Text.Trim().Length > 0)
{
sb.Append(":");
sb.Append(Table.Text);
}
m_item.Parameter["DataSource"] = sb.ToString();
}
private string GetDefaultValue(string item, string defaultValue)
{
if (item != null && item.Trim().Length > 0)
return item;
else
return defaultValue;
}
public Oracle()
{
// This call is required by the Windows.Forms Form Designer.
InitializeComponent();
}
///
/// Clean up any resources being used.
///
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Component Designer generated code
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Oracle));
this.Table = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.Database = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.credentials = new OSGeo.MapGuide.Maestro.ResourceEditors.FeatureSourceEditors.ODBC.Credentials();
this.SuspendLayout();
//
// Table
//
resources.ApplyResources(this.Table, "Table");
this.Table.Name = "Table";
this.Table.TextChanged += new System.EventHandler(this.SomeProperty_Change);
//
// label3
//
resources.ApplyResources(this.label3, "label3");
this.label3.Name = "label3";
//
// Database
//
resources.ApplyResources(this.Database, "Database");
this.Database.Name = "Database";
this.Database.TextChanged += new System.EventHandler(this.SomeProperty_Change);
//
// label2
//
resources.ApplyResources(this.label2, "label2");
this.label2.Name = "label2";
//
// label7
//
resources.ApplyResources(this.label7, "label7");
this.label7.Name = "label7";
//
// credentials
//
resources.ApplyResources(this.credentials, "credentials");
this.credentials.Name = "credentials";
this.credentials.CredentialsChanged += new OSGeo.MapGuide.Maestro.ResourceEditors.FeatureSourceEditors.ODBC.Credentials.CredentialsChangedDelegate(this.credentials_CredentialsChanged);
//
// Oracle
//
resources.ApplyResources(this, "$this");
this.Controls.Add(this.credentials);
this.Controls.Add(this.label7);
this.Controls.Add(this.Table);
this.Controls.Add(this.label3);
this.Controls.Add(this.Database);
this.Controls.Add(this.label2);
this.Name = "Oracle";
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private void SomeProperty_Change(object sender, System.EventArgs e)
{
if (m_isUpdating || m_item == null)
return;
if (m_item.Parameter == null)
m_item.Parameter = new OSGeo.MapGuide.MaestroAPI.NameValuePairTypeCollection();
UpdateConnectionString();
m_editor.HasChanged();
}
private void credentials_CredentialsChanged(string username, string password)
{
if (m_isUpdating || m_item == null)
return;
m_username = username;
m_password = password;
SomeProperty_Change(null, null);
}
}
}