#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); } } }