private void sellerUpdateNumber_Click(object sender, EventArgs e) { try { string keyText = DatabaseWorker.getWordFromListBox(sellersListBox, 0); string work = DatabaseWorker.getWordFromListBox(sellersListBox, 4); using (var db = new IceCreamContext()) { var updateSeller = (from seller in db.IceCreamSellers where seller.PersonalId == keyText select seller).First(); var iceCreamStore = (from store in db.IceCreamStores where store.Address == work select store).First(); string updateInfo = "update IceCreamSellers set PersonalId='" + sellerPersonalIdTextBox.Text + "',FirstName='" + sellerFirstNameTextBox.Text + "',LastName='" + sellerLastNameTextBox.Text + "',Salary='" + sellerSalaryTextBox.Text + "',IceCreamStore='" + iceCreamStore + "' where Address='" + updateSeller.PersonalId + "';"; DatabaseWorker.ConnectionSQL(updateInfo); DatabaseWorker.updateSellersListBox(sellersListBox); } } catch (Exception ex) { sellerErrorLabel.Text = ex.Message; } }
public IceCreamDatabaseForm() { InitializeComponent(); DatabaseWorker.updateStoreListBox(StoreListBox); DatabaseWorker.updateMakersListBox(makersListBox); DatabaseWorker.updateIceCreamListBox(IceCreamListBox); DatabaseWorker.updateSellersListBox(sellersListBox); DatabaseWorker.updateSellingListBox(sellingListBox); }