public IceCreamDatabaseForm()
{
InitializeComponent();
DatabaseWorker.updateStoreListBox(StoreListBox);
DatabaseWorker.updateMakersListBox(makersListBox);
DatabaseWorker.updateIceCreamListBox(IceCreamListBox);
DatabaseWorker.updateSellersListBox(sellersListBox);
DatabaseWorker.updateSellingListBox(sellingListBox);
}
private void StoreUpdateButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(StoreListBox, 0);
using (var db = new IceCreamContext())
{
var updateStore = (from store in db.IceCreamStores
where store.Address == keyText
select store).First();
string updateInfo = "update IceCreamStores set Adress='" + AddressTextBox.Text + "',WorkingHours='" + workingHoursTextBox.Text
+ "' where Adress='" + updateStore.Address + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateStoreListBox(StoreListBox);
}
}
catch (Exception ex)
{
storeErrorLabel.Text = ex.Message;
}
}
