/// <summary>
/// Database initialization checks
/// </summary>
#region Database initialization checks
public static void DBInitializationChecks()
{
if (!File.Exists(Settings.sqlFile()))
{
SQLStorage db = new SQLStorage();
db.createDB();
}
}
/// <summary>
/// Get parameters from DB
/// </summary>
#region Get parameters from DB
public static string retrievePar(string parameter)
{
if (!File.Exists(Settings.sqlFile()))
{
SQLStorage db = new SQLStorage();
db.createDB();
}
generic_connection.Open();
string command = "select value from config where parameter='" + parameter + "';";
SqliteCommand cmd = new SqliteCommand(command, generic_connection);
string result = cmd.ExecuteScalar().ToString();
generic_connection.Close();
return(result);
}
/// <summary>
/// Set parameters in DB
/// </summary>
#region Set parameters in DB
public static void modifyPar(string command, string variable_with_value, string uniqueID)
{
if (!File.Exists(Settings.sqlFile()))
{
SQLStorage db = new SQLStorage();
db.createDB();
}
string[] variable_and_parameter = variable_with_value.Split(' ');
string variable = variable_and_parameter[0];
string value = variable_and_parameter[variable_and_parameter.Length - 1];
generic_connection.Open();
string SQLcommand = "update config set value='" + value + "' where parameter='" + variable + "';";
SqliteCommand cmd = new SqliteCommand(SQLcommand, generic_connection);
cmd.ExecuteNonQuery();
generic_connection.Close();
// Inform that the command was received
Network.SendData(variable + " changed!", command, uniqueID, 1);
}