FreakOut.classes.DatabaseConnector.SetSettingByName C# (CSharp) Method

SetSettingByName() public method

public SetSettingByName ( string SettingName, string Content ) : void
SettingName string
Content string
return void
        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;
        }