public async Task <int> Create(CoffeeItemDto coffeeItem)
{
var sql = @"INSERT INTO Coffee (name, description, caffeineContent)
Values (@Name, @Description, @CaffeineContent);
SELECT CAST(SCOPE_IDENTITY() as int)";
using (var conn = sqlServerConnectionProvider.GetDbConnection())
{
var result = await conn.QueryAsync <int>(sql,
new
{
coffeeItem.Name,
coffeeItem.Description,
coffeeItem.CaffeineContent
});
return(result.Single());
}
}
public async Task <IActionResult> CreateCoffee(CoffeeItemDto coffeeItem)
{
return(await mediator.Send(new CreateCoffeeCommand(coffeeItem)));
}
public CreateCoffeeCommand(CoffeeItemDto coffeeItem)
{
this.CoffeeItem = coffeeItem;
}
