public void DeleteTopologyAndWeightsMatrix(string NeuroNetName, LoadingWindow loadingWindow) { connector.ConnectToDB(); SQLiteCommand cmd = new SQLiteCommand(connector.connection); cmd.CommandText = "SELECT ID FROM NeuroNet WHERE NAME = '" + NeuroNetName + "'"; int NNID = Convert.ToInt32(cmd.ExecuteScalar()); cmd.CommandText = "SELECT ID FROM NetTopology WHERE NeuroNetID = '" + Convert.ToString(NNID) + "'"; List <int> ls = new List <int>(); double progress = 0.0; try { SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ls.Add(Convert.ToInt32(reader[0])); } reader.Close(); foreach (int item in ls) { cmd.CommandText = "DELETE FROM WeightsMatrix WHERE NetTopologyID = '" + Convert.ToString(item) + "'"; cmd.ExecuteNonQuery(); cmd.CommandText = "DELETE FROM NetTopology WHERE ID = '" + Convert.ToString(item) + "'"; cmd.ExecuteNonQuery(); progress += 100.0 / Convert.ToDouble(ls.Count); Action f = new Action(() => loadingWindow.LoadingBar.Value = Convert.ToInt32(progress)); if (loadingWindow.LoadingBar.InvokeRequired) { loadingWindow.LoadingBar.Invoke(f); } else { f(); } } } catch (SQLiteException ex) { MessageBox.Show(ex.Message); } connector.DisconnectFromDB(); loadingWindow.Invoke(new Action(() => loadingWindow.Close())); }
public void InsertTopologyOfNeuroNet(string NameNN, string TopologyTypeName, int CountNeurons, int CountLayers, int[] NeuronsInLayers, LoadingWindow loadingWindow) { connector.ConnectToDB(); SQLiteCommand cmd = new SQLiteCommand(connector.connection); cmd.CommandText = "SELECT ID FROM NeuroNet WHERE Name = '" + NameNN + "'"; int NetID = Convert.ToInt32(cmd.ExecuteScalar()); Topology topology = LibraryOfTopologies.GetTopology(TopologyTypeName, LibraryOfTopologies.GetterParameter.TypeOfTopologyName); bool[,] connections = topology.CreateNet(CountNeurons, CountLayers, NeuronsInLayers); double progressValue = 0.0; for (int i = 0; i < CountNeurons; i++) { for (int j = 0; j < CountNeurons; j++) { if (connections[i, j] == true) { cmd.CommandText = "INSERT INTO NetTopology (IndexInputNeuron, " + "IndexOutputNeuron, NeuroNetID) values('" + Convert.ToString(j) + "','" + Convert.ToString(i) + "','" + Convert.ToString(NetID) + "')"; cmd.ExecuteNonQuery(); } progressValue += 100.0 / Convert.ToDouble(CountNeurons * CountNeurons); Action f = new Action(() => loadingWindow.LoadingBar.Value = Convert.ToInt32(progressValue)); if (loadingWindow.LoadingBar.InvokeRequired) { loadingWindow.LoadingBar.Invoke(f); } else { f(); } } } connector.DisconnectFromDB(); loadingWindow.Invoke(new Action(() => loadingWindow.Close())); }
public void DeleteWeightsMatrix(string NeuroNetName, LoadingWindow loadingWindow) { connector.ConnectToDB(); SQLiteCommand cmd = new SQLiteCommand(connector.connection); cmd.CommandText = "SELECT ID FROM NeuroNet WHERE NAME = '" + NeuroNetName + "'"; int NNID = Convert.ToInt32(cmd.ExecuteScalar()); cmd.CommandText = "SELECT ID FROM NetTopology WHERE NeuroNetID = '" + Convert.ToString(NNID) + "'"; List<int> ls = new List<int>(); double progress = 0.0; try { SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ls.Add(Convert.ToInt32(reader[0])); } reader.Close(); foreach (int item in ls) { cmd.CommandText = "DELETE FROM WeightsMatrix WHERE NetTopologyID = '" + Convert.ToString(item) + "'"; cmd.ExecuteNonQuery(); progress += 100.0 / Convert.ToDouble(ls.Count); Action f = new Action(() => loadingWindow.LoadingBar.Value = Convert.ToInt32(progress)); if (loadingWindow.LoadingBar.InvokeRequired) { loadingWindow.LoadingBar.Invoke(f); } else { f(); } } } catch (SQLiteException ex) { MessageBox.Show(ex.Message); } connector.DisconnectFromDB(); loadingWindow.Invoke(new Action(() => loadingWindow.Close())); }
public void InsertTopologyOfNeuroNet(string NameNN, string TopologyTypeName, int CountNeurons, int CountLayers, int[] NeuronsInLayers, LoadingWindow loadingWindow) { connector.ConnectToDB(); SQLiteCommand cmd = new SQLiteCommand(connector.connection); cmd.CommandText = "SELECT ID FROM NeuroNet WHERE Name = '" + NameNN + "'"; int NetID = Convert.ToInt32(cmd.ExecuteScalar()); Topology topology = LibraryOfTopologies.GetTopology(TopologyTypeName, LibraryOfTopologies.GetterParameter.TypeOfTopologyName); bool[,] connections = topology.CreateNet(CountNeurons, CountLayers, NeuronsInLayers); double progressValue = 0.0; for (int i = 0; i < CountNeurons; i++) { for (int j = 0; j < CountNeurons; j++) { if (connections[i, j] == true) { cmd.CommandText = "INSERT INTO NetTopology (IndexInputNeuron, " + "IndexOutputNeuron, NeuroNetID) values('" + Convert.ToString(j) + "','" + Convert.ToString(i) + "','" + Convert.ToString(NetID) + "')"; cmd.ExecuteNonQuery(); } progressValue += 100.0 / Convert.ToDouble(CountNeurons * CountNeurons); Action f = new Action(() => loadingWindow.LoadingBar.Value = Convert.ToInt32(progressValue)); if (loadingWindow.LoadingBar.InvokeRequired) { loadingWindow.LoadingBar.Invoke(f); } else { f(); } } } connector.DisconnectFromDB(); loadingWindow.Invoke(new Action(() => loadingWindow.Close())); }