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; } }