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