public Ingredient EditIngredient(Ingredient ingredient)
{
using (var connection = new SqlConnection(Settings.GetConnectionString()))
{
var p = new DynamicParameters();
p.Add("IngredientId", ingredient.IngredientId);
p.Add("Name", ingredient.Name);
p.Add("IsLiquor", ingredient.IsLiquor);
connection.Execute("IngredientEdit", p, commandType: CommandType.StoredProcedure);
return ingredient;
}
}
public Ingredient AddIngredient(Ingredient ingredient)
{
using (var connection = new SqlConnection(Settings.GetConnectionString()))
{
var p = new DynamicParameters();
p.Add("Name", ingredient.Name);
p.Add("IsLiquor", ingredient.IsLiquor);
p.Add("IngredientId", dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("IngredientAdd", p, commandType: CommandType.StoredProcedure);
ingredient.IngredientId = p.Get<int>("IngredientId");
return ingredient;
}
}