public IceCreamDatabaseForm() { InitializeComponent(); DatabaseWorker.updateStoreListBox(StoreListBox); DatabaseWorker.updateMakersListBox(makersListBox); DatabaseWorker.updateIceCreamListBox(IceCreamListBox); DatabaseWorker.updateSellersListBox(sellersListBox); DatabaseWorker.updateSellingListBox(sellingListBox); }
private void makerUpdateButton_Click(object sender, EventArgs e) { try { string keyText = DatabaseWorker.getWordFromListBox(makersListBox, 0); using (var db = new IceCreamContext()) { var updateMaker = (from maker in db.IceCreamMakers where maker.MakersPersonalId == keyText select maker).First(); string updateInfo = "update IceCreamMakers set MakersPersonalID='" + makerIdTextBox.Text + "',FirstName='" + makerFirstNameTextBox.Text + "',LastName='" + makerLastNameTextBox.Text + "',Salary='" + MakerSalaryTextBox.Text + "',PhoneNumber='" + MakerPhoneNumberTextBox.Text + "' where makersPersonalID='" + updateMaker.MakersPersonalId + "';"; DatabaseWorker.ConnectionSQL(updateInfo); DatabaseWorker.updateMakersListBox(makersListBox); } } catch (Exception ex) { makerErrorLabel.Text = ex.Message; } }