/***************** 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);
