public static int InsertPackagesProductSuppliers(PackagesProductSuppliers newPackagesProductSuppliers) { int yay = 0; //using package db to initialize connection DBCall.InitSQL(); using (SqlConnection conn = new SqlConnection(DBCall.builder.ConnectionString)) { string insertStatement = "INSERT INTO Packages_Products_Suppliers(PackageId, ProductSupplierId) VALUES(@PackageId, @ProductSupplierId)"; SqlCommand cmd = new SqlCommand(insertStatement, conn); //Takes values from the main page and puts into database cmd.Parameters.AddWithValue("@PackageId", newPackagesProductSuppliers.PackageId); cmd.Parameters.AddWithValue("@ProductSupplierId", newPackagesProductSuppliers.ProductSupplierId); try { conn.Open(); yay = cmd.ExecuteNonQuery(); //run DML statements } catch (SqlException ex) { throw ex; } finally { conn.Close(); } } return(yay); }
//Call the insert into packages product suppliers and add the packageId and productsupplier Id private void btnAddProduct_Click(object sender, EventArgs e) { newPackagesProductSuppliers = new PackagesProductSuppliers(); newPackagesProductSuppliers.PackageId = Convert.ToInt32(cboPackId.Text); newPackagesProductSuppliers.ProductSupplierId = Convert.ToInt32(cboSupplierList.SelectedValue); int NAY = 0; NAY = PackagesProductSuppliersDB.InsertPackagesProductSuppliers(newPackagesProductSuppliers); if (NAY == 1) { MessageBox.Show("Package and Product has been inserted"); } else { MessageBox.Show("Error. Package and product has not been inserted"); } }