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"));
}
}
