/***************** WORKING ON ADDING PACKAGES INTO the PACKAGE ID *****/ // add products into the database and save it private void btnSave_Click(object sender, EventArgs e) { if (Validator.IsProvided(txtProdSupID, "Prod Supllier ID")) { try { Packages_Products_Supplier newProduct = null; using (TravelExpertDataContext dataContext = new TravelExpertDataContext()) { newProduct = new Packages_Products_Supplier { // PackageId = Convert.ToInt32(cboPackageId.SelectedItem), PackageId = currentPackage.PackageId, ProductSupplierId = Convert.ToInt32(txtProdSupID.Text) };// object initializer syntax dataContext.Packages_Products_Suppliers.InsertOnSubmit(newProduct); dataContext.SubmitChanges(); MessageBox.Show("Changes have been saved", "Data update"); } DialogResult = DialogResult.OK; } catch (SqlException ex) { MessageBox.Show( ex.Message, ex.GetType().ToString()); } } else // validation failed { DialogResult = DialogResult.Cancel; } }
private void detach_Packages_Products_Suppliers(Packages_Products_Supplier entity) { this.SendPropertyChanging(); entity.Products_Supplier = null; }
private void attach_Packages_Products_Suppliers(Packages_Products_Supplier entity) { this.SendPropertyChanging(); entity.Package = this; }
partial void DeletePackages_Products_Supplier(Packages_Products_Supplier instance);
partial void InsertPackages_Products_Supplier(Packages_Products_Supplier instance);