public JsonResult CreateBatch(IEnumerable<ViewExpense> expenses) { try { // TODO: Add insert logic here //create a new Client object int result; ExpenseMeModelContainer context = new ExpenseMeModelContainer(); foreach (ViewExpense vw in expenses) { Expense e = context.Expenses.CreateObject(); { e.Description = vw.Description; e.Spent = vw.Spent; e.ExpenseDate = vw.ExpenseDate; e.ExpenseId = 0; } context.Expenses.AddObject(e); } //save to db result = context.SaveChanges(); return this.Json(new TransactionResult() { IsError = true, StatusDescription = "Expenses posted", Data = expenses }); } 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); }
// // GET: /Expense/ public JsonResult Index() { List<ViewExpense> expenses = new List<ViewExpense>(); ExpenseMeModelContainer context = new ExpenseMeModelContainer(); var data = context.Expenses.OrderByDescending(e => e.ExpenseDate).ToList(); foreach (Expense e in data) { expenses.Add(new ViewExpense() { ExpenseId = e.ExpenseId, Description = e.Description, ExpenseDate = e.ExpenseDate.Value, FormattedExpenseDate = e.ExpenseDate.Value.ToString("MM/dd/yyyy HH:mm"), Spent = e.Spent.Value }); } return this.Json(expenses, JsonRequestBehavior.AllowGet); }