public static void DB_Insert_PRESET(PresetSettings aSettings) { using (SqliteConnection db = new SqliteConnection(sqlConnectionFileName)) { db.Open(); String insertPresetCommand = "INSERT INTO " + "SettingsPresetsTable " + "(presetName, sessionTime, " + "shortBreakTime, longBreakTime) " + "VALUES " + "('" + aSettings.GetPresetName() + "', '" + aSettings.GetSessionTime().ToString("mm\\:ss") + "', '" + aSettings.GetShortBreakTime().ToString("mm\\:ss") + "', '" + aSettings.GetLongBreakTime().ToString("mm\\:ss") + "')"; using (SqliteCommand insertPreset = new SqliteCommand(insertPresetCommand, db)) { try { insertPreset.ExecuteNonQuery(); } catch (Exception e) { //Sql Exception. Preset already exists... db.Close(); } } db.Close(); } }
public static PresetSettings DB_Select_PRESET(string presetName) { using (SqliteConnection db = new SqliteConnection(sqlConnectionFileName)) { db.Open(); String selectPresetCommand = "SELECT sessionTime, shortBreakTime, longBreakTime " + "FROM SettingsPresetsTable " + "WHERE presetName = '" + presetName + "'"; using (SqliteCommand selectPreset = new SqliteCommand(selectPresetCommand, db)) { using (SqliteDataReader presetData = selectPreset.ExecuteReader()) { presetData.Read(); PresetSettings returnSettings = new PresetSettings(presetName); //Geee what a mess. Goodluck! returnSettings.SetSessionTime(TimeSpan.ParseExact((string)presetData["sessionTime"], "mm\\:ss", new CultureInfo("en-US"))); returnSettings.SetShortBreakTime(TimeSpan.ParseExact((string)presetData["shortBreakTime"], "mm\\:ss", new CultureInfo("en-US"))); returnSettings.SetLongBreakTime(TimeSpan.ParseExact((string)presetData["longBreakTime"], "mm\\:ss", new CultureInfo("en-US"))); db.Close(); return(returnSettings); } } } }
public static void DB_UPDATE_PRESET(PresetSettings aSettings) { using (SqliteConnection db = new SqliteConnection(sqlConnectionFileName)) { db.Open(); String updatePresetCommand = "UPDATE SettingsPresetsTable " + "SET sessionTime = '" + aSettings.GetSessionTime().ToString("mm\\:ss") + "', " + "shortBreakTime = '" + aSettings.GetShortBreakTime().ToString("mm\\:ss") + "', " + "longBReakTime = '" + aSettings.GetLongBreakTime().ToString("mm\\:ss") + "' " + "WHERE presetName = '" + aSettings.GetPresetName() + "' "; using (SqliteCommand updatePreset = new SqliteCommand(updatePresetCommand, db)) { updatePreset.ExecuteNonQuery(); } db.Close(); } }