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