public Cocktail EditCocktail(Cocktail cocktail)
{
using (var connection = new SqlConnection(Settings.GetConnectionString()))
{
var p = new DynamicParameters();
p.Add("CocktailId", cocktail.CocktailId);
p.Add("Name", cocktail.Name);
p.Add("ImgUrl", cocktail.ImgUrl);
connection.Execute("CocktailEdit", p, commandType: CommandType.StoredProcedure);
return cocktail;
}
}
public Cocktail AddCocktail(Cocktail cocktial)
{
using (var connection = new SqlConnection(Settings.GetConnectionString()))
{
var p = new DynamicParameters();
p.Add("Name", cocktial.Name);
p.Add("ImgUrl", cocktial.ImgUrl);
p.Add("CocktailId", dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("CocktailAdd", p, commandType: CommandType.StoredProcedure);
cocktial.CocktailId = p.Get<int>("CocktailId");
}
return cocktial;
}