public HttpResponseMessage Get() { double rate = 0; OhayooDB db = new OhayooDB(); try { rate = ExchangeRateVietComBankUtils.VietComBank(url); //update exchage rate if (db.ExchageRates.Count() > 0) { if (db.ExchageRates.OrderByDescending(n => n.id).FirstOrDefault().exRate != rate) { ExchageRate model = new ExchageRate() { createDate = DateTime.Now, exRate = rate }; db.ExchageRates.Add(model); db.SaveChangesAsync(); } } else { ExchageRate model = new ExchageRate() { createDate = DateTime.Now, exRate = rate }; db.ExchageRates.Add(model); db.SaveChangesAsync(); } if (db.ExchageRateCharts.Count() == 0) { rate = rate * 1.02; } else { rate = rate * db.ExchageRateCharts.OrderByDescending(n => n.id).FirstOrDefault().exRate.Value; } } catch { if (db.ExchageRates.Count() > 0) { rate = db.ExchageRates.OrderByDescending(n => n.id).FirstOrDefault().exRate.Value; } } return(Request.CreateResponse(HttpStatusCode.OK, rate)); }