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