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