public async Task <IActionResult> GetOne(int id) { await Db.Connection.OpenAsync(); var query = new MessageQuery(Db); var result = await query.FindOneAsync(id); if (result is null) { return(new NotFoundResult()); } var json = await Task.Run(() => JsonConvert.SerializeObject(result)); return(new OkObjectResult(json)); }
public async Task <IActionResult> GetOne(int id) { using (var db = new AppDb()) { await db.Connection.OpenAsync(); var query = new MessageQuery(db); var result = await query.FindOneAsync(id); if (result == null) { return(new NotFoundResult()); } return(new OkObjectResult(result)); } }
public async Task <IActionResult> PutOne(int id, [FromBody] Message body) { using (var db = new AppDb()) { await db.Connection.OpenAsync(); var query = new MessageQuery(db); var result = await query.FindOneAsync(id); if (result == null) { return(new NotFoundResult()); } result.text = body.text; result.userid = body.userid; await result.UpdateAsync(); return(new OkObjectResult(result)); } }