/// <summary>
/// Добавление нового элемента в таблицу
/// </summary>
/// <param name="url"></param>
public static void AddNewExchangerate(string url)
{
//предположение об уникальности
bool unique = true;
Json = RequestAPI.GET(url);
exchangerate = JsonConvert.DeserializeObject <Exchangerate>(Json);
EntityDbContext context = new EntityDbContext();
//проверка на уникальность данных
foreach (var a in context.ExchangerateList)
{
if (a.Date == exchangerate.Date)
{
unique = false;
}
}
// Добавить в DbSet
if (unique)
{
context.ExchangerateList.Add(exchangerate);
}
// Сохранить изменения в базе данных
context.SaveChanges();
}
[Route("api/exchangerate/myresult")] //Endpoint that take 4 parameters
public async Task <string> MyResultAsync(string start_at, string end_at, string base1, string target)
{
var exchangerate = new Exchangerate()
{
Start_at = start_at,
End_at = end_at,
Base1 = base1,
Target = target,
};
var result = await GetExchangerate(exchangerate);
var json = JsonConvert.SerializeObject(result);
return(json);
}
private async Task <Rate> GetExchangerate(Exchangerate exchangerate)
{
var client = new HttpClient();
var response = await client.GetAsync(new Uri($"https://api.exchangeratesapi.io/history?start_at={exchangerate.Start_at}&end_at={exchangerate.End_at}&base={exchangerate.Base1}&symbols={exchangerate.Target}"));
var json = response.Content.ReadAsStringAsync();//
var content = await response.Content.ReadAsAsync <Rate>();
var rt = new Rate()
{
Max = double.MinValue,
Min = double.MaxValue
};
foreach (var rate in content.Rates)
{
var maxDate = DateTime.MaxValue;
var minDate = DateTime.MinValue;
if (rate.Value.First.First.Value <double>() > rt.Max)
{
rt.Max = rate.Value.First.First.Value <double>();
maxDate = DateTime.Parse(rate.Key);
}
if (rate.Value.First.First.Value <double>() < rt.Min)
{
rt.Min = rate.Value.First.First.Value <double>();
minDate = DateTime.Parse(rate.Key);
}
rt.AllRates += rate.Value.First.First.Value <double>();
{
var i = rt.AllRates / content.Rates.Count;
}
}
return(rt);
}
