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