public List <SearchExpense> SearchExpenses(String SearchText) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); List <SearchExpense> SearchedExpenses = new List <SearchExpense>(); List <Expens> all = db.Expenses.ToList(); for (int i = 0; i < all.Count; i++) { Expens e = all[i]; if (e.Description.Contains(SearchText)) { SearchExpense ex = new SearchExpense(); ex.Amount = e.Amount; ex.Description = e.Description; ex.BudgetName = e.Budget.Name; SearchedExpenses.Add(ex); //SearchedExpenses.Add(e); } } return(SearchedExpenses); }
public void saveExpense(Expens exp,String catName,int UserID) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User u = db.Users.Find(UserID); Budget SelectedBudget = new Budget(); foreach (Budget b in u.Budgets) { if (b.isCurrent == true) { exp.BID = b.BID; SelectedBudget = b; } } foreach(ExpenseCatagory expCat in SelectedBudget.ExpenseCatagories) { if (expCat.CatName == catName) { exp.ExpCat = expCat.ExpCatId; } } db.Expenses.Add(exp); db.SaveChanges(); }
public void saveExpense(Expens exp, String catName, int UserID) { MoneyManagementEntities2 db = new MoneyManagementEntities2(); User u = db.Users.Find(UserID); Budget SelectedBudget = new Budget(); foreach (Budget b in u.Budgets) { if (b.isCurrent == true) { exp.BID = b.BID; SelectedBudget = b; } } foreach (ExpenseCatagory expCat in SelectedBudget.ExpenseCatagories) { if (expCat.CatName == catName) { exp.ExpCat = expCat.ExpCatId; } } db.Expenses.Add(exp); db.SaveChanges(); }
public ActionResult SaveExpense(Expens expense) { String catName = Request["ddl_cat"]; exp.saveExpense(expense,catName,(int)Session["key"]); return Redirect("/DashBoard/Expenses"); }