public static IDictionary <string, ConnectionParams> EnumerateConnections() { ConnectionParamsCollection _connParams; IDictionary <string, ConnectionParams> result = new Dictionary <string, ConnectionParams>(); if (!File.Exists(_path)) { return(result); } _connParams = ObjectXMLSerializer <ConnectionParamsCollection> .Load(_path); string normalServerName = String.Empty; foreach (ConnectionParams cp in _connParams) { if (cp.IsEncrypted) { cp.Password = EncryiptionHelper.Decrypt(cp.Password); } normalServerName = cp.Server.Trim().ToLowerInvariant(); if (!result.ContainsKey(normalServerName)) { result.Add(normalServerName, cp); } } return(result);; }
public static ConnectionParamsCollection GetConnections() { ConnectionParamsCollection _connParams; bool SaveEncrypted = false; if (!File.Exists(_path)) { return(new ConnectionParamsCollection()); } /* * * string filename = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "DBConnections.config"); * if (!System.IO.File.Exists(filename)) * return (new ConnectionParamsCollection()); * * XmlSerializer ser = new XmlSerializer(typeof(ConnectionParamsCollection)); * TextReader reader = new StreamReader(filename); * _connParams = (ConnectionParamsCollection)ser.Deserialize(reader); * reader.Close(); */ _connParams = ObjectXMLSerializer <ConnectionParamsCollection> .Load(_path); foreach (ConnectionParams cp in _connParams) { if (!cp.IsEncrypted) { SaveEncrypted = true; } else { cp.Password = EncryiptionHelper.Decrypt(cp.Password); } } if (SaveEncrypted) { Save(_connParams); } return(_connParams); }
public static void Save(ConnectionParamsCollection connParams) { foreach (ConnectionParams cp in connParams) { cp.IsEncrypted = true; cp.Password = EncryiptionHelper.Encrypt(cp.Password); } /* * string filename = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "DBConnections.config"); * XmlSerializer ser = new XmlSerializer(typeof(ConnectionParamsCollection)); * TextWriter writer = new StreamWriter(filename); * ser.Serialize(writer, connParams); * writer.Close(); */ ObjectXMLSerializer <ConnectionParamsCollection> .Save(connParams, _path); // Reset password foreach (ConnectionParams cp in connParams) { cp.Password = EncryiptionHelper.Decrypt(cp.Password); } }