private async Task InsertOrUpdateUserSetting(string userSettingName, string paramValue) { using (var conn = new SQLiteConnection(_connectionString)) { conn.Open(); var getCmd = new SQLiteCommand(SQLQueries.GetUserSetting(userSettingName), conn); var response = (string)(await getCmd.ExecuteScalarAsync()); if (String.IsNullOrWhiteSpace(response)) { var cmd = new SQLiteCommand(SQLQueries.InsertUserSetting(userSettingName), conn); cmd.Parameters.Add(new SQLiteParameter("@KeyValue", paramValue)); await cmd.ExecuteNonQueryAsync(); } else { var cmd = new SQLiteCommand(SQLQueries.UpdateUserSetting(userSettingName), conn); cmd.Parameters.Add(new SQLiteParameter("@KeyValue", paramValue)); await cmd.ExecuteNonQueryAsync(); } } }
private async Task <string> GetUserSetting(string userSettingName) { using (var conn = new SQLiteConnection(_connectionString)) { conn.Open(); var cmd = new SQLiteCommand(SQLQueries.GetUserSetting(userSettingName), conn); return((string)(await cmd.ExecuteScalarAsync())); } }