public ActionResult AddPayment(LoanHistory collection) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { try { LoanHistory history = new LoanHistory(); history.CreationDate = DateTime.Now; history.ModifyDate = DateTime.Now; history.Version = 1; history.LoanId = collection.Id; history.DatePaid = collection.DatePaid; history.BasicPayment = collection.BasicPayment; history.AddPayment = collection.AddPayment; history.Interest = collection.Interest; history.Escrow = collection.Escrow; history.PaymentTypeId = collection.PaymentTypeId; Loan loan = context.GetLoan(history.LoanId); loan.LoanHistories.Add(history); context.SubmitChanges(); return RedirectToAction("Edit", new { id = history.LoanId }); } catch { return View(collection); } } }
public ActionResult Add(Loan collection) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { try { Loan loan = new Loan(); loan.CreationDate = DateTime.Now; loan.ModifyDate = DateTime.Now; loan.Version = 1; loan.UserId = 1; loan.PaymentTypeId = 4; loan.IsActive = true; loan.Name = collection.Name; loan.FirstPaymentDate = collection.FirstPaymentDate; loan.LoanAmount = collection.LoanAmount; loan.InterestRate = collection.InterestRate; loan.Term = collection.Term; loan.AddPayment = collection.AddPayment; loan.Escrow = collection.Escrow; loan.InterestCompDaily = false; loan.InterestCompMonthly = true; context.Loans.InsertOnSubmit(loan); context.SubmitChanges(); return RedirectToAction("Index"); } catch { return View(collection); } } }
public ActionResult Add(Bill collection) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { try { Bill bill = new Bill(); bill.CreationDate = DateTime.Now; bill.ModifyDate = DateTime.Now; bill.Version = 1; bill.UserId = 1; bill.PaymentTypeId = 4; bill.IsActive = true; bill.Amount = collection.Amount; bill.DueDate = collection.DueDate; bill.IssueDate = collection.IssueDate; bill.Name = collection.Name; bill.Payee = collection.Payee; bill.Shared = collection.Shared; bill.StaysSame = collection.StaysSame; context.Bills.InsertOnSubmit(bill); context.SubmitChanges(); return RedirectToAction("Index"); } catch { return View(collection); } } }
public ActionResult AddPayment(BillHistory collection) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { try { BillHistory history = new BillHistory(); history.CreationDate = DateTime.Now; history.ModifyDate = DateTime.Now; history.Version = 1; history.BillId = collection.Id; Bill bill = context.GetBill(history.BillId); history.Bill = bill; history.Amount = collection.Amount; history.DatePaid = collection.DatePaid; history.Payee = collection.Payee; history.PaymentTypeId = collection.PaymentTypeId; history.IssueDate = collection.IssueDate; bill.BillHistories.Add(history); if (bill.StaysSame || bill.BillHistoryAverage == null) { bill.DueDate = bill.DueDate.AddMonths(1); } else { IEnumerable<BillHistoryAverage> bha = bill.BillHistoryAverage.Where(x => x.Month.Month == bill.DueDate.AddMonths(1).Month); if (bha.Any()) { bill.DueDate = bha.FirstOrDefault().Month; bill.Amount = bha.FirstOrDefault().Average; } else { bill.DueDate = bill.DueDate.AddMonths(1); } } context.SubmitChanges(); return RedirectToAction("Edit", new { id = history.BillId }); } catch { return View(collection); } } }
/* ========================= * Bill History Functions * ========================= */ public ActionResult AddPayment(int id) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { Bill bill = context.GetBill(id); BillHistory history = new BillHistory(); history.Amount = bill.Amount; history.DatePaid = bill.DueDate; history.Payee = bill.Payee; history.PaymentTypeId = bill.PaymentTypeId; history.IssueDate = bill.IssueDate; history.Bill = bill; return View(history); } }
/* ========================= * Loan History Functions * ========================= */ public ActionResult AddPayment(int id) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { Loan loan = context.GetLoan(id); LoanOutlook outlook = loan.LoanOutlook.FirstOrDefault(); LoanHistory history = new LoanHistory(); history.LoanId = loan.Id; history.BasicPayment = outlook.BaseAmount; history.AddPayment = outlook.AddAmount; history.Interest = outlook.InterestAmount; history.Escrow = outlook.EscrowAmount; history.DatePaid = outlook.Date; history.PaymentTypeId = loan.PaymentTypeId; history.Loan = loan; return View(history); } }
public ActionResult View(int id) { ViewBag.Calculate = false; using (LinkToDBDataContext context = new LinkToDBDataContext()) { return View(context.GetLoan(id)); } }
/* ========================= * Loan Functions * ========================= */ public ActionResult Index() { using (LinkToDBDataContext context = new LinkToDBDataContext()) { return View(context.GetLoans().OrderBy(x => x.DueDate)); } }
public ActionResult EditPayment(BillHistory collection) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { BillHistory history = context.GetBillHistoryItem(collection.Id); try { history.ModifyDate = DateTime.Now; history.Version += 1; history.DatePaid = collection.DatePaid; history.Amount = collection.Amount; history.Payee = collection.Payee; history.IssueDate = collection.IssueDate; context.SubmitChanges(); return RedirectToAction("Edit", new { id = history.BillId }); } catch { return View(history); } } }
public ActionResult EditPayment(int id) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { BillHistory history = context.GetBillHistoryItem(id); history.Bill = context.GetBill(history.BillId); return View(history); } }
public ActionResult Edit(int id, Loan collection, string button) { ViewBag.Calculate = false; using (LinkToDBDataContext context = new LinkToDBDataContext()) { Loan loan = context.GetLoan(id); try { loan.ModifyDate = DateTime.Now; loan.Version += 1; loan.Name = collection.Name; loan.FirstPaymentDate = collection.FirstPaymentDate; loan.LoanAmount = collection.LoanAmount; loan.InterestRate = collection.InterestRate; loan.Term = collection.Term; loan.AddPayment = collection.AddPayment; loan.Escrow = collection.Escrow; switch (button) { case "Calculate": loan = loan.LoadLoan(); ViewBag.Calculate = true; return View(loan); case "Save": context.SubmitChanges(); return RedirectToAction("Index"); default: return View(loan); } } catch { return View(loan); } } }
public ActionResult Index() { using (LinkToDBDataContext context = new LinkToDBDataContext()) { DashboardViewModel viewModel = new DashboardViewModel(); IEnumerable<Bill> bills = context.GetBills(); IEnumerable<Loan> loans = context.GetLoans(); DateTime startDate = DateTime.Now; foreach (Bill bill in bills) { startDate = (bill.DueDate <= startDate) ? bill.DueDate : startDate; } foreach (Loan loan in loans) { startDate = (loan.DueDate <= startDate) ? loan.DueDate : startDate; } if (startDate.Day > 1) { //startDate = startDate.AddMonths(-1); startDate = new DateTime(startDate.Year, startDate.Month, 1); } viewModel.DateRanges = InitiateDateRanges(startDate); foreach (DashboardDateRange range in viewModel.DateRanges) { List<DashboardItem> items = new List<DashboardItem>(); foreach (Bill bill in bills) { if (bill.DueDate >= range.StartDate && bill.DueDate <= range.EndDate) { items.Add(new DashboardItem(bill)); } if (bill.StaysSame || !bill.BillHistories.Any()) { for (int i = 1; i <= 3; i++) { DateTime date = bill.DueDate.AddMonths(i); if (date >= range.StartDate && date <= range.EndDate) { DashboardItem item = new DashboardItem(bill); item.Date = date; item.IsPastDue = item.DueInDays < 0; items.Add(item); } } } else { Bill difBill = context.GetBill(bill.Id); foreach (BillHistoryAverage bha in difBill.BillHistoryAverage) { if (bha.Month >= range.StartDate && bha.Month <= range.EndDate && bha.Month.Month != bill.DueDate.Month) { DashboardItem item = new DashboardItem(bha); item.Id = bill.Id; item.Name = bill.Name; items.Add(item); } } } if (bill.BillHistories.Any()) { foreach (BillHistory history in bill.BillHistory) { if (history.DatePaid >= range.StartDate && history.DatePaid <= range.EndDate) { items.Add(new DashboardItem(history)); } } } } foreach (Loan loan in loans) { foreach (LoanOutlook outlook in loan.LoanOutlook) { if (outlook.Date >= range.StartDate && outlook.Date <= range.EndDate) { DashboardItem dbItem = new DashboardItem(outlook); dbItem.Name = loan.Name; dbItem.Id = loan.Id; items.Add(dbItem); } } foreach (LoanHistory history in loan.LoanHistory) { if (history.DatePaid >= range.StartDate && history.DatePaid <= range.EndDate) { items.Add(new DashboardItem(history)); } } } range.Items = items.OrderBy(x => x.Date); } return View(viewModel); } }
public ActionResult View(int id) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { return View(context.GetBill(id)); } }
public ActionResult Paid(int id) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { BillHistory history = new BillHistory(); history.CreationDate = DateTime.Now; history.ModifyDate = DateTime.Now; history.Version = 1; history.BillId = id; Bill bill = context.GetBill(id); history.Amount = bill.Amount; history.DatePaid = bill.DueDate; history.Payee = bill.Payee; history.PaymentTypeId = bill.PaymentTypeId; history.IssueDate = bill.IssueDate; history.Bill = bill; if (bill.StaysSame || bill.BillHistoryAverage == null) { bill.DueDate = bill.DueDate.AddMonths(1); } else { IEnumerable<BillHistoryAverage> bha = bill.BillHistoryAverage.Where(x => x.Month.Month == bill.DueDate.AddMonths(1).Month); if (bha.Any()) { bill.DueDate = bha.FirstOrDefault().Month; bill.Amount = bha.FirstOrDefault().Average; } else { bill.DueDate = bill.DueDate.AddMonths(1); } } context.SubmitChanges(); return RedirectToAction("Index", "Home", null); } }
/* ========================= * Bill Functions * ========================= */ public ActionResult Index() { using (LinkToDBDataContext context = new LinkToDBDataContext()) { return View(context.GetBills().Where(x => x.IsActive == true && x.DueInDays <= 45).OrderBy(x => x.DueDate)); } }
public ActionResult Edit(int id, Bill collection) { using (LinkToDBDataContext context = new LinkToDBDataContext()) { Bill bill = context.GetBill(id); try { bill.ModifyDate = DateTime.Now; bill.Version += 1; bill.Name = collection.Name; bill.Payee = collection.Payee; bill.DueDate = collection.DueDate; bill.Amount = collection.Amount; bill.IssueDate = collection.IssueDate; bill.StaysSame = collection.StaysSame; bill.Shared = collection.Shared; context.SubmitChanges(); return RedirectToAction("Index"); } catch { return View(bill); } } }