public async Task <IActionResult> Post([FromBody] Orders body)
{
await Db.Connection.OpenAsync();
body.Db = Db;
var itemQuery = new ItemsQuery(Db);
for (int i = 0; i < body.OrdersD.Count; i++)
{
var itemId = body.OrdersD[i].IdItem;
var findItemID = itemQuery.FindOneAsync(itemId);
if (findItemID.Result == null)
{
FoundExceptions.NotFoundException(itemId);
}
}
var orderId = await body.InsertOrdersAsync();
await body.InsertOrderDetailAsync(body);
var orderQuery = new OrdersQuery(Db);
var result = await orderQuery.FindOneAsync(orderId);
return(new OkObjectResult(result[0]));
}
public async Task <ActionResult> Get(int id)
{
await Db.Connection.OpenAsync();
var query = new ItemsQuery(Db);
var result = await query.FindOneAsync(id);
if (result is null)
{
return(new NotFoundResult());
}
return(new OkObjectResult(result));
}
public async Task <IActionResult> Put(int id, [FromBody] Items body)
{
await Db.Connection.OpenAsync();
var query = new ItemsQuery(Db);
var result = await query.FindOneAsync(id);
if (result is null)
{
return(new NotFoundResult());
}
result.Name = body.Name;
result.Description = body.Description;
await result.UpdateAsync();
return(new OkObjectResult(result));
}