// Method to update a whiskey to the databased with a given object
public void updateWhiskey(Whiskey whiskey)
{
SqlConnection con = databaseConnect();
SqlCommand cmd = new SqlCommand("UPDATE Whiskeys SET name = @name, age = @age, categoryId = @categoryId," +
"currentMarketValue = @currentMarketValue, purchasePrice = @purchasePrice, description = @description, " +
"brandId = @brandId, alcoholPercentage = @alcoholPercentage, sealed = @sealed, baseingredient = @baseingredient WHERE whiskeyId = @ID", con);
cmd.Parameters.AddWithValue("@ID", whiskey.getId());
cmd.Parameters.AddWithValue("@name", whiskey.getName());
cmd.Parameters.AddWithValue("@age", whiskey.getAge());
cmd.Parameters.AddWithValue("@categoryId", whiskey.getCategoryId());
cmd.Parameters.AddWithValue("@currentMarketValue", whiskey.getCurrentMarketValue());
cmd.Parameters.AddWithValue("@purchasePrice", whiskey.getPurchasePrice());
cmd.Parameters.AddWithValue("@description", whiskey.getDescription());
cmd.Parameters.AddWithValue("@brandId", whiskey.getBrandId());
cmd.Parameters.AddWithValue("@alcoholPercentage", whiskey.getAlcoholPercentage());
cmd.Parameters.AddWithValue("@sealed", whiskey.getIsSealed());
cmd.Parameters.AddWithValue("@baseingredient", whiskey.getBaseIngredient());
cmd.ExecuteNonQuery();
con.Close();
}
// Method to add a whiskey to the databased with a given object
public void addWhiskey(Whiskey whiskey)
{
SqlConnection con = databaseConnect();
SqlCommand cmd = new SqlCommand("insert into Whiskeys(name,age,categoryId,currentMarketValue," +
"purchasePrice,description,brandId,alcoholPercentage,sealed,baseIngredient,collectionId) values (@name," +
"@age,@categoryId,@currentMarketValue,@purchasePrice,@description,@brandId,@alcoholPercentage," +
"@sealed,@baseingredient,@collectionId)", con);
cmd.Parameters.AddWithValue("@name", whiskey.getName());
cmd.Parameters.AddWithValue("@age", whiskey.getAge());
cmd.Parameters.AddWithValue("@categoryId", whiskey.getCategoryId());
cmd.Parameters.AddWithValue("@currentMarketValue", whiskey.getCurrentMarketValue());
cmd.Parameters.AddWithValue("@purchasePrice", whiskey.getPurchasePrice());
cmd.Parameters.AddWithValue("@description", whiskey.getDescription());
cmd.Parameters.AddWithValue("@brandId", whiskey.getBrandId());
cmd.Parameters.AddWithValue("@alcoholPercentage", whiskey.getAlcoholPercentage());
cmd.Parameters.AddWithValue("@sealed", whiskey.getIsSealed());
cmd.Parameters.AddWithValue("@baseingredient", whiskey.getBaseIngredient());
cmd.Parameters.AddWithValue("@collectionId", whiskey.getCollectionId());
cmd.ExecuteNonQuery();
con.Close();
}
