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