public IActionResult EditTransaction([FromBody] BudgetTransactionDataModel updatedTrans)
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
BudgetTransactionDataModel item = ctx.BudgetTransactions.FirstOrDefault(x => x.Id == updatedTrans.Id);
try
{
var trans = updatedTrans;
item.LastModifiedBy = 1;
item.DateLastModified = DateTime.UtcNow;
item.Amount = trans.Amount;
item.Name = trans.Name;
item.BudgetCategoryId = trans.BudgetCategoryId;
item.TransactionDate = trans.TransactionDate;
ctx.BudgetTransactions.Update(item);
ctx.SaveChanges();
return(Ok(item));
}
catch (Exception e)
{
return(StatusCode(500, item));
}
}
}
public IActionResult DeleteTransaction(int id)
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
BudgetTransactionDataModel item = ctx.BudgetTransactions.FirstOrDefault(x => x.Id == id);
try
{
ctx.BudgetTransactions.Remove(item);
ctx.SaveChanges();
return(Ok());
}
catch (Exception e)
{
return(StatusCode(500, item));
}
}
}
public IActionResult AddTransaction([FromBody] BudgetTransactionDataModel newTrans)
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
try
{
var trans = newTrans;
trans.AddedBy = 1;
trans.DateAdded = DateTime.UtcNow;
trans.BudgetCategoryId = newTrans.BudgetCategoryId;
trans.Amount = newTrans.Amount;
trans.Name = newTrans.Name;
ctx.BudgetTransactions.Add(trans);
ctx.SaveChanges();
return(Ok(trans));
}
catch (Exception e)
{
return(StatusCode(500, newTrans));
}
}
}
