Exemple #1
0
        public ActionResult DeleteConfirmed(int id)
        {
            AccountBalanceEntry accountBalanceEntry = db.AccountBalanceEntries.Find(id);

            db.AccountBalanceEntries.Remove(accountBalanceEntry);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Exemple #2
0
 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));
 }
Exemple #3
0
        // 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));
        }
Exemple #4
0
        // 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);
        }