//Edit supplier of product private void btnEditProductSupplier_Click(object sender, EventArgs e) { frmAddEditProductSuppliers addProductSupplierForm = new frmAddEditProductSuppliers(); addProductSupplierForm.addProductSupplier = false; using (TravelExpertDBDataContext db = new TravelExpertDBDataContext()) { // Index of the current row var prodsupid = (from m in db.Products_Suppliers join p in db.Products on m.ProductId equals p.ProductId where p.ProdName == products_SupplierDataGridView.SelectedRows.ToString() select p); var prods = (from m in db.Products_Suppliers join p in db.Suppliers on m.SupplierId equals p.SupplierId where p.SupName == products_SupplierDataGridView.SelectedRows.ToString() select p); int prodsuprowNum = Convert.ToInt32(products_SupplierDataGridView.CurrentCell.RowIndex); // Column for productsupplier Id int prosupordernum = Convert.ToInt32(products_SupplierDataGridView["dataGridViewTextBoxColumn8", prodsuprowNum].Value); addProductSupplierForm.cur = (from p in db.Products_Suppliers where p.ProductId == Convert.ToInt32(prodsupid) && p.SupplierId == Convert.ToInt32(prods) select p).Single(); } // Display second form model DialogResult result = addProductSupplierForm.ShowDialog(); using (TravelExpertDBDataContext db = new TravelExpertDBDataContext()) { // Update is successful if (result == DialogResult.OK) { // Refresh grid products_SupplierDataGridView.DataSource = db.Products_Suppliers; MessageBox.Show("Supplier Name Edited in Product Successfully"); } } }
//Add Supplier to product private void btnAddProductSupplier_Click(object sender, EventArgs e) { frmAddEditProductSuppliers addProductSupplierForm = new frmAddEditProductSuppliers(); addProductSupplierForm.addProductSupplier = true; // Display second form model DialogResult result = addProductSupplierForm.ShowDialog(); using (TravelExpertDBDataContext db = new TravelExpertDBDataContext()) { // Update is successful if (result == DialogResult.OK) { // Refresh grid Products_Supplier prosu = null; prosu = new Products_Supplier(); var prodsup = from ps in db.Products_Suppliers join sup in db.Suppliers on ps.SupplierId equals sup.SupplierId join p in db.Products on ps.ProductId equals p.ProductId into dbGroup select new { ProductSupplierID = ps.ProductSupplierId, ProductId = ps.Product.ProdName, SupplierId = sup.SupName, }; products_SupplierDataGridView.DataSource = prodsup.ToList(); MessageBox.Show("New Supplier Added to Product Successfully"); } } }