public async Task <Unit> Handle(CreateMeasurementCommand request,
CancellationToken cancellationToken)
{
var user = await _userAuth.GetUser(request.Username);
if (user == null)
{
throw new RestException(HttpStatusCode.Unauthorized, new { User = "******" });
}
var createMeasurement = new IngredientMeasurements
{
Amount = request.Amount,
Description = request.Description
};
var success = await _measurementGenerator.Create(createMeasurement);
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving changes");
}
public async Task <bool> Create(IngredientMeasurements measurement)
{
string insertCommandText = @"INSERT INTO [dbo].[measurements] (measurement_amount, measurement_description)
values (@amount, @description)";
SqlParameter measurement_amount = new SqlParameter("@amount", measurement.Amount);
SqlParameter measurement_description = new SqlParameter("@description", measurement.Description);
Int32 rows = await SqlHelper.ExecuteNonQueryAsync(conStr, insertCommandText, CommandType.Text,
measurement_amount, measurement_description);
if (rows >= 1)
{
return(true);
}
return(false);
}
