private void updateIceCreamButton_Click(object sender, EventArgs e) { try { string keyText = DatabaseWorker.getWordFromListBox(IceCreamListBox, 0); string makerId = DatabaseWorker.getWordFromListBox(IceCreamListBox, 2); using (var db = new IceCreamContext()) { var updateIceCream = (from iceCream in db.IceCreamFlavors where iceCream.Flavor == keyText select iceCream).First(); var iceCreamMaker = (from maker in db.IceCreamMakers where maker.MakersPersonalId == makerId select maker).First(); string updateInfo = "update IceCreamFlavors set Flavor='" + flavorTextBox.Text + "',PricePerKilo='" + pricePerKiloTextBox.Text + "',IceCreamMaker='" + iceCreamMaker + "' where Flavor='" + updateIceCream.Flavor + "';"; DatabaseWorker.ConnectionSQL(updateInfo); DatabaseWorker.updateIceCreamListBox(IceCreamListBox); } } catch (Exception ex) { iceCreamErrorLabel.Text = ex.Message; } }
public IceCreamDatabaseForm() { InitializeComponent(); DatabaseWorker.updateStoreListBox(StoreListBox); DatabaseWorker.updateMakersListBox(makersListBox); DatabaseWorker.updateIceCreamListBox(IceCreamListBox); DatabaseWorker.updateSellersListBox(sellersListBox); DatabaseWorker.updateSellingListBox(sellingListBox); }