public IActionResult DeleteCategory(int id)
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
BudgetCategoryDataModel item = ctx.BudgetCategories.FirstOrDefault(x => x.Id == id);
try
{
ctx.BudgetCategories.Remove(item);
ctx.SaveChanges();
return(Ok());
}
catch (Exception e)
{
return(StatusCode(500, item));
}
}
}
public IActionResult AddCategory([FromBody] BudgetCategoryDataModel newCat)
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
try
{
var cat = newCat;
cat.AddedBy = 1;
cat.DateAdded = DateTime.UtcNow;
cat.Budgeted = newCat.Budgeted;
cat.Name = newCat.Name;
ctx.BudgetCategories.Add(cat);
ctx.SaveChanges();
return(Ok(cat));
}
catch (Exception e)
{
return(StatusCode(500, newCat));
}
}
}
public IActionResult EditCategory([FromBody] BudgetCategoryDataModel updatedCat)
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
BudgetCategoryDataModel item = ctx.BudgetCategories.FirstOrDefault(x => x.Id == updatedCat.Id);
try
{
var cat = updatedCat;
item.LastModifiedBy = 1;
item.DateLastModified = DateTime.UtcNow;
item.Budgeted = cat.Budgeted;
item.Name = cat.Name;
ctx.BudgetCategories.Update(item);
ctx.SaveChanges();
return(Ok(item));
}
catch (Exception e)
{
return(StatusCode(500, item));
}
}
}
