예제 #1
0
        public ActionResult Edit(int BankAccountID)
        {
            GetData();
            bankaccount bankaccount = BankAccountRepository.GetBankAccountByID(BankAccountID);

            return(PartialView(bankaccount));
        }
예제 #2
0
        public ActionResult Create()
        {
            GetData();
            IEnumerable <payee> PayeeList = PayeeRepository.GetAllPayee();

            foreach (var i in PayeeList)
            {
                i.bankaccount = BankAccountRepository.GetBankAccountByID(i.BankAccountID);
                i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.SubCategoryID);
            }
            ViewBag.RecordCount = PayeeList.Count();
            ViewBag.PayeeList   = PayeeList.OrderBy(e => e.PayeeTypeID).ThenBy(e => e.PayeeName);

            return(PartialView(new payee {
                DateEntered = System.DateTime.Today, EnteredBy = User.Identity.Name.ToString(), Status = "Active"
            }));
        }
예제 #3
0
        public ActionResult Create()
        {
            GetData();
            IEnumerable <income> IncomeList;

            IncomeList = IncomeRepository.GetIncomeByStatus("Inactive");

            ViewBag.RecordCount = IncomeList.Count();
            foreach (var i in IncomeList)
            {
                i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
                i.subcategory = SubCategoryRepository.GetBySubCategoryID(i.subCategoryID);
                if (i.CashAmount != null)
                {
                    i.TotalIncome += (decimal)i.CashAmount;
                }
                if (i.CheckAmount != null)
                {
                    i.TotalIncome += (decimal)i.CheckAmount;
                }
                if (i.CoinAmount != null)
                {
                    i.TotalIncome += (decimal)i.CoinAmount;
                }
            }

            decimal cash = (decimal)IncomeList.Sum(e => e.CashAmount);

            ViewBag.TotalCash = cash;
            decimal check = (decimal)IncomeList.Sum(e => e.CheckAmount);

            ViewBag.TotalCheck = check;
            decimal coin = (decimal)IncomeList.Sum(e => e.CoinAmount);

            ViewBag.TotalCoin = coin;

            ViewBag.TotalAmount = cash + check + coin;

            ViewBag.IncomeList = IncomeList;

            return(PartialView(new income {
                DateEntered = System.DateTime.Today, EnteredBy = User.Identity.Name.ToString(), Status = "Inactive"
            }));
        }
예제 #4
0
        public ActionResult Create(int payeeID = 0, decimal Amount = 0, int billID = 0)
        {
            GetData();
            //get pending bills
            IEnumerable <bill> bills = BillRepository.GetAllBill();

            ViewBag.PendingBills            = bills;
            ViewBag.PendingBillsRecordCount = bills.Count();
            //get pedning expenses
            IEnumerable <expense> expenses = db.expenses.Where(e => e.Status == "Unpaid");

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


            ViewBag.ExpenseType = "";
            if (payeeID > 0)
            {
                payee payee = PayeeRepository.GetPayeeByID(payeeID);
                ViewBag.ExpenseType = SubCategoryRepository.GetDisplayName(payee.SubCategoryID);

                return(PartialView(new expense {
                    PendingBillID = billID, Payee = payee.PayeeName, subCategoryID = payee.SubCategoryID, bankAccountID = payee.BankAccountID, Amount = Amount, DateEntered = System.DateTime.Today, EnteredBy = User.Identity.Name.ToString(), Status = "Unpaid"
                }));
            }
            else
            {
                return(PartialView(new expense {
                    DateEntered = System.DateTime.Today, EnteredBy = User.Identity.Name.ToString(), Status = "Unpaid"
                }));
            }
        }
예제 #5
0
        public ActionResult AccountSummaryDetail(int BudgetYear, int BankAccountID = 0)
        {
            string sYear = BudgetYear.ToString();

            if (BankAccountID != 0)
            {
                ViewBag.Title       = string.Format("{0} {1} Total Summary (YTD)", BudgetYear, BankAccountRepository.GetBankAccountByID(BankAccountID).BankName);
                ViewBag.IncomeTotal = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));
                ViewBag.IncomeJan   = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("1/31/" + sYear));
                if (DateTime.IsLeapYear(Convert.ToInt16(sYear)))
                {
                    ViewBag.IncomeFeb = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("2/1/" + sYear).Date, Convert.ToDateTime("2/29/" + sYear).Date);
                }
                else
                {
                    ViewBag.IncomeFeb = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("2/1/" + sYear), Convert.ToDateTime("2/28/" + sYear));
                }
                ViewBag.IncomeMar  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("3/1/" + sYear), Convert.ToDateTime("3/31/" + sYear));
                ViewBag.IncomeApr  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("4/1/" + sYear), Convert.ToDateTime("4/30/" + sYear));
                ViewBag.IncomeMay  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("5/1/" + sYear), Convert.ToDateTime("5/31/" + sYear));
                ViewBag.IncomeJun  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("6/1/" + sYear), Convert.ToDateTime("6/30/" + sYear));
                ViewBag.IncomeJul  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("7/1/" + sYear), Convert.ToDateTime("7/31/" + sYear));
                ViewBag.IncomeAug  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("8/1/" + sYear), Convert.ToDateTime("8/31/" + sYear));
                ViewBag.IncomeSept = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("9/1/" + sYear), Convert.ToDateTime("9/30/" + sYear));
                ViewBag.IncomeOct  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("10/1/" + sYear), Convert.ToDateTime("10/31/" + sYear));
                ViewBag.IncomeNov  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("11/1/" + sYear), Convert.ToDateTime("11/30/" + sYear));
                ViewBag.IncomeDec  = IncomeRepository.GetIncomeTotalByBankAccount(BankAccountID, Convert.ToDateTime("12/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));

                ViewBag.ExpenseTotal = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));
                ViewBag.ExpenseJan   = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("1/31/" + sYear));
                if (DateTime.IsLeapYear(Convert.ToInt16(sYear)))
                {
                    ViewBag.ExpenseFeb = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("2/1/" + sYear), Convert.ToDateTime("2/29/" + sYear));
                }
                else
                {
                    ViewBag.ExpenseFeb = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("2/1/" + sYear), Convert.ToDateTime("2/28/" + sYear));
                }
                ViewBag.ExpenseMar  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("3/1/" + sYear), Convert.ToDateTime("3/31/" + sYear));
                ViewBag.ExpenseApr  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("4/1/" + sYear), Convert.ToDateTime("4/30/" + sYear));
                ViewBag.ExpenseMay  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("5/1/" + sYear), Convert.ToDateTime("5/31/" + sYear));
                ViewBag.ExpenseJun  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("6/1/" + sYear), Convert.ToDateTime("6/30/" + sYear));
                ViewBag.ExpenseJul  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("7/1/" + sYear), Convert.ToDateTime("7/31/" + sYear));
                ViewBag.ExpenseAug  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("8/1/" + sYear), Convert.ToDateTime("8/31/" + sYear));
                ViewBag.ExpenseSept = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("9/1/" + sYear), Convert.ToDateTime("9/30/" + sYear));
                ViewBag.ExpenseOct  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("10/1/" + sYear), Convert.ToDateTime("10/31/" + sYear));
                ViewBag.ExpenseNov  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("11/1/" + sYear), Convert.ToDateTime("11/30/" + sYear));
                ViewBag.ExpenseDec  = ExpenseRepository.GetExpenseTotalByBankAccount(BankAccountID, Convert.ToDateTime("12/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));
            }
            else
            {
                ViewBag.Title       = string.Format("{0} All Account Summary (YTD)", BudgetYear);
                ViewBag.IncomeTotal = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));
                ViewBag.IncomeJan   = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("1/31/" + sYear));
                if (DateTime.IsLeapYear(Convert.ToInt16(sYear)))
                {
                    ViewBag.IncomeFeb = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("2/1/" + sYear), Convert.ToDateTime("2/29/" + sYear));
                }
                else
                {
                    ViewBag.IncomeFeb = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("2/1/" + sYear), Convert.ToDateTime("2/28/" + sYear));
                }
                ViewBag.IncomeMar  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("3/1/" + sYear), Convert.ToDateTime("3/31/" + sYear));
                ViewBag.IncomeApr  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("4/1/" + sYear), Convert.ToDateTime("4/30/" + sYear));
                ViewBag.IncomeMay  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("5/1/" + sYear), Convert.ToDateTime("5/31/" + sYear));
                ViewBag.IncomeJun  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("6/1/" + sYear), Convert.ToDateTime("6/30/" + sYear));
                ViewBag.IncomeJul  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("7/1/" + sYear), Convert.ToDateTime("7/31/" + sYear));
                ViewBag.IncomeAug  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("8/1/" + sYear), Convert.ToDateTime("8/31/" + sYear));
                ViewBag.IncomeSept = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("9/1/" + sYear), Convert.ToDateTime("9/30/" + sYear));
                ViewBag.IncomeOct  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("10/1/" + sYear), Convert.ToDateTime("10/31/" + sYear));
                ViewBag.IncomeNov  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("11/1/" + sYear), Convert.ToDateTime("11/30/" + sYear));
                ViewBag.IncomeDec  = IncomeRepository.GetIncomeTotalByDateRange(Convert.ToDateTime("12/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));

                ViewBag.ExpenseTotal = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));
                ViewBag.ExpenseJan   = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("1/1/" + sYear), Convert.ToDateTime("1/31/" + sYear));
                if (DateTime.IsLeapYear(Convert.ToInt16(sYear)))
                {
                    ViewBag.ExpenseFeb = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("2/1/" + sYear), Convert.ToDateTime("2/29/" + sYear));
                }
                else
                {
                    ViewBag.ExpenseFeb = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("2/1/" + sYear), Convert.ToDateTime("2/28/" + sYear));
                }
                ViewBag.ExpenseMar  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("3/1/" + sYear), Convert.ToDateTime("3/31/" + sYear));
                ViewBag.ExpenseApr  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("4/1/" + sYear), Convert.ToDateTime("4/30/" + sYear));
                ViewBag.ExpenseMay  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("5/1/" + sYear), Convert.ToDateTime("5/31/" + sYear));
                ViewBag.ExpenseJun  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("6/1/" + sYear), Convert.ToDateTime("6/30/" + sYear));
                ViewBag.ExpenseJul  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("7/1/" + sYear), Convert.ToDateTime("7/31/" + sYear));
                ViewBag.ExpenseAug  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("8/1/" + sYear), Convert.ToDateTime("8/31/" + sYear));
                ViewBag.ExpenseSept = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("9/1/" + sYear), Convert.ToDateTime("9/30/" + sYear));
                ViewBag.ExpenseOct  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("10/1/" + sYear), Convert.ToDateTime("10/31/" + sYear));
                ViewBag.ExpenseNov  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("11/1/" + sYear), Convert.ToDateTime("11/30/" + sYear));
                ViewBag.ExpenseDec  = ExpenseRepository.GetExpenseTotalByDateRange(Convert.ToDateTime("12/1/" + sYear), Convert.ToDateTime("12/31/" + sYear));
            }

            ViewBag.NetTotal = Convert.ToDecimal(ViewBag.IncomeTotal) - Convert.ToDecimal(ViewBag.ExpenseTotal);
            ViewBag.NetJan   = Convert.ToDecimal(ViewBag.IncomeJan) - Convert.ToDecimal(ViewBag.ExpenseJan);
            ViewBag.NetFeb   = Convert.ToDecimal(ViewBag.IncomeFeb) - Convert.ToDecimal(ViewBag.ExpenseFeb);
            ViewBag.NetMar   = Convert.ToDecimal(ViewBag.IncomeMar) - Convert.ToDecimal(ViewBag.ExpenseMar);
            ViewBag.NetApr   = Convert.ToDecimal(ViewBag.IncomeApr) - Convert.ToDecimal(ViewBag.ExpenseApr);
            ViewBag.NetMay   = Convert.ToDecimal(ViewBag.IncomeMay) - Convert.ToDecimal(ViewBag.ExpenseMay);
            ViewBag.NetJun   = Convert.ToDecimal(ViewBag.IncomeJun) - Convert.ToDecimal(ViewBag.ExpenseJun);
            ViewBag.NetJul   = Convert.ToDecimal(ViewBag.IncomeJul) - Convert.ToDecimal(ViewBag.ExpenseJul);
            ViewBag.NetAug   = Convert.ToDecimal(ViewBag.IncomeAug) - Convert.ToDecimal(ViewBag.ExpenseAug);
            ViewBag.NetSept  = Convert.ToDecimal(ViewBag.IncomeSept) - Convert.ToDecimal(ViewBag.ExpenseSept);
            ViewBag.NetOct   = Convert.ToDecimal(ViewBag.IncomeOct) - Convert.ToDecimal(ViewBag.ExpenseOct);
            ViewBag.NetNov   = Convert.ToDecimal(ViewBag.IncomeNov) - Convert.ToDecimal(ViewBag.ExpenseNov);
            ViewBag.NetDec   = Convert.ToDecimal(ViewBag.IncomeDec) - Convert.ToDecimal(ViewBag.ExpenseDec);
            return(PartialView());
        }
예제 #6
0
        public ActionResult List(string CategoryType = "Income", int budgetYear = 0, string SortType = "")
        {
            ViewBag.CategoryType = CategoryType;
            ViewBag.budgetYear   = budgetYear;

            IEnumerable <subcategory> subCategoryList;

            subCategoryList     = SubCategoryRepository.GetCategoryByCategoryType(CategoryType);
            ViewBag.RecordCount = subCategoryList.Count();
            int parentCategoryID;

            //calendar dates
            int      year        = budgetYear;
            string   bDateString = "1/1/" + year.ToString();
            DateTime bDate       = Convert.ToDateTime(bDateString).Date;

            ViewBag.CalendarBeginDate = bDate;

            string   eDateString = "12/31/" + year.ToString();
            DateTime eDate       = Convert.ToDateTime(eDateString).Date;

            ViewBag.CalendarEndDate = eDate;

            foreach (var i in subCategoryList)
            {
                i.category    = CategoryRepository.GetCategoryByID(i.categoryID);
                i.bankaccount = BankAccountRepository.GetBankAccountByID(i.bankAccountID);
                if (CategoryType == "Income")
                {
                    i.TotalYTDAmount = IncomeRepository.GetTotalIncomeByCategory(i.subCategoryID, bDate.Date, eDate.Date);
                }
                else
                {
                    i.TotalYTDAmount = ExpenseRepository.GetTotalExpenseByCategoryIncludeChildren(i.subCategoryID, bDate.Date, eDate.Date);
                }

                bool HasParent = SubCategoryItemRepository.HasParent(i.subCategoryID);
                if (HasParent)
                {
                    parentCategoryID     = SubCategoryItemRepository.GetCategoryByChild(i.subCategoryID).ParentCategoryID;
                    i.ParentCategoryName = SubCategoryRepository.GetBySubCategoryID(parentCategoryID).SubCategoryName;
                }
                else
                {
                    i.ParentCategoryName = "";
                }
            }
            if (SortType == "Category")
            {
                return(PartialView(subCategoryList.OrderBy(e => e.SubCategoryName).ThenBy(e => e.ParentCategoryName)));
            }
            else if (SortType == "Parent")
            {
                return(PartialView(subCategoryList.OrderBy(e => e.ParentCategoryName).ThenBy(e => e.ShortTitle)));
            }
            else if (SortType == "Bank Name")
            {
                return(PartialView(subCategoryList.OrderBy(e => e.bankAccountID).ThenBy(e => e.SubCategoryName)));
            }
            else if (SortType == "Short Title")
            {
                return(PartialView(subCategoryList.OrderBy(e => e.ShortTitle).ThenBy(e => e.ParentCategoryName)));
            }
            else
            {
                return(PartialView(subCategoryList.OrderBy(e => e.ShortTitle).ThenBy(e => e.ParentCategoryName)));
            }
        }