public void SaveConnection(string nm, string pth)
{
try
{
var savedConnection = new SavedConnections(nm, pth);
using (var connConfig = GetConfigConnection())
{
string query = string.Format("INSERT INTO {0}(NAME,PATH) values ('{1}','{2}')", ConfigTable, nm, pth);
new SQLiteCommand(query, connConfig).ExecuteNonQuery();
}
NotifyAll(ConnectionChangeType.Add);
}
catch (Exception)
{
throw;
}
}
private void RefreshAllSavedConnections()
{
try
{
using (var connConfig = GetConfigConnection())
{
var comm = connConfig.CreateCommand();
comm.CommandText = "SELECT * FROM " + ConfigTable;
List <int> lstIds = new List <int>();
using (var rd = comm.ExecuteReader())
{
while (rd.Read())
{
var obj = new SavedConnections()
{
ID = Convert.ToInt32(rd[0]),
Name = rd["NAME"].ToString(),
Path = rd["PATH"].ToString(),
Password = rd["PASSWORD"].ToString(),
IsConnectionActive = false
};
//Refresh Connection without closing existing connection
if (!conn_list.ContainsKey(obj.ID))
{
conn_list.Add(obj.ID, obj);
}
lstIds.Add(obj.ID);
}
}
var removedConnections = conn_list.Where(x => lstIds.All(y => y != x.Key));
}
}
catch (Exception)
{
throw;
}
}
