private void sellingUpdateButton_Click(object sender, EventArgs e)
{
try
{
var id = new Guid(DatabaseWorker.getWordFromListBox(sellingListBox, 0));
string address = DatabaseWorker.getWordFromListBox(sellingListBox, 1);
string flavor = DatabaseWorker.getWordFromListBox(sellingListBox, 2);
using (var db = new IceCreamContext())
{
var updateSelling = (from selling in db.IceCreamSelling
where selling.SellingId == id
select selling).First();
var newStore = (from store in db.IceCreamStores
where store.Address == address
select store).First();
var newIceCream = (from iceCream in db.IceCreamFlavors
where iceCream.Flavor == flavor
select iceCream).First();
string updateInfo = "update IceCreamSelling set Store='" + newStore + "',IceCreamFlavor='"
+ newIceCream + "' where SellingId='" + updateSelling.SellingId + "';";
DatabaseWorker.ConnectionSQL(updateInfo);
DatabaseWorker.updateSellingListBox(sellingListBox);
}
}
catch (Exception ex)
{
sellingErrorLabel.Text = ex.Message;
}
}
public IceCreamDatabaseForm()
{
InitializeComponent();
DatabaseWorker.updateStoreListBox(StoreListBox);
DatabaseWorker.updateMakersListBox(makersListBox);
DatabaseWorker.updateIceCreamListBox(IceCreamListBox);
DatabaseWorker.updateSellersListBox(sellersListBox);
DatabaseWorker.updateSellingListBox(sellingListBox);
}
