// GET: Currencies
public ActionResult ExchangerIndex()
{
List<exchanger> model = new List<exchanger>();
model = db.exchangers.ToList();
List<ExchangerModel> em = new List<ExchangerModel>();
foreach (var x in model)
{
ExchangerModel exm = new ExchangerModel();
var cur1 = (from currency in db.currencies
where currency.currency_id == x.currency_id1
select currency).SingleOrDefault();
exm.currency1 = cur1;
var cur2 = (from currency in db.currencies
where currency.currency_id == x.currency_id2
select currency).SingleOrDefault();
exm.currency2 = cur2;
exm.value = x.value;
em.Add(exm);
}
return View(em);
}
public ActionResult EditExchanger(int id , int id2)
{
if (Request.Form["value"] != null)
{
var exch = (from exchanger in db.exchangers
where exchanger.currency_id1 == id && exchanger.currency_id2 == id2
select exchanger).SingleOrDefault();
exch.value = Convert.ToDouble(Request.Form["value"].ToString());
try
{
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
// Make some adjustments.
// ...
// Try again.
db.SubmitChanges();
}
return RedirectToAction("ExchangerIndex", "Currencies");
}
else
{
var exch = (from exchanger in db.exchangers
where exchanger.currency_id1 == id && exchanger.currency_id2 == id2
select exchanger).SingleOrDefault();
var cur1 = (from currency in db.currencies
where currency.currency_id == exch.currency_id1
select currency).SingleOrDefault();
var cur2 = (from currency in db.currencies
where currency.currency_id == exch.currency_id2
select currency).SingleOrDefault();
ExchangerModel exchm = new ExchangerModel();
exchm.currency1 = cur1;
exchm.currency2 = cur2;
exchm.value = exch.value;
ViewData["ExchangerModel"] = exchm;
List<currency> Currencies = new List<currency>();
Currencies = db.currencies.ToList();
ViewData["Currencies"] = Currencies;
ViewData["ExchangerModel"] = exchm;
return View();
}
}
