public async void AddBean(BeanCreateDTO bean)
{
// SQL
try
{
using (var cmd = new NpgsqlCommand(
$"INSERT INTO beans(bean_name,price,aroma,colour,imageUrl) " +
$"VALUES (" +
$"'{bean.Name}', " +
$"{bean.CostPer100g}, " +
$"'{bean.Aroma}', " +
$"'{bean.Colour}', " +
$"'{bean.ImageUrl}'" +
$")", _sqlConnection))
{
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
_sqlConnection.Close();
}
}
catch (Exception ex)
{
// Post errors to a logging service
Console.WriteLine(ex.InnerException);
}
}
public async Task <ActionResult> AddBeanToDb(BeanCreateDTO bean)
{
// TODO: Add check to see if table exists before pushing into it
// Create table and push if not
_beanRepo.AddBean(bean);
// TODO: Return CreatedAtRoute to the client
// This way, the client will receive an URL to the resource they just created for validation
return(NoContent());
}
