private void updateIceCreamButton_Click(object sender, EventArgs e)
{
try
{
string keyText = DatabaseWorker.getWordFromListBox(IceCreamListBox, 0);
string makerId = DatabaseWorker.getWordFromListBox(IceCreamListBox, 2);
using (var db = new IceCreamContext())
{
var updateIceCream = (from iceCream in db.IceCreamFlavors
where iceCream.Flavor == keyText
select iceCream).First();
var iceCreamMaker = (from maker in db.IceCreamMakers
where maker.MakersPersonalId == makerId
select maker).First();
string updateInfo = "update IceCreamFlavors set Flavor='" + flavorTextBox.Text + "',PricePerKilo='" + pricePerKiloTextBox.Text
+ "',IceCreamMaker='" + iceCreamMaker + "' where Flavor='" + updateIceCream.Flavor + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateIceCreamListBox(IceCreamListBox);
}
}
catch (Exception ex)
{
iceCreamErrorLabel.Text = ex.Message;
}
}
public IceCreamDatabaseForm()
{
InitializeComponent();
DatabaseWorker.updateStoreListBox(StoreListBox);
DatabaseWorker.updateMakersListBox(makersListBox);
DatabaseWorker.updateIceCreamListBox(IceCreamListBox);
DatabaseWorker.updateSellersListBox(sellersListBox);
DatabaseWorker.updateSellingListBox(sellingListBox);
}
