private static bool CheckAllModule(List <string> modulesName) { string cmdCheck = "SELECT count(*) FROM modules WHERE name in " + RelationOperator.GetString(modulesName); using (SQLiteConnection conn = new SQLiteConnection(globalParameters.dbPath)) { conn.Open(); using (SQLiteCommand cmdReader = new SQLiteCommand(cmdCheck, conn)) { using (SQLiteDataReader reader = cmdReader.ExecuteReader()) { while (reader.Read()) { if (reader.GetInt32(0) == 0) { conn.Close(); return(true); } } conn.Close(); return(false); } } } }
public static bool importModules(List <string> modulesName) { if (modulesName.Count == 0) { return(false); } bool check = CheckAllModule(modulesName); if (!check) { return(false); } string sql1 = "insert into modules select * from secondDb.modules where name in " + RelationOperator.GetString(modulesName); string sql00 = "ATTACH DATABASE '" + globalParameters.secondDbPath + "' as 'secondDb'"; using (SQLiteConnection conn = new SQLiteConnection(globalParameters.dbPath)) { conn.Open(); using (SQLiteCommand cmd = new SQLiteCommand(sql00, conn)) { cmd.ExecuteNonQuery(); } using (SQLiteCommand cmd = new SQLiteCommand(sql1, conn)) { cmd.ExecuteNonQuery(); } conn.Close(); } return(true); }