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; }