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