#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 System.Collections.Specialized;
using OSGeo.MapGuide.Maestro;
namespace OSGeo.MapGuide.Maestro.ResourceEditors.FeatureSourceEditors.ODBC.Wizards
{
///
/// Summary description for MsSQL.
///
public class MsSQL : System.Windows.Forms.UserControl
{
private System.Windows.Forms.TextBox Database;
private System.Windows.Forms.TextBox Server;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label2;
///
/// Required designer variable.
///
private System.ComponentModel.Container components = null;
private ResourceEditors.EditorInterface m_editor = null;
private OSGeo.MapGuide.MaestroAPI.FeatureSource m_item = null;
private bool m_isUpdating = false;
public event FeatureSourceEditorODBC.ConnectionStringUpdatedDelegate ConnectionStringUpdated;
public MsSQL()
{
// This call is required by the Windows.Forms Form Designer.
InitializeComponent();
}
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;
NameValueCollection nv = ConnectionStringManager.SplitConnectionString(m_item.Parameter["ConnectionString"]);
ConnectionStringManager.InsertDefaultValues(nv, "{SQL Server}");
Server.Text = nv["Server"];
Database.Text = nv["Database"];
}
finally
{
m_isUpdating = false;
}
}
///
/// 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(MsSQL));
this.Database = new System.Windows.Forms.TextBox();
this.Server = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.SuspendLayout();
//
// Database
//
resources.ApplyResources(this.Database, "Database");
this.Database.Name = "Database";
this.Database.TextChanged += new System.EventHandler(this.PropertyText_Changed);
//
// Server
//
resources.ApplyResources(this.Server, "Server");
this.Server.Name = "Server";
this.Server.TextChanged += new System.EventHandler(this.PropertyText_Changed);
//
// label5
//
resources.ApplyResources(this.label5, "label5");
this.label5.Name = "label5";
//
// label2
//
resources.ApplyResources(this.label2, "label2");
this.label2.Name = "label2";
//
// MsSQL
//
resources.ApplyResources(this, "$this");
this.Controls.Add(this.Database);
this.Controls.Add(this.Server);
this.Controls.Add(this.label5);
this.Controls.Add(this.label2);
this.Name = "MsSQL";
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private void PropertyText_Changed(object sender, System.EventArgs e)
{
if (m_item == null || m_isUpdating)
return;
NameValueCollection prev = ConnectionStringManager.SplitConnectionString(m_item.Parameter["ConnectionString"]);
NameValueCollection nv = new NameValueCollection();
nv["Driver"] = "{SQL Server}";
nv["Server"] = Server.Text;
nv["Database"] = Database.Text;
ConnectionStringManager.MergeCredentialsIntoConnectionString(prev, nv);
m_item.Parameter["ConnectionString"] = ConnectionStringManager.JoinConnectionString(nv);
if (ConnectionStringUpdated != null)
ConnectionStringUpdated(m_item.Parameter["ConnectionString"]);
m_editor.HasChanged();
}
}
}