private void Paste_Click(object sender, EventArgs e)
{
try
{
var s = Clipboard.GetText();
var stringReader = new StringReader(s);
var xmlTextReader = new XmlTextReader(stringReader);
var configurationReader = new ConfigurationReader();
var propertyFolder = configurationReader.Read(xmlTextReader);
propertyFolder.Write(TraceWriter.Instance);
var configurationNodes = propertyFolder.ChildNodes.Count > 0
? (IEnumerable <ConfigurationNode>)propertyFolder.ChildNodes
: new[] { propertyFolder };
foreach (var configurationNode in configurationNodes)
{
var connectionProperties = ConnectionPropertiesRepository.GetFromConfiguration(configurationNode);
Add(connectionProperties);
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.ToString(), null, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void CopyConnectionString_Click(object sender, EventArgs e)
{
var configurationNode = SelectedConfigurationNode;
var connectionProperties = ConnectionPropertiesRepository.GetFromConfiguration(configurationNode);
var connectionString = connectionProperties.ConnectionString;
Clipboard.SetText(connectionString);
}
private void LoadConnection(ConfigurationNode configurationNode, DataRow row)
{
var connectionProperties = ConnectionPropertiesRepository.GetFromConfiguration(configurationNode);
row["ConnectionName"] = connectionProperties.ConnectionName;
row["ProviderName"] = connectionProperties.ProviderName;
row[ConnectionStringKeyword.DataSource] = connectionProperties.DataSource;
row[ConnectionStringKeyword.InitialCatalog] = connectionProperties.InitialCatalog;
row[ConnectionStringKeyword.IntegratedSecurity] = connectionProperties.IntegratedSecurity;
row[ConnectionStringKeyword.UserId] = connectionProperties.UserId;
}
private void Add(ConnectionProperties connectionProperties)
{
var node = DataCommanderApplication.Instance.ConnectionsConfigurationNode;
var subFolder = new ConfigurationNode(null);
node.AddChildNode(subFolder);
ConnectionPropertiesRepository.Save(connectionProperties, subFolder);
var row = _dataTable.NewRow();
LoadConnection(subFolder, row);
_dataTable.Rows.Add(row);
_isDirty = true;
}
private void Edit_Click(object sender, EventArgs e)
{
var configurationNode = SelectedConfigurationNode;
var form = new ConnectionStringBuilderForm();
form.ConnectionProperties = ConnectionPropertiesRepository.GetFromConfiguration(configurationNode);
var dialogResult = form.ShowDialog();
if (dialogResult == DialogResult.OK)
{
ConnectionPropertiesRepository.Save(form.ConnectionProperties, configurationNode);
var row = _dataTable.DefaultView[_dataGrid.CurrentCell.RowIndex].Row;
LoadConnection(configurationNode, row);
}
}
private void Connect(ConfigurationNode folder)
{
if (_isDirty)
{
if (MessageBox.Show(this, "Do you want to save changes?", null, MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DataCommanderApplication.Instance.SaveApplicationData();
}
}
using (new CursorManager(Cursors.WaitCursor))
{
var connectionProperties = ConnectionPropertiesRepository.GetFromConfiguration(folder);
var form = new OpenConnectionForm(connectionProperties);
if (form.ShowDialog() == DialogResult.OK)
{
ConnectionProperties = connectionProperties;
DialogResult = DialogResult.OK;
Duration = form.Duration;
}
}
}