public JsonResult add([FromBody] budgetCategory c)
{
if (c.budgetCategoryID == -1)
{
budgetCategory newCat = new budgetCategory();
newCat.name = c.name;
newCat.amount = c.amount;
newCat.budgetID = c.budgetID;
newCat.isRecurring = c.isRecurring;
DbContext.budgetCategories.Add(newCat);
DbContext.SaveChanges();
return(new JsonResult(newCat, new JsonSerializerSettings()
{
Formatting = Formatting.Indented
}));
}
else
{
//do an update
var q = from i in DbContext.budgetCategories select i;
var updatedCat = q.Single();
updatedCat.amount = c.amount;
updatedCat.name = c.name;
DbContext.SaveChanges();
return(new JsonResult(updatedCat, new JsonSerializerSettings()
{
Formatting = Formatting.Indented
}));
}
}
public JsonResult delete([FromBody] budgetCategory cat)
{
DbContext.budgetCategories.Attach(cat);
DbContext.budgetCategories.Remove(cat);
DbContext.SaveChanges();
return(new JsonResult(cat, new JsonSerializerSettings()
{
Formatting = Formatting.Indented
}));
}
public decimal edit([FromBody] budgetCategory c)
{
var q = from rec in DbContext.budgetCategories where rec.budgetCategoryID == c.budgetCategoryID select rec;
budgetCategory cat = q.SingleOrDefault();
decimal oldAmount = cat.amount;
cat.name = c.name;
cat.amount = c.amount;
cat.isRecurring = c.isRecurring;
DbContext.SaveChanges();
return(c.amount - oldAmount);
}
