/// <inheritdoc />
public async Task InsertCurrencyRateAsync(CurrencyRateOnDate currency_rate_on_date)
{
TryMakeFail(0.6);
try
{
await SqlAccess.ExecuteCommandAsync(INSERT_RATE, _connectionString,
new[]
{
new NpgsqlParameter("@currency_code", DbType.String)
{
Value = currency_rate_on_date.CurrencyCode
},
new NpgsqlParameter("@rate_date", DbType.Date)
{
Value = currency_rate_on_date.RateDate
},
new NpgsqlParameter("@rate", DbType.Double)
{
Value = currency_rate_on_date.Rate
}
});
}
catch (PostgresException e)
{
// Код ошибки дубликата ключа, значит уже закешировано.
if (string.Equals(e.SqlState, "23505"))
{
throw new DuplicateNameException();
}
}
}
/// <inheritdoc />
public async Task <double> GetRateOnDateAsync(string currency_code, DateTime?rate_date)
{
if (string.IsNullOrEmpty(currency_code))
{
throw new BadRequestException(Resources.NotCurrencyCodeError);
}
rate_date = rate_date ?? DateTime.Now;
if (rate_date.Value.Date > DateTime.Now.Date)
{
throw new BadRequestException(Resources.FutureDateError);
}
// Исхожу из того, что курсы не изменяются, никакой инвалидации не делалось.
try
{
double?rate = await _ratesStorage.SelectCurrencyRateAsync(currency_code, (DateTime)rate_date);
if (rate != null)
{
return((double)rate);
}
}
catch (Exception e)
{
_logger.Debug(e.Message);
}
List <CurrencyRateOnDate> rates;
try
{
rates = await _ratesSource.GetCurrencyRatesOnDatesAsync(currency_code, (DateTime)rate_date);
_ratesCache.AddCurrencyRatesOnDate(rates);
}
catch (Exception e)
{
_logger.Error(e.Message);
throw new Exception(Resources.CbLogicFail);
}
CurrencyRateOnDate currency_rate = rates.FirstOrDefault(x =>
string.Equals(currency_code, x.CurrencyCode) && x.RateDate.Date.Equals(rate_date.Value.Date));
if (currency_rate == null)
{
throw new NotFoundException(string.Format(Resources.ExchangeRateNotFound, currency_code, rate_date));
}
return(currency_rate.Rate);
}
