protected override void DisposeCore() { if (dbContext != null) { dbContext.Dispose(); } }
public ActionResult Add(view_Expense UpdatedExpenses) { AssignmentEntities db = new AssignmentEntities(); Expense expenses = new Expense(); expenses.Description = UpdatedExpenses.Description; expenses.Date = UpdatedExpenses.Date; expenses.Amount = UpdatedExpenses.Amount; Category category = db.Categories.Where(x => x.CategoryName == UpdatedExpenses.CategoryName).FirstOrDefault(); if (category == null) { Category new_category = new Category(); new_category.CategoryName = UpdatedExpenses.CategoryName; db.Categories.Add(new_category); db.SaveChanges(); category = db.Categories.Where(x => x.CategoryName == UpdatedExpenses.CategoryName).FirstOrDefault(); } expenses.CategoryId = category.CategoryId; db.Expenses.Add(expenses); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }
protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
public ActionResult Delete(int id) { AssignmentEntities db = new AssignmentEntities(); view_Expense expences2 = db.view_Expense.Where(x => x.ExpenseId == id).FirstOrDefault(); db.Dispose(); return(View(expences2)); }
// GET: Money public ActionResult Index() { AssignmentEntities db = new AssignmentEntities(); List <view_Expense> expences = db.view_Expense.ToList(); db.Dispose(); return(View(expences)); }
public ActionResult Delete(int id) { AssignmentEntities db = new AssignmentEntities(); Category categery = db.Categories.Where(x => x.CategoryId == id).FirstOrDefault(); db.Dispose(); return(View(categery)); }
public ActionResult Add(Category categery) { AssignmentEntities db = new AssignmentEntities(); db.Categories.Add(categery); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }
public ActionResult Remove(view_Expense UpdatedExpenses) { AssignmentEntities db = new AssignmentEntities(); Expense expences = db.Expenses.Where(x => x.ExpenseId == UpdatedExpenses.ExpenseId).FirstOrDefault(); db.Expenses.Remove(expences); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }
public ActionResult Remove(Category categoryEdited) { AssignmentEntities db = new AssignmentEntities(); Category category = db.Categories.Where(x => x.CategoryId == categoryEdited.CategoryId).FirstOrDefault(); db.Categories.Remove(category); db.SaveChanges(); db.Dispose(); return(Redirect("Index")); }