public static connItem fn_getConnectionByName(string connectionName, string path)
{
List <connItem> list = fn_getSavedConnections(path);
connItem item = (from i in list
where i.connName == connectionName
select i).FirstOrDefault();
if (item != null)
{
return(item);
}
else
{
return(null);
}
}
// Saves new or existing connection to XML
private void btnSaveConnction_Click(object sender, EventArgs e)
{
// Just simple validation
if (txtConnName.Text == "" || txtDatabase.Text == "" || txtHostname.Text == "" || txtPort.Text == "")
{
MessageBox.Show("Enter Server information and Connection name.");
return;
}
// search items with same connection name, if any found, delete all
var itemz = connItems.Where(i => i.connName == txtConnName.Text).ToList();
if (itemz.Count > 0)
{
foreach (var item in itemz)
{
connItems.Remove(item);
}
}
// create new connItem object and populate it with data from controls
var newItem = new connItem();
newItem.connName = txtConnName.Text;
newItem.dbDriver = cboDatabaseDriver.SelectedItem.ToString();
newItem.Hostname = txtHostname.Text;
newItem.Port = txtPort.Text;
newItem.Database = txtDatabase.Text;
newItem.Username = txtUsername.Text;
newItem.Password = txtPassword.Text;
if (chkSavePassword.Checked == true)
{
newItem.savePassword = "******";
}
else
{
newItem.savePassword = "******";
}
connItems.Add(newItem); // add item to main list
fn_saveConfiguration(); // save to XML
fn_loadConfiguration(); // read from XML
lstConnections.SelectedValue = newItem.connName.ToString(); // select manipulated object in list box
}
