public async Task <IActionResult> GetAll() { await Db.Connection.OpenAsync(); var query = new ProductosQuery(Db); var result = await query.AllProductosAsync(); return(new OkObjectResult(result)); }
public async Task <IActionResult> DeleteAll() { await Db.Connection.OpenAsync(); var query = new ProductosQuery(Db); await query.DeleteAllAsync(); return(new OkResult()); }
public async Task <IActionResult> GetOne(int id) { await Db.Connection.OpenAsync(); var query = new ProductosQuery(Db); var result = await query.FindOneAsync(id); if (result is null) { return(new NotFoundResult()); } return(new OkObjectResult(result)); }
public async Task <IActionResult> PutOne(int id, [FromBody] Productos body) { await Db.Connection.OpenAsync(); var query = new ProductosQuery(Db); var result = await query.FindOneAsync(id); if (result is null) { return(new NotFoundResult()); } result.nombre = body.nombre; result.codigo_barra = body.codigo_barra; result.precio = body.precio; result.disponible = body.disponible; result.detalle = body.detalle; result.imagen = body.imagen; await result.UpdateAsync(); return(new OkObjectResult(result)); }