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