private void sellingUpdateButton_Click(object sender, EventArgs e) { try { var id = new Guid(DatabaseWorker.getWordFromListBox(sellingListBox, 0)); string address = DatabaseWorker.getWordFromListBox(sellingListBox, 1); string flavor = DatabaseWorker.getWordFromListBox(sellingListBox, 2); using (var db = new IceCreamContext()) { var updateSelling = (from selling in db.IceCreamSelling where selling.SellingId == id select selling).First(); var newStore = (from store in db.IceCreamStores where store.Address == address select store).First(); var newIceCream = (from iceCream in db.IceCreamFlavors where iceCream.Flavor == flavor select iceCream).First(); string updateInfo = "update IceCreamSelling set Store='" + newStore + "',IceCreamFlavor='" + newIceCream + "' where SellingId='" + updateSelling.SellingId + "';"; DatabaseWorker.ConnectionSQL(updateInfo); DatabaseWorker.updateSellingListBox(sellingListBox); } } catch (Exception ex) { sellingErrorLabel.Text = ex.Message; } }
public IceCreamDatabaseForm() { InitializeComponent(); DatabaseWorker.updateStoreListBox(StoreListBox); DatabaseWorker.updateMakersListBox(makersListBox); DatabaseWorker.updateIceCreamListBox(IceCreamListBox); DatabaseWorker.updateSellersListBox(sellersListBox); DatabaseWorker.updateSellingListBox(sellingListBox); }