public ActionResult Edit([Bind(Include = "UtilityBillID,AccountToPayID,AmountToPay")] UtilityBillModel utilitybillmodel) { if (ModelState.IsValid) { db.Entry(utilitybillmodel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(utilitybillmodel)); }
public ActionResult Create([Bind(Include = "UtilityBillID,AccountToPayID,AmountToPay")] UtilityBillModel utilitybillmodel) { if (ModelState.IsValid) { db.UtilityBills.Add(utilitybillmodel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(utilitybillmodel)); }
// GET: /UtilityBill/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UtilityBillModel utilitybillmodel = db.UtilityBills.Find(id); if (utilitybillmodel == null) { return(HttpNotFound()); } return(View(utilitybillmodel)); }
public ActionResult DeleteConfirmed(int id) { AccountDBContext db2 = new AccountDBContext(); UtilityBillModel utilitybillmodel = db.UtilityBills.Find(id); var accSum = from a in db2.Accounts where a.AccountID.Equals(utilitybillmodel.AccountToPayID) select a.AccountBalance; //Check if account exists if (accSum != null) { //Check if account sum is greater than the bill if (accSum.FirstOrDefault() >= utilitybillmodel.AmountToPay) //pay { var accountToUpdate = db2.Accounts.Where(o => o.AccountID == utilitybillmodel.AccountToPayID); // update LastName for all Persons in personsToUpdate foreach (BankAccountModel p in accountToUpdate) { p.AccountBalance = accSum.FirstOrDefault() - utilitybillmodel.AmountToPay; } db.UtilityBills.Remove(utilitybillmodel); db.SaveChanges(); db2.SaveChanges(); String currentUser = User.Identity.Name; db1.Loggers.Add( new LoggerModel { dateLog = DateTime.Now, userNameLog = currentUser, transactionLog = "Utility payed for " + utilitybillmodel.AccountToPayID + " for amount " + utilitybillmodel.AmountToPay } ); db1.SaveChanges(); return(RedirectToAction("Index")); } else { return(RedirectToAction("Error1")); } } //If account does not exist else { return(RedirectToAction("Error")); } }