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