public void SetSettingByName(string SettingName, string Content)
{
string CheckSetting = this.GetSettingByName(SettingName);
if (!connectionopen)
{
DBConnector.Open();
connectionopen = true;
}
FbTransaction DBTransaction = DBConnector.BeginTransaction();
FbCommand DBCommand;
if (CheckSetting == null)
DBCommand = new FbCommand("INSERT INTO settings(name_of_setting, content) VALUES ('" + SettingName + "','" + Content + "')", DBConnector, DBTransaction);
else
DBCommand = new FbCommand("UPDATE settings SET content = '" + Content + "' WHERE name_of_setting = '" + SettingName + "'", DBConnector, DBTransaction);
DBCommand.ExecuteNonQuery();
DBTransaction.Commit();
DBConnector.Close();
connectionopen = false;
}