public bool AddRecord(bankbalance Record) { //myRecords.Add(record); context.bankbalances.Add(Record); context.SaveChanges(); return(true); }
public ActionResult DeleteConfirmed(int BankBalanceID) { bankbalance bankbalance = BankBalanceRepository.GetByBankBalanceID(BankBalanceID); BankBalanceRepository.DeleteRecord(bankbalance); return(RedirectToAction("Index")); }
public ActionResult Delete(int BankBalanceID) { ViewBag.BankBalanceID = BankBalanceID; bankbalance bankbalance = BankBalanceRepository.GetByBankBalanceID(BankBalanceID); return(PartialView(bankbalance)); }
public ActionResult Edit(bankbalance bankbalance) { string bankName = db.bankaccounts.Find(bankbalance.BankAccountID).BankName; try { if (ModelState.IsValid) { db.Entry(bankbalance).State = EntityState.Modified; db.SaveChanges(); TempData["Message2"] = string.Format("{0} balance update successfully.", bankName); return(RedirectToAction("Edit", new { id = bankbalance.BankBalanceID })); } } catch (Exception ex) { TempData["Message2"] = string.Format("Error editing {0} balance.", bankName); } return(View(bankbalance)); }
public ActionResult Create(bankbalance bankbalance) { try { if (ModelState.IsValid) { bankbalance.LastIncomeID = IncomeRepository.GetLastIncomeRecordID(); bankbalance.LastExpenseID = ExpenseRepository.GetLastExpenseRecordID(); db.bankbalances.Add(bankbalance); db.SaveChanges(); BankBalanceRepository.AddRecord(bankbalance); TempData["Message2"] = "Bank balance created successfully."; return(RedirectToAction("Create")); } } catch (Exception ex) { TempData["Message2"] = "Error ocurred creating bank balance."; } return(View(bankbalance)); }
public ActionResult GetCurrentBankBalance() { bankbalance Lastbalance = new bankbalance(); IEnumerable <bankaccount> bankaccount = BankAccountRepository.GetAllBankAccount(); foreach (bankaccount bank in bankaccount) { Lastbalance = BankBalanceRepository.GetLastBankBlance(bank.bankAccountID); if (Lastbalance == null) { bank.BeginningBalance = IncomeRepository.GetIncomeTotalByBankAccount(bank.bankAccountID, bank.DateEntered, System.DateTime.Today); bank.CurrentRevenueTotalAmount = IncomeRepository.GetPendingIncomeTotalByBankAccount(bank.bankAccountID); bank.CurrentExpenseTotalAmount = ExpenseRepository.GetPendingExpenseTotalByBankAccount(bank.bankAccountID); } else { bank.BeginningBalance = Lastbalance.EndingBalance; bank.CurrentRevenueTotalAmount = IncomeRepository.GetPendingIncomeTotalByBankAccount(bank.bankAccountID); bank.CurrentExpenseTotalAmount = ExpenseRepository.GetPendingExpenseTotalByBankAccount(bank.bankAccountID); } } return(PartialView(bankaccount)); }
/* * public bool AddRecord(bankbalance record) * { * myRecords.Add(record); * context.SaveChanges(); * return true; * } */ public void DeleteRecord(bankbalance Record) { myRecords.Remove(record); context.bankbalances.Remove(record); context.SaveChanges(); }
public bankbalance GetLastBankBlance(int bankAccountID) { record = myRecords.Where(e => e.BankAccountID == bankAccountID).OrderByDescending(e => e.EndDate).Take(1).SingleOrDefault(); return(record); }
public bankbalance GetByBankBalanceID(int BankBalanceID) { record = myRecords.FirstOrDefault(e => e.BankBalanceID == BankBalanceID); return(record); }
public ActionResult CommitExpenses() { string ReturnUrl = Request.UrlReferrer.ToString(); try { bankaccount aBank; bankbalance Lastbalance = new bankbalance(); bankbalance NewBankBalance = new bankbalance(); IEnumerable <expense> PendingExpenses = db.expenses.Where(e => e.Status == "Unpaid"); foreach (int bankID in PendingExpenses.Select(e => e.bankAccountID).Distinct()) { Lastbalance = BankBalanceRepository.GetLastBankBlance(bankID); if (Lastbalance == null) { aBank = BankAccountRepository.GetBankAccountByID(bankID); NewBankBalance.BeginDate = BankAccountRepository.GetBankAccountByID(bankID).DateEntered; NewBankBalance.BeginingBalance = IncomeRepository.GetIncomeTotalByBankAccount(bankID, aBank.DateEntered, System.DateTime.Today); } else { NewBankBalance.BeginDate = Lastbalance.EndDate.AddDays(1); NewBankBalance.BeginingBalance = Lastbalance.EndingBalance; } NewBankBalance.BankAccountID = bankID; NewBankBalance.EndDate = System.DateTime.Today; NewBankBalance.LastIncomeID = IncomeRepository.GetLastIncomeRecordID(); NewBankBalance.LastExpenseID = ExpenseRepository.GetLastExpenseRecordID(); decimal revenueAmt = IncomeRepository.GetPendingIncomeTotalByBankAccount(bankID); if (revenueAmt == null) { NewBankBalance.RevenueAmount = 0; } else { NewBankBalance.RevenueAmount = revenueAmt; } NewBankBalance.ExpenseAmount = ExpenseRepository.GetPendingExpenseTotalByBankAccount(bankID); NewBankBalance.EndingBalance = NewBankBalance.BeginingBalance + NewBankBalance.RevenueAmount - NewBankBalance.ExpenseAmount; BankBalanceRepository.AddRecord(NewBankBalance); } //Activate pending income and expense records foreach (expense i in PendingExpenses) { i.Status = "Active"; } db.SaveChanges(); IEnumerable <income> PendingIncomes = IncomeRepository.GetIncomeByStatus("Inactive"); foreach (income i in PendingIncomes) { i.Status = "Active"; } db.SaveChanges(); //update bills status IEnumerable <bill> processingBills = BillRepository.GetBillByStatus("Processing"); foreach (bill i in processingBills) { i.Status = "Paid"; } db.SaveChanges(); TempData["Message2"] = string.Format("Expense committed successfully"); return(RedirectToAction("Create")); } catch (Exception ex) { TempData["Message2"] = string.Format("Error:Expense fail to commit"); } return(Redirect(ReturnUrl)); }
public ActionResult Edit(int BankBalanceID) { bankbalance bankbalance = BankBalanceRepository.GetByBankBalanceID(BankBalanceID); return(PartialView(bankbalance)); }