public async Task <IHttpActionResult> PutRate(int id, Rate rate)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != rate.Id)
{
return(BadRequest());
}
db.Entry(rate).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RateExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutCurrency(Guid id, Currency item)
{
if (id != item.Id)
{
return(BadRequest());
}
_context.Entry(item).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(NoContent());
}
public IActionResult GetAction(string BaseCurr, string Curr01, string Curr02, string Curr03, string Curr04, string Curr05, string Curr06, string Curr07, string Curr08, string Curr09, string Curr10)
{
List <string> currList = new List <string>();
if (Curr01 != null)
{
currList.Add(Curr01);
}
if (Curr02 != null)
{
currList.Add(Curr02);
}
if (Curr03 != null)
{
currList.Add(Curr03);
}
if (Curr04 != null)
{
currList.Add(Curr04);
}
if (Curr05 != null)
{
currList.Add(Curr05);
}
if (Curr06 != null)
{
currList.Add(Curr06);
}
if (Curr07 != null)
{
currList.Add(Curr07);
}
if (Curr08 != null)
{
currList.Add(Curr08);
}
if (Curr09 != null)
{
currList.Add(Curr09);
}
if (Curr10 != null)
{
currList.Add(Curr10);
}
currList.Add(BaseCurr);
Object[,] tableArray = new Object[currList.Count() + 1, 11];
tableArray[0, 0] = "Currency";
for (int i = 0; i < 10; i++)
{
tableArray[0, i + 1] = DateTime.Now.Date.AddDays(i - 9).ToString("yyyy-MM-dd");
}
int ii = 0;
var curData = db.Currencies;
foreach (var d in curData)
{
db.Entry(d).Navigation("Rates").Load();
}
foreach (string c in currList)
{
tableArray[ii + 1, 0] = BaseCurr + "/" + c;
MethodInfo mi = typeof(Rates).GetMethod("get_" + c);
for (int j = 0; j < 10; j++)
{
var it = curData.FirstOrDefault(x =>
x.Date == (string)tableArray[0, j + 1]
);
if (it != null)
{
var d = mi.Invoke(it.Rates, null);
tableArray[ii + 1, j + 1] = d;
}
}
ii++;
}
if (BaseCurr != "EUR")
{
var numRow = tableArray.GetLength(0);
var numCol = tableArray.GetLength(1);
for (int i = 1; i < numCol; i++)
{
for (int j = 1; j < numRow - 1; j++)
{
tableArray[j, i] = (float)tableArray[j, i] / (float)tableArray[numRow - 1, i];
}
}
}
return(View(tableArray));
}
