public ActionResult Create([Bind(Include = "Id,HAName,HhId,Balance")] HouseAccount houseAccount) { if (ModelState.IsValid) { var account = db.HAccounts.FirstOrDefault(t => t.HAName == t.HAName); if (account != null) { Transaction beginBal = new Transaction(); beginBal.Amount = houseAccount.Balance; beginBal.Descript = "Beginning Balance"; beginBal.Created = DateTime.Now; beginBal.HAccountId = houseAccount.Id; beginBal.Reconcile = true; beginBal.Type = "income"; db.Transactions.Add(beginBal); db.HAccounts.Add(houseAccount); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.Message = "An account by this name already exists. Please use a unique name."; return(View()); } } ViewBag.HhId = new SelectList(db.Households, "Id", "Id", houseAccount.HhId); return(View(houseAccount)); }
// GET: HouseAccounts/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HouseAccount houseAccount = db.HAccounts.Find(id); var trx = db.Transactions.Where(t => t.HAccountId == houseAccount.Id).Include(t => t.Cat); decimal bankBal = 0; foreach (var rec in trx) { if (rec.Reconcile == true) { if (rec.Type == "income") { bankBal += rec.Amount; } else { bankBal -= rec.Amount; } } } ViewBag.bankBal = bankBal; return(View(houseAccount)); }
public ActionResult DeleteConfirmed(int id) { HouseAccount houseAccount = db.HouseAccounts.Find(id); db.HouseAccounts.Remove(houseAccount); db.SaveChanges(); return(RedirectToAction("Index", "Households")); }
public ActionResult Edit([Bind(Include = "Id,HouseholdId,Name,Balance,ReconciledBalace")] HouseAccount houseAccount) { if (ModelState.IsValid) { db.Entry(houseAccount).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "Households")); } ViewBag.HouseholdId = new SelectList(db.Households, "Id", "Name", houseAccount.HouseholdId); return(View(houseAccount)); }
public ActionResult Edit([Bind(Include = "Id,HAName,HhId,Balance")] HouseAccount houseAccount) { if (ModelState.IsValid) { db.Entry(houseAccount).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(houseAccount)); }
public ActionResult Create([Bind(Include = "Id,HouseholdId,Name,Balance,ReconciledBalace")] HouseAccount houseAccount) { if (ModelState.IsValid) { houseAccount.HouseholdId = HouseholdHelper.GetUserHouseholdId(User.Identity.GetUserId()).Value; houseAccount.ReconciledBalace = 0.00M; db.HouseAccounts.Add(houseAccount); db.SaveChanges(); return(RedirectToAction("Index", "Households")); } ViewBag.HouseholdId = new SelectList(db.Households, "Id", "Name", houseAccount.HouseholdId); return(View(houseAccount)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HouseAccount houseAccount = db.HouseAccounts.Find(id); if (houseAccount == null) { return(HttpNotFound()); } //ViewBag.HouseholdId = new SelectList(db.Households, "Id", "Name", houseAccount.HouseholdId); return(View(houseAccount)); }
public ActionResult DeleteConfirmed(int id) { var transactions = db.Transactions.Where(t => t.HAccountId == id); foreach (var tr in transactions) { tr.CatId = null; tr.HAccountId = null; db.Transactions.Remove(tr); } HouseAccount houseAccount = db.HAccounts.Find(id); db.HAccounts.Remove(houseAccount); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: HouseAccounts/Delete/5 public PartialViewResult _Delete(int?id) { HouseAccount houseAccount = db.HAccounts.Find(id); return(PartialView(houseAccount)); }