private void sellingInsertButton_Click(object sender, EventArgs e) { try { using (var db = new IceCreamContext()) { string storeAddress = iceCreamStoreTextBox.Text; string flavor = iceCreamTextBox.Text; var store = (from iceCreamStore in db.IceCreamStores where iceCreamStore.Address == storeAddress select iceCreamStore).First(); var iceCreamFlavor = (from iceCream in db.IceCreamFlavors where iceCream.Flavor == flavor select iceCream).First(); Selling selling = new Selling { SellingId = Guid.NewGuid(), Store = store, IceCreamFlavour = iceCreamFlavor }; db.IceCreamSelling.Add(selling); db.SaveChanges(); sellingListBox.Items.Add(selling.ToString()); } } catch (Exception ex) { sellingErrorLabel.Text = ex.Message; } }
private void insertIceCreamButton_Click(object sender, EventArgs e) { try { using (var db = new IceCreamContext()) { string flavor = flavorTextBox.Text; double price = Convert.ToDouble(pricePerKiloTextBox.Text); string makerId = MakerTextBox.Text; var maker = (from iceCreamMaker in db.IceCreamMakers where iceCreamMaker.MakersPersonalId == makerId select iceCreamMaker).First(); IceCream iceCream = new IceCream { Flavor = flavor, PricePerKilo = price, Maker = maker }; db.IceCreamFlavors.Add(iceCream); db.SaveChanges(); IceCreamListBox.Items.Add(iceCream.ToString()); } } catch (Exception ex) { iceCreamErrorLabel.Text = ex.Message; } }
private void sellerInsertButton_Click(object sender, EventArgs e) { try { using (var db = new IceCreamContext()) { string id = sellerPersonalIdTextBox.Text; string firstName = sellerFirstNameTextBox.Text; string lastName = sellerLastNameTextBox.Text; float salary = (float)Convert.ToDouble(sellerSalaryTextBox.Text); string work = sellerWorkPlaceTextBox.Text; var store = (from iceCreamStore in db.IceCreamStores where iceCreamStore.Address == work select iceCreamStore).First(); Seller seller = new Seller { PersonalId = id, FirstName = firstName, LastName = lastName, Salary = salary, Store = store }; db.IceCreamSellers.Add(seller); db.SaveChanges(); sellersListBox.Items.Add(seller.ToString()); } } catch (Exception ex) { sellerErrorLabel.Text = ex.Message; } }
private void makerInsertButton_Click(object sender, EventArgs e) { try { using (var db = new IceCreamContext()) { string id = makerIdTextBox.Text; string firstName = makerFirstNameTextBox.Text; string lastName = makerLastNameTextBox.Text; float salary = (float)Convert.ToDouble(MakerSalaryTextBox.Text); string number = MakerPhoneNumberTextBox.Text; IceCreamMaker iceCreamMaker = new IceCreamMaker { MakersPersonalId = id, FirstName = firstName, LastName = lastName, Salary = salary, PhoneNumber = number }; db.IceCreamMakers.Add(iceCreamMaker); db.SaveChanges(); makersListBox.Items.Add(iceCreamMaker.ToString()); } } catch (Exception ex) { iceCreamMakerErrorLabel.Text = ex.Message; } }
private void StoreDeleteButton_Click(object sender, EventArgs e) { try { string keyText = DatabaseWorker.getWordFromListBox(StoreListBox, 0); using (var db = new IceCreamContext()) { var deleteStore = (from store in db.IceCreamStores where store.Address == keyText select store).First(); db.IceCreamStores.Remove(deleteStore); db.SaveChanges(); StoreListBox.Items.Remove(StoreListBox.SelectedItem); } } catch (Exception ex) { storeErrorLabel.Text = ex.Message; } }
private void storeInsertButton_Click(object sender, EventArgs e) { try { using (var db = new IceCreamContext()) { string address = AddressTextBox.Text; string workingHours = workingHoursTextBox.Text; IceCreamStore store = new IceCreamStore { Address = address, WorkingHours = workingHours }; db.IceCreamStores.Add(store); db.SaveChanges(); ////StoreListBox.Items.Add(store); } } catch (Exception ex) { storeErrorLabel.Text = ex.Message; } }
private void sellingDeleteButton_Click(object sender, EventArgs e) { try { var id = new Guid(DatabaseWorker.getWordFromListBox(sellingListBox, 0)); using (var db = new IceCreamContext()) { var deleteSelling = (from selling in db.IceCreamSelling where selling.SellingId == id select selling).First(); db.IceCreamSelling.Remove(deleteSelling); db.SaveChanges(); sellingListBox.Items.Remove(sellingListBox.SelectedItem); } } catch (Exception ex) { sellingErrorLabel.Text = ex.Message; } }
private void sellerDeleteButton_Click(object sender, EventArgs e) { try { string keyText = DatabaseWorker.getWordFromListBox(sellersListBox, 0); using (var db = new IceCreamContext()) { var deleteSeller = (from seller in db.IceCreamSellers where seller.PersonalId == keyText select seller).First(); db.IceCreamSellers.Remove(deleteSeller); db.SaveChanges(); sellersListBox.Items.Remove(sellersListBox.SelectedItem); } } catch (Exception ex) { sellerErrorLabel.Text = ex.Message; } }
private void deleteIceCreamButton_Click(object sender, EventArgs e) { try { string keyText = DatabaseWorker.getWordFromListBox(IceCreamListBox, 0); using (var db = new IceCreamContext()) { var deleteIceCream = (from iceCream in db.IceCreamFlavors where iceCream.Flavor == keyText select iceCream).First(); db.IceCreamFlavors.Remove(deleteIceCream); db.SaveChanges(); IceCreamListBox.Items.Remove(IceCreamListBox.SelectedItem); } } catch (Exception ex) { iceCreamErrorLabel.Text = ex.Message; } }