public async static Task Update(m.DailyTransaction obj)
{
using (var db = DbAccess.ConnectionFactory())
{
await db.ExecuteAsync(DbAccess.Update <m.DailyTransaction>(), obj);
}
}
public async Task <IActionResult> Post([FromBody] m.DailyTransaction data)
{
try
{
await d.Transaction.Insert(data);
return(Ok(data));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async static Task <m.DailyTransaction> Get(Guid id)
{
using (var db = DbAccess.ConnectionFactory())
{
m.DailyTransaction transaction = await db.QueryFirstOrDefaultAsync <m.DailyTransaction>(DbAccess.Select <m.DailyTransaction>(),
new { TransactionId = id });
transaction.Category = await Category.Get(transaction.CategoryId);
transaction.Account = await Account.Get(transaction.AccountId);
return(transaction);
}
}
public async Task <IActionResult> Put(Guid id, [FromBody] m.DailyTransaction data)
{
try
{
if (id != data.TransactionId)
{
return(BadRequest());
}
await d.Transaction.Update(data);
return(Ok(data));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
