// 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(); }