// 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(); } }