public JsonResult Create(ViewExpense expense) { try { // TODO: Add insert logic here //create a new Client object int result; ExpenseMeModelContainer context = new ExpenseMeModelContainer(); Expense e = context.Expenses.CreateObject(); { e.Description = expense.Description; e.Spent = expense.Spent; e.ExpenseDate = expense.ExpenseDate; e.ExpenseId = 0; } //save to db context.Expenses.AddObject(e); result=context.SaveChanges(); return this.Json(new TransactionResult() { IsError = true, StatusDescription = "Expense posted", Data = expense }); } catch (Exception ex) { return this.Json(new TransactionResult() { IsError = true, StatusDescription = ex.Message }); } }
// // GET: /Expense/Details/5 public JsonResult Details(int id) { ExpenseMeModelContainer context = new ExpenseMeModelContainer(); var expenseresult = context.Expenses.SingleOrDefault(e => e.ExpenseId == id); ViewExpense expense = new ViewExpense() { Description = expenseresult.Description, ExpenseDate = expenseresult.ExpenseDate.Value, ExpenseId = expenseresult.ExpenseId, Spent = expenseresult.Spent.Value }; return this.Json(expense,JsonRequestBehavior.AllowGet); }
public JsonResult Edit(ViewExpense expense) { try { // TODO: Add update logic here return this.Json(expense); } catch (Exception ex) { return this.Json(new TransactionResult() { IsError = true, StatusDescription = ex.Message }); } }