public static void AddSetting(SettingModel setting) { using (IDbConnection conn = new SQLiteConnection(LoadConnString())) { conn.Execute("insert into Settings (SettingName, SettingValue) values (@SettingName, @SettingValue)", setting); } }
private void saveSettingsButton_Clicked(object sender, EventArgs e) { foreach (object field in settingFields) { SettingModel setting = new SettingModel(); if (field.GetType() == typeof(TextBox)) { TextBox tb = (TextBox)field; setting.SettingName = tb.Name; setting.SettingValue = tb.Text; if (!SqliteDataMgr.SettingExists(tb.Name)) { SqliteDataMgr.AddSetting(setting); } else { SqliteDataMgr.UpdateSetting(setting); } } } SKUDBMgr.ConnectToDatabase(databaseLocation.Text.Trim()); }
public static void UpdateSetting(SettingModel setting) { using (IDbConnection conn = new SQLiteConnection(LoadConnString())) { conn.Execute("update Settings set SettingValue ='" + setting.SettingValue + "' where SettingName= '" + setting.SettingName + "'"); } }
private void LoadSettings() { settings = SqliteDataMgr.LoadSettings(); List <object> tbl = settingFields.FindAll(f => f.GetType() == typeof(TextBox)); foreach (TextBox tb in tbl) { SettingModel sm = settings.Find(s => s.SettingName == tb.Name); if (sm != null) { tb.Text = sm.SettingValue; } } }