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