//save new product-supplier into database private void btnProdSupplierSave_Click(object sender, EventArgs e) { if (cboProductSupplierAdd.SelectedValue != null) { ProductSupplier ps = new ProductSupplier { ProductId = currentProduct.ProductId, SupplierId = Convert.ToInt32(cboProductSupplierAdd.SelectedValue) }; int addedProdSupplierId = ProductSupplierDB.AddProductSupplier(ps); if (addedProdSupplierId != 0) { //refresh suppliers part of form SetUpFrmControls(); LoadProductSuppliers(currentProduct.ProductId); } else { MessageBox.Show("A problem occured adding this item to the database. Please try again."); } } else { MessageBox.Show("Please select a supplier from the drop-down list to add.", "Data entry error"); } }
private void btnAdd_Click(object sender, EventArgs e) { if (checkDuplicate(cmbSupplier.Text, cmbProd.Text)) { MessageBox.Show("This Product Supplier Already Exists"); cmbSupplier.Focus(); } else { ProductSupplierDB.AddProductSupplier((Product)cmbProd.SelectedItem, (Supplier)cmbSupplier.SelectedItem); refreshDataSource(); dgvProdSup.Focus(); } }
/// <summary> /// Operations for click event on Add Supplier button. /// </summary> /// @author Chi private void btnAddSupplier_Click(object sender, EventArgs e) { Supplier curSupplier; // Currently select supplier int currentSupID; // Currently select supplier's ID int currentProductID = Convert.ToInt32(txtPSProdID.Text); // Current product's ProductID int currentSupplierIndex = lstboxSuppliers.SelectedIndex; // Current index of supplier selected in list box if (currentSupplierIndex >= 0) // If user have selected an item from list box { // Set current supplier's ID to supplier selected in list box. curSupplier = filteredSuppliers[currentSupplierIndex]; currentSupID = curSupplier.SupplierId; // Verify if supplier is already added to product's suppliers list. int result = ProductSupplierDB.GetId(currentProductID, currentSupID); if (result < 0) // If supplier is not in product's supplier list. { try { // Add supplier to current product, reset/reload view for current product // and notify user that supplier was added successfully. ProductSupplierDB.AddProductSupplier(currentProductID, currentSupID); loadProductSupplierData(currentProductID - 1); MessageBox.Show("Supplier Added", "Success"); } catch (Exception ex) { // Notify user of optimistic concurrency error or DB error. MessageBox.Show("Unable to Add Supplier.\nThe Product Supplier was either removed or updated.\n\n" + ex.Message, "Unexpected Database Error"); } } else { MessageBox.Show("That supplier is already added to the product", "Failed"); } } else { MessageBox.Show("Please choose a supplier.", "No supplier selected"); } }
/// <summary> /// Jorge: Save new prod sup data based on add or modify /// </summary> private void ProdSupplierSaveButton_Click(object sender, EventArgs e) { if (addProductSupplier) { this.PutProdSupplierData(); try { productSupplier.ProductSupplierId = ProductSupplierDB.AddProductSupplier(productSupplier); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } else // this is Modify { productSupplier.ProductId = currentProdSup.ProductId; productSupplier.SupplierId = currentProdSup.SupplierId; productSupplier.ProductSupplierId = currentProdSup.ProductSupplierId; this.PutProdSupplierData(); try // try to update { if (!ProductSupplierDB.UpdateProductSupplier(currentProdSup, productSupplier)) // failed { MessageBox.Show("Another user has updated or deleted current product supplier", "Concurrency Error"); this.DialogResult = DialogResult.Retry; } else { currentProdSup = ProductSupplierDB.GetProductSupplier(productSupplier.ProductSupplierId); Console.WriteLine(currentProdSup.ProdName); this.DialogResult = DialogResult.OK; } } catch (Exception ex) { MessageBox.Show("Error while updating: " + ex.Message, ex.GetType().ToString()); } } }