public async Task SetSettingsAsync(DatabaseModel.Settings settings)
{
var dict = new Dictionary <string, object>
{
{ "@InventoryLimit", settings.InventoryLimit },
{ "@ItemValueLimit", settings.ItemValueLimit },
{ "@SteamInventoryCacheTimerInSec", settings.SteamInventoryCacheTimerInSec },
{ "@UpdatedPricingTime", settings.UpdatedPricingTime },
{ "@NrOfLatestChatMessages", settings.NrOfLatestChatMessages },
};
if (await HasAlreadyAdded())
{
var sqlQueryUpdate = new SqlQuery("UPDATE [Settings] SET " +
"InventoryLimit = @InventoryLimit, " +
"ItemValueLimit = @ItemValueLimit, " +
"SteamInventoryCacheTimerInSec = @SteamInventoryCacheTimerInSec, " +
"UpdatedPricingTime = @UpdatedPricingTime, " +
"NrOfLatestChatMessages= @NrOfLatestChatMessages " +
"WHERE Id = 1", dict);
await _databaseConnection.ExecuteNonQueryAsync(sqlQueryUpdate);
return;
}
//insert
var sqlQuery = new SqlQuery(
"INSERT INTO [Settings] (InventoryLimit, ItemValueLimit, SteamInventoryCacheTimerInSec, UpdatedPricingTime, NrOfLatestChatMessages) " +
"VALUES (@InventoryLimit,@ItemValueLimit,@SteamInventoryCacheTimerInSec,@UpdatedPricingTime,@NrOfLatestChatMessages);",
dict);
await _databaseConnection.ExecuteNonQueryAsync(sqlQuery);
}
public async Task <DatabaseModel.Settings> GetCurrentSettings()
{
if (_settings == null)
{
_settings = await _repoServiceFactory.SettingRepoService.GetSettingsAsync();
}
return(_settings);
}
public async Task SetOrUpdateSettings(DatabaseModel.Settings settings)
{
await _repoServiceFactory.SettingRepoService.SetSettingsAsync(settings);
_settings = settings;
}
public async Task <IActionResult> SetSettings([FromBody] DatabaseModel.Settings settings)
{
await _settingsService.SetOrUpdateSettings(settings);
return(new OkResult());
}
