public async Task <Result <TransacBudgetData> > FindTBudgetById(int tBudgetId)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
TransacBudgetData tBudget = await con.QueryFirstOrDefaultAsync <TransacBudgetData>(
@"select
tb.TBudgetId,
tb.Price,
tb.Date,
tb.BudgetId,
tb.RoomieId
from rm.tTransacBudget tb
where tb.TBudgetId = @TBudgetId;",
new { TBudgetId = tBudgetId });
if (tBudget == null)
{
return(Result.Failure <TransacBudgetData>(Status.NotFound, "Transaction not found"));
}
return(Result.Success(tBudget));
}
}
public async Task<IActionResult> UpdateTransacBudget( [FromBody] TransacBudgetData model )
{
Result result = await _tBudgetGateway.UpdateTransacBudget( model.TBudgetId, model.Price, model.Date, model.BudgetId, model.RoomieId );
return this.CreateResult( result );
}