Example #1
0
        public ActionResult ListActive()
        {
            //GetData();
            IEnumerable <expense> ExpenseList;

            ExpenseList = ExpenseRepository.GetExpenseByStatus("Unpaid");

            ViewBag.RecordCount = ExpenseList.Count();
            foreach (var i in ExpenseList)
            {
                i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.subCategoryID);
                i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
            }

            return(PartialView(ExpenseList));
        }
Example #2
0
        public ActionResult List(DateTime bDate, DateTime eDate, string code = "", int codeID = 0, string ReportType = "")
        {
            ViewBag.ReportType = ReportType;
            GetData();
            IEnumerable <expense> ExpenseList;

            if (code == "BankAccountSearch")
            {
                ExpenseList = ExpenseRepository.GetExpenseByBankAccount(codeID, bDate, eDate);
            }
            else if (code == "CategorySearch")
            {
                ExpenseList = ExpenseRepository.GetExpenseByCategory(codeID, bDate, eDate);
            }
            else if (code == "DateRangeSearch")
            {
                ExpenseList = ExpenseRepository.GetExpenseByDateRange(bDate.Date, eDate.Date);
            }
            else if (code == "CurrentExpense")
            {
                ExpenseList = ExpenseRepository.GetExpenseByStatus("Unpaid");
            }
            else
            {
                ExpenseList = ExpenseRepository.GetExpenseByDate(bDate);
            }

            ViewBag.RecordCount = ExpenseList.Count();

            foreach (var i in ExpenseList)
            {
                i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.subCategoryID);
                i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
            }
            ViewBag.TotalExpense = ExpenseList.Sum(e => e.Amount);
            return(PartialView(ExpenseList));
        }