public async Task <IActionResult> GetOne(int id) { //"server=localhost;user id=root;password=ch@rm1n9;port=3306;database=miracakesdb" using (var db = new AppDb()) { await db.Connection.OpenAsync(); var query = new ProductQuery(db); var result = await query.FindOneAsync(id); if (result == null) { return(new NotFoundResult()); } return(new OkObjectResult(result)); } }
public async Task <IActionResult> DeleteOne(int id) { using (var db = new AppDb()) { await db.Connection.OpenAsync(); var query = new ProductQuery(db); var result = await query.FindOneAsync(id); if (result == null) { return(new NotFoundResult()); } await result.DeleteAsync(); return(new OkResult()); } }
public async Task <IActionResult> PutOne(int id, [FromBody] Product body) { using (var db = new AppDb()) { await db.Connection.OpenAsync(); var query = new ProductQuery(db); var result = await query.FindOneAsync(id); if (result == null) { return(new NotFoundResult()); } result.ProductName = body.ProductName; await result.UpdateAsync(); return(new OkObjectResult(result)); } }