public ActionResult Delete(int PayeeID)
{
ViewBag.PayeeID = PayeeID;
payee payee = PayeeRepository.GetPayeeByID(PayeeID);
return(PartialView(payee));
}
public ActionResult Edit(int PayeeID)
{
GetData();
payee payee = PayeeRepository.GetPayeeByID(PayeeID);
return(PartialView(payee));
}
public ActionResult DeleteConfirmed(int PayeeID)
{
payee payee = PayeeRepository.GetPayeeByID(PayeeID);
PayeeRepository.DeleteRecord(payee);
TempData["Message2"] = string.Format("{0} record deleted successfully.", payee.PayeeName);
return(RedirectToAction("Create"));
}
public string PayeeCategory(string Payee)
{
payee payee = PayeeRepository.GetPayeeByName(Payee);
if (payee == null)
{
return("");
}
subcategory catgy = SubCategoryRepository.GetBySubCategoryID(payee.SubCategoryID);
catgy.DisplayName = SubCategoryRepository.GetDisplayName(catgy.subCategoryID);
return(catgy.DisplayName);
}
public ActionResult Create(payee payee)
{
payee p = PayeeRepository.GetAllPayee().FirstOrDefault(e => e.PayeeName == payee.PayeeName && e.AccountNumber == payee.AccountNumber);
if (p != null)
{
TempData["Message2"] = string.Format("Payee <{0}> already exist", p.PayeeName);
return(RedirectToAction("Create"));
}
int bankaccountID = db.subcategories.Find(payee.SubCategoryID).bankAccountID;
if (payee.Email == null)
{
payee.Email = "Null";
}
if (payee.PhoneNumber == null)
{
payee.PhoneNumber = "Null";
}
if (payee.URL == null)
{
payee.URL = "Null";
}
try
{
payee.BankAccountID = bankaccountID;
if (ModelState.IsValid)
{
db.payees.Add(payee);
db.SaveChanges();
PayeeRepository.AddRecord(payee);
TempData["Message2"] = "Payee record created successfully.";
GetData();
return(RedirectToAction("Create"));
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error ocurred creating payee.";
}
GetData();
return(PartialView(payee));
}
public ActionResult Edit(payee payee)
{
try
{
if (ModelState.IsValid)
{
db.Entry(payee).State = EntityState.Modified;
db.SaveChanges();
TempData["Message2"] = string.Format("{0} record update successfully.", payee.PayeeName);
return(RedirectToAction("Create"));
}
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error editing {0} record.", payee.PayeeName);
}
GetData();
return(PartialView(payee));
}
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"
}));
}
}
public ActionResult Create(bill bill)
{
if (bill.payeeID == 0)
{
TempData["Message2"] = "Error adding bill. Please select payee.";
GetData();
ViewBag.Year = 0;
return(PartialView(bill));
}
try
{
payee p = PayeeRepository.GetPayeeByID(bill.payeeID);
bill.AccountNumber = p.AccountNumber;
bill.PayeeName = p.PayeeName;
if (bill.Comment == null)
{
bill.Comment = "";
}
if (ModelState.IsValid)
{
db.bills.Add(bill);
db.SaveChanges();
billRepository.AddRecord(bill);
TempData["Message2"] = "Bill added successfully.";
GetData();
return(RedirectToAction("Create"));
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error adding bill";
}
GetData();
return(PartialView(bill));
}
public ActionResult Details(int id)
{
payee payee = db.payees.Find(id);
return(PartialView(payee));
}
public payee GetPayeeByID(int payeeID)
{
record = myRecords.FirstOrDefault(e => e.payeeID == payeeID);
return(record);
}
public void AddRecord(payee Record)
{
myRecords.Add(record);
}
public void DeleteRecord(payee record)
{
myRecords.Remove(record);
context.payees.Remove(record);
context.SaveChanges();
}
public payee GetPayeeByName(string payee)
{
record = myRecords.FirstOrDefault(e => e.PayeeName == payee);
return(record);
}
public payee GetPayeeByAccountNumber(string accountNumber)
{
record = myRecords.FirstOrDefault(e => e.AccountNumber == accountNumber);
return(record);
}
