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