public ActionResult DeleteConfirmed(int id) { AccountBalanceEntry accountBalanceEntry = db.AccountBalanceEntries.Find(id); db.AccountBalanceEntries.Remove(accountBalanceEntry); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Date,Amount,AccountId")] AccountBalanceEntry accountBalanceEntry) { if (ModelState.IsValid) { db.Entry(accountBalanceEntry).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AccountId = new SelectList(db.Accounts, "Id", "Name", accountBalanceEntry.AccountId); return(View(accountBalanceEntry)); }
// GET: AccountBalanceEntries/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AccountBalanceEntry accountBalanceEntry = db.AccountBalanceEntries.Find(id); if (accountBalanceEntry == null) { return(HttpNotFound()); } return(View(accountBalanceEntry)); }
// GET: AccountBalanceEntries/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AccountBalanceEntry accountBalanceEntry = db.AccountBalanceEntries.Find(id); if (accountBalanceEntry == null) { return(HttpNotFound()); } ViewBag.AccountId = new SelectList(db.Accounts, "Id", "Name", accountBalanceEntry.AccountId); return(View(accountBalanceEntry)); }
//Move to general? public static decimal GetCurrentBalance(Account account) { PrimaryContext db = new PrimaryContext(); decimal retVal = decimal.Zero; if (db.AccountBalanceEntries.Any(x => x.AccountId == account.Id)) { AccountBalanceEntry lastEntry = db.AccountBalanceEntries.Where(x => x.AccountId == account.Id) .OrderByDescending(x => x.Date).First(); retVal = lastEntry.Amount; } // AccountBalanceEntry lastEntry = db.AccountBalanceEntries.Where(x => x.AccountId == account.Id).Last(); return(retVal); }