コード例 #1
0
        // class to delete a prodoctsupplier from the database
        public static bool DeleteProdSup(Products_Suppliers prodsup)
        {
            SqlConnection connection      = TravelExpertsDB.GetConnection();
            string        deleteStatement = "DELETE FROM Products_Suppliers WHERE ProductSupplierId = @ProductSupplierId";
            SqlCommand    deleteCommand   = new SqlCommand(deleteStatement, connection);

            deleteCommand.Parameters.AddWithValue("@ProductSupplierId", prodsup.productsupplierid);
            try
            {
                connection.Open();
                int count = deleteCommand.ExecuteNonQuery();
                if (count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #2
0
        public static List <Products_Suppliers> GetProductsBySupplierName(string supplierName)
        {
            List <Products_Suppliers> supplier_products = new List <Products_Suppliers>();
            SqlConnection             connection        = TravelExpertsDB.GetConnection();

            string selectStatement = "SELECT ProdName, SupName " +
                                     "FROM Products prd JOIN Products_Suppliers prdSpp ON prd.ProductId=prdSpp.ProductId " +
                                     "JOIN Suppliers spp ON spp.SupplierId=prdSpp.SupplierId WHERE spp.SupName=@SupplierName";
            SqlCommand command = new SqlCommand(selectStatement, connection);

            command.Parameters.AddWithValue("@SupplierName", supplierName);

            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Products_Suppliers prodSup = new Products_Suppliers();
                    prodSup.productName = reader["ProdName"].ToString();
                    prodSup.SupName     = reader["SupName"].ToString();
                    supplier_products.Add(prodSup);
                }
                return(supplier_products);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #3
0
        // class to add a product_supplier to the database
        public static int AddProdSupp(Products_Suppliers prodSup)
        {
            SqlConnection connection = TravelExpertsDB.GetConnection();

            string     insertStatement = "INSERT INTO Products_Suppliers (ProductId, SupplierId) VALUES (@ProductId, @SupplierId)";
            SqlCommand command         = new SqlCommand(insertStatement, connection);

            command.Parameters.AddWithValue("@ProductId", prodSup.productid);
            command.Parameters.AddWithValue("@SupplierId", prodSup.supplierid);
            try
            {
                connection.Open();
                command.ExecuteNonQuery();
                string selectStatement =
                    "SELECT IDENT_CURRENT('Products_Suppliers') FROM Products_Suppliers";
                SqlCommand selectCommand =
                    new SqlCommand(selectStatement, connection);
                int Products_SuppliersID = Convert.ToInt32(selectCommand.ExecuteScalar());
                return(Products_SuppliersID);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #4
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            int index  = cboProducts.SelectedIndex;
            int prodId = productsList[index].ProductId;
            Products_Suppliers productsSuppliers = new Products_Suppliers();

            if (prodId < 1) // no selection
            {
                MessageBox.Show("Please select supplier to add");
            }
            else // user selected a product to add
            {
                try
                {
                    int ProductSupplierId = Products_SuppliersDB.AddSupplierById(prodId, (int)supId);
                    MessageBox.Show("Product deleted", "Success!");
                    this.DialogResult = DialogResult.OK;
                    Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(ProductSupplierId); // selected product
                                                                                                            //add selected product
                    currentProductSupplierIds.Add(ps);                                                      // add to current  product supplier list
                    loadData();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, ex.GetType().ToString());
                }
                //DisplayCurrentPackageProductSupplierData();
            }
        }
コード例 #5
0
        // class to return a list of all records in the table
        public static List <Products_Suppliers> GetAllProdSup()
        {
            List <Products_Suppliers> product_suppliers = new List <Products_Suppliers>();
            SqlConnection             connection        = TravelExpertsDB.GetConnection();

            string     selectStatement = "SELECT * FROM Products_Suppliers";
            SqlCommand selectCommand   = new SqlCommand(selectStatement, connection);

            try
            {
                connection.Open();
                SqlDataReader reader = selectCommand.ExecuteReader();

                while (reader.Read())
                {
                    Products_Suppliers prodsup = new Products_Suppliers();
                    prodsup.productsupplierid = (int)reader["ProductSupplierId"];
                    prodsup.productid         = (int)reader["ProductId"];
                    prodsup.supplierid        = (int)reader["SupplierId"];
                    product_suppliers.Add(prodsup);
                }

                return(product_suppliers);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #6
0
        // ADD a supplier to current product click
        private void btnAdd_Click(object sender, EventArgs e)
        {
            int index = cboSupplier.SelectedIndex;
            int supId = suppliersList[index].SupplierId;
            Products_Suppliers productsSuppliers = new Products_Suppliers();

            if (supId < 1)
            {
                MessageBox.Show("Please select supplier to add");
            }
            else
            {
                try
                {
                    int ProductSupplierId = Products_SuppliersDB.AddSupplierById((int)prodId, supId);
                    MessageBox.Show("Supplier added", "Success!");
                    this.DialogResult = DialogResult.OK;
                    Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(ProductSupplierId);
                    currentProductSupplierIds.Add(ps);
                    DisplayProductSupplier();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, ex.GetType().ToString());
                }
            }
        }
コード例 #7
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (lstProdSup.SelectedIndex < 0) // no selection
            {
                MessageBox.Show("Please select product supplier to add");
            }
            else
            {
                Packages currentPackage = PackagesDB.GetPackageById((int)id);
                string   i         = lstProdSup.SelectedItem.ToString();
                string[] s         = i.Split('|');
                int      prodSupId = Int32.Parse(s[0].Trim());

                Products_Suppliers selectedProductSupplier = Products_SuppliersDB.GetProductSupplierById(prodSupId);

                try
                {
                    if (!Packages_Products_SuppliersDB.AddPackageProductSupplier(currentPackage.PackageId, selectedProductSupplier.ProductSupplierId))
                    {
                        MessageBox.Show("Product added", "Success!");
                        this.DialogResult = DialogResult.OK;
                        DisplayPackage();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, ex.GetType().ToString());
                }
            }
        }
コード例 #8
0
        // DELETE a supplier to current product click
        private void btnRemove_Click(object sender, EventArgs e)
        {
            string i = lstSuppliers.SelectedItem.ToString();

            string[]           s                 = i.Split('|');
            int                prodSupId         = Int32.Parse(s[0].Trim());
            Products_Suppliers productsSuppliers = new Products_Suppliers();

            if (prodSupId < 1) // no selection
            {
                MessageBox.Show("Please select supplier to add");
            }
            else // user selected a product to add
            {
                try
                {
                    this.DialogResult = DialogResult.OK;
                    Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(prodSupId);
                    Products_SuppliersDB.DeleteProductSupplier(ps);
                    MessageBox.Show("Supplier deleted", "Success!");
                    loadData();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, ex.GetType().ToString());
                }
            }
        }
コード例 #9
0
 private void DisplayProductSupplierData()
 {
     productSupplierIds = Products_SuppliersDB.GetProductSupplierIds();
     lstProdSup.Items.Clear();
     lstProdSup.Items.Add("Id " + ": " + "Product Name" + ",  " + "Supplier Name");
     foreach (int id in productSupplierIds)
     {
         Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(id);
         lstProdSup.Items.Add(ps);
     }
 }
コード例 #10
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            string tableName = cboTableNames.SelectedValue.ToString();

            if (tableName == "Products")
            {
                frmAddUpdateProducts addProductForm = new frmAddUpdateProducts();
                addProductForm.addProduct = true;
                DialogResult result = addProductForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    currentProd = addProductForm.product;
                    this.DisplayProductData();
                }
            }
            else if (tableName == "Suppliers")
            {
                frmAddUpdateSuppliers addSupplierForm = new frmAddUpdateSuppliers();
                addSupplierForm.addSupplier = true;
                DialogResult result = addSupplierForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    currentSupplier = addSupplierForm.supplier;
                    this.DisplaySupplierData();
                }
            }
            else if (tableName == "Products_Suppliers")
            {
                frmAddUpdateProductSupplier addProductSupplierForm = new frmAddUpdateProductSupplier();
                addProductSupplierForm.addProductSupplier = true;
                DialogResult result = addProductSupplierForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    currentProductSupplier = addProductSupplierForm.productSupplier;
                    this.DisplayProductSupplierData();
                }
            }
            else if (tableName == "Packages")
            {
                frmAddUpdatePackages addPackageForm = new frmAddUpdatePackages();
                addPackageForm.addPackage = true;
                DialogResult result = addPackageForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    currentPackage = addPackageForm.package;
                    this.DisplayPackages();
                    this.DisplayProductSupplierData();
                }
            }
        }
コード例 #11
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            int    index = lstPackProdSupp.SelectedIndex;
            string i     = lstPackProdSupp.SelectedItem.ToString();

            string[] s   = i.Split('|');
            int      pid = Int32.Parse(s[0].Trim());

            //Packages_Products_Suppliers currentPackage = Packages_Products_SuppliersDB.GetPackageIds

            if (pid < 1) // no selection
            {
                MessageBox.Show("Please select product supplier to delete");
            }
            else // user selected a product to delete
            {
                if (type == "View")
                {
                    Products_Suppliers pps    = Products_SuppliersDB.GetProductSupplierById(pid); // selected product
                    DialogResult       answer =
                        MessageBox.Show("Are you sure to delete " + pps.ProdName + "?",
                                        "Please Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (answer == DialogResult.Yes)
                    {
                        //delete selected package product supplier
                        try
                        {
                            if (!Packages_Products_SuppliersDB.DeletePackageProductSupplier((int)id, pps.ProductSupplierId))
                            {
                                MessageBox.Show("Another user has updated or deleted " +
                                                "that product.", "Database Error");
                            }
                            else
                            {
                                currentProductSupplierIds.RemoveAt(index - 1);
                            }
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message, ex.GetType().ToString());
                        }
                        // remove from the current  product supplier  list
                        DisplayCurrentPackageProductSupplierData();
                    }
                }
            }
        }
コード例 #12
0
 private void DisplayCurrentPackageProductSupplierData()
 {
     if (productSupplierIds != null)         // if we have product suppliers to display
     {
         lstProductSupplierId.Items.Clear(); //start with empty list box
         lstProductSupplierId.Items.Add("Id " + ": " + "Product Name" + ",  " + "Supplier Name");
         foreach (int id in productSupplierIds)
         {
             Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById(id);
             lstProductSupplierId.Items.Add(ps);
         }
     }
     else // null this product does not exist - need to refresh combo box
     {
         packageIds = Packages_Products_SuppliersDB.GetPackageIds();
     }
 }
コード例 #13
0
 // display ProductSupplier attached to package by DB method, passing through the packageID inherited from main form
 private void DisplayCurrentPackageProductSupplierData()
 {
     if (currentProductSupplierIds != null) // if we have product suppliers to display
     {
         lstPackProdSupp.Items.Clear();     //start with empty list box
         lstPackProdSupp.Items.Add("Id " + ": " + "Product Name" + ",  " + "Supplier Name");
         foreach (int id in currentProductSupplierIds)
         {
             Products_Suppliers ps = Products_SuppliersDB.GetProductSupplierById((int)id);
             lstPackProdSupp.Items.Add(ps);
         }
     }
     else
     {
         lstPackProdSupp.Items.Clear();
     }
 }
 private void btnAccept_Click(object sender, EventArgs e)
 {
     if (addProductSupplier)
     {
         productSupplier = new Products_Suppliers();
         this.PutProductSupplierData(productSupplier);
         try
         {
             productSupplier.ProductSupplierId = Products_SuppliersDB.AddProductSupplier(productSupplier);
             this.DialogResult = DialogResult.OK;
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, ex.GetType().ToString());
         }
     }
     else
     {
         Products_Suppliers newProductSupplier = new Products_Suppliers();
         newProductSupplier.ProductSupplierId = productSupplier.ProductSupplierId;
         this.PutProductSupplierData(newProductSupplier);
         try
         {
             if (!Products_SuppliersDB.UpdateProductSupplier(productSupplier, newProductSupplier))
             {
                 MessageBox.Show("Another user has updated or " +
                                 "deleted that product supplier.", "Database Error");
                 this.DialogResult = DialogResult.Retry;
             }
             else
             {
                 productSupplier   = newProductSupplier;
                 this.DialogResult = DialogResult.OK;
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message, ex.GetType().ToString());
         }
     }
 }
コード例 #15
0
        // class to get a product_supplier record
        public static Products_Suppliers GetProdSup(int productSupplierId)
        {
            // set up the connection
            SqlConnection connection = TravelExpertsDB.GetConnection();

            // sql statement
            string     selectStatement = "SELECT ProductSupplierId, ProductId, SupplierId FROM Products_Suppliers WHERE ProductSupplierId = @ProductSupplierId";
            SqlCommand command         = new SqlCommand(selectStatement, connection);

            command.Parameters.AddWithValue("@ProductSupplierId", productSupplierId);

            // use a try catch to attampt to get the data
            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
                if (reader.Read())
                {
                    Products_Suppliers prodSup = new Products_Suppliers();
                    prodSup.productsupplierid = (int)reader["ProductSupplierId"];
                    prodSup.productid         = (int)reader["ProductId"];
                    prodSup.supplierid        = (int)reader["SupplierId"];

                    return(prodSup);
                }
                else
                {
                    return(null);
                }
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #16
0
        // class to update a producxt supplier to the database
        public static bool UpdateProdSup(Products_Suppliers oldProdSup, Products_Suppliers newProdSup)
        {
            // set up connection
            SqlConnection connection = TravelExpertsDB.GetConnection();

            string updateStatement = "UPDATE Products_Suppliers SET " +
                                     "ProductId = @newProductId, SupplierId = @newSupplierId WHERE ProductSupplierId = @oldProductSupplierId";

            SqlCommand updateCommand = new SqlCommand(updateStatement, connection);

            // updateCommand.Parameters.AddWithValue("@newProductSupplierId", newProdSup.productsupplierid);
            updateCommand.Parameters.AddWithValue("@newProductId", newProdSup.productid);
            updateCommand.Parameters.AddWithValue("@newSupplierId", newProdSup.supplierid);
            updateCommand.Parameters.AddWithValue("@oldProductSupplierId", oldProdSup.productsupplierid);

            try
            {
                connection.Open();
                int count = updateCommand.ExecuteNonQuery();
                if (count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
コード例 #17
0
        // button to add a product to the supplier
        private void btnProduct_Click(object sender, EventArgs e)
        {
            if (cmbProductBName.IsPresent())
            {
                // for adding a supplier
                if (add)
                {
                    Products_Suppliers product = new Products_Suppliers();
                    product.productid   = (int)cmbProductBName.SelectedValue;
                    product.productName = cmbProductBName.Text;

                    productSuppliers.Add(product);

                    RedisplayList();
                    cmbProductBName.SelectedIndex = -1;
                }
                //for modifing a supplier
                else
                {
                    Products_Suppliers product = new Products_Suppliers();
                    product.productid   = (int)cmbProductBName.SelectedValue;
                    product.productName = cmbProductBName.Text;
                    product.supplierid  = supplier.SupplierId;
                    try
                    {
                        Products_SuppliersDB.AddProdSupp(product);
                        productSuppliers = Products_SuppliersDB.GetAllProdSupOnID(supplierContact.SupplierId);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                    RedisplayList();
                    cmbProductBName.SelectedIndex = -1;
                }
            }
        }
コード例 #18
0
        // class to return a list of all records in the table based on productid
        public static List <Products_Suppliers> GetAllProdSupOnProdID(int productid)
        {
            List <Products_Suppliers> product_suppliers = new List <Products_Suppliers>();
            SqlConnection             connection        = TravelExpertsDB.GetConnection();

            string     selectStatement = "SELECT * FROM Products_Suppliers ps join Suppliers s on ps.SupplierId = s.SupplierId  WHERE ProductId = @ProductId";
            SqlCommand selectCommand   = new SqlCommand(selectStatement, connection);

            selectCommand.Parameters.AddWithValue("@ProductId", productid);

            try
            {
                connection.Open();
                SqlDataReader reader = selectCommand.ExecuteReader();

                while (reader.Read())
                {
                    Products_Suppliers prodsup = new Products_Suppliers();
                    prodsup.productsupplierid = (int)reader["ProductSupplierId"];
                    prodsup.productid         = (int)reader["ProductId"];
                    prodsup.supplierid        = (int)reader["SupplierId"];
                    prodsup.SupName           = reader["SupName"].ToString();
                    product_suppliers.Add(prodsup);
                }

                return(product_suppliers);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }
 private void PutProductSupplierData(Products_Suppliers productSupplier)
 {
     productSupplier.ProductId  = (int)cboProdId.SelectedValue;
     productSupplier.SupplierId = (int)cboSupplierId.SelectedValue;
 }
コード例 #20
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            string tableName = cboTableNames.SelectedValue.ToString();

            if (tableName == "Products")
            {
                DialogResult result = MessageBox.Show("Delete " + currentProd.ProdName + "?",
                                                      "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    try
                    {
                        if (!ProductsDB.DeleteProduct(currentProd))
                        {
                            MessageBox.Show("Another user has updated or deleted " +
                                            "that product.", "Database Error");
                            currentProd = ProductsDB.GetProductById(currentProd.ProductId);
                            if (currentProd != null)
                            {
                                this.DisplayProductData();
                            }
                        }
                        else
                        {
                            this.DisplayProductData();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
            else if (tableName == "Suppliers")
            {
                DialogResult result = MessageBox.Show("Delete " + currentSupplier.SupName + "?",
                                                      "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    try
                    {
                        if (!SuppliersDB.DeleteSupplier(currentSupplier))
                        {
                            MessageBox.Show("Another user has updated or deleted " +
                                            "that supplier.", "Database Error");
                            currentSupplier = SuppliersDB.GetSupplierById(currentSupplier.SupplierId);
                            if (currentSupplier != null)
                            {
                                this.DisplaySupplierData();
                            }
                        }
                        else
                        {
                            this.DisplaySupplierData();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
            else if (tableName == "Products_Suppliers")
            {
                DialogResult result = MessageBox.Show("Delete Product Supplier " + currentProductSupplier.ProductSupplierId + "?",
                                                      "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    try
                    {
                        if (!Products_SuppliersDB.DeleteProductSupplier(currentProductSupplier))
                        {
                            MessageBox.Show("Another user has updated or deleted " +
                                            "that product_supplier.", "Database Error");
                            currentProductSupplier = Products_SuppliersDB.GetProductSupplierById(currentProductSupplier.ProductSupplierId);
                            if (currentProductSupplier != null)
                            {
                                this.DisplayCurrentProductSupplierData();
                            }
                            this.DisplayProductSupplierData();
                        }
                        else
                        {
                            this.DisplayCurrentProductSupplierData();
                        }
                        this.DisplayProductSupplierData();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
            else if (tableName == "Packages")
            {
                DialogResult result = MessageBox.Show("Delete Packages " + currentPackage.PkgName + "?",
                                                      "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == DialogResult.Yes)
                {
                    try
                    {
                        if (!PackagesDB.DeletePackage(currentPackage))
                        {
                            MessageBox.Show("Another user has updated or deleted " +
                                            "that package.", "Database Error");
                            currentPackage = PackagesDB.GetPackageById(currentPackage.PackageId);
                            if (currentPackage != null)
                            {
                                //this.DisplayCurrentProductSupplierData();
                                this.DisplayProductSupplierData();
                            }
                        }
                        else
                        {
                            //this.DisplayCurrentProductSupplierData();
                            this.DisplayPackages();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, ex.GetType().ToString());
                    }
                }
            }
        }
コード例 #21
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            string tableName = cboTableNames.SelectedValue.ToString();

            if (tableName == "Products")
            {
                frmAddUpdateProducts updateProductForm = new frmAddUpdateProducts();
                updateProductForm.addProduct = false;
                updateProductForm.product    = currentProd;
                DialogResult result = updateProductForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    currentProd = updateProductForm.product;
                    this.DisplayProductData();
                }
                else if (result == DialogResult.Retry)
                {
                    currentProd = ProductsDB.GetProductById(currentProd.ProductId);
                    if (currentProd != null)
                    {
                        this.DisplayProductData();
                    }
                }
            }
            else if (tableName == "Suppliers")
            {
                frmAddUpdateSuppliers updateSupplierForm = new frmAddUpdateSuppliers();
                updateSupplierForm.addSupplier = false;
                updateSupplierForm.supplier    = currentSupplier;
                DialogResult result = updateSupplierForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    currentSupplier = updateSupplierForm.supplier;
                    this.DisplaySupplierData();
                }
                else if (result == DialogResult.Retry)
                {
                    currentSupplier = SuppliersDB.GetSupplierById(currentSupplier.SupplierId);
                    if (currentSupplier != null)
                    {
                        this.DisplaySupplierData();
                    }
                }
            }
            else if (tableName == "Products_Suppliers")
            {
                frmAddUpdateProductSupplier updateProductSupplierForm = new frmAddUpdateProductSupplier();
                updateProductSupplierForm.addProductSupplier = false;
                updateProductSupplierForm.productSupplier    = currentProductSupplier;
                DialogResult result = updateProductSupplierForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    this.DisplayCurrentProductSupplierData();
                    this.DisplayProductSupplierData();
                }
                else if (result == DialogResult.Retry)
                {
                    currentProductSupplier = Products_SuppliersDB.GetProductSupplierById(currentProductSupplier.ProductSupplierId);
                    if (currentProductSupplier != null)
                    {
                        this.DisplayCurrentProductSupplierData();
                    }
                    this.DisplayProductSupplierData();
                }
            }
            else if (tableName == "Packages")
            {
                frmAddUpdatePackages updatePackageForm = new frmAddUpdatePackages();
                updatePackageForm.addPackage = false;
                updatePackageForm.package    = currentPackage;
                updatePackageForm.currentProductSupplierIds = Packages_Products_SuppliersDB.GetProductSupplierIds(currentPackage.PackageId);
                DialogResult result = updatePackageForm.ShowDialog();
                if (result == DialogResult.OK)
                {
                    this.DisplayPackages();
                    DisplayCurrentPackageProductSupplierData();
                }
                else if (result == DialogResult.Retry)
                {
                    currentPackage = PackagesDB.GetPackageById(currentPackage.PackageId);
                    if (currentPackage != null)
                    {
                        DisplayCurrentPackageProductSupplierData();
                    }
                    this.DisplayPackages();
                }
            }
        }
コード例 #22
0
 private void DisplayCurrentProductSupplierData()
 {
     currentProductSupplier = Products_SuppliersDB.GetProductSupplierById(currentProductSupplier.ProductSupplierId);
     txtName.Text           = currentProductSupplier.ProdName;
     txtName2.Text          = currentProductSupplier.SupName;
 }
コード例 #23
0
        private void cboId_SelectedIndexChanged(object sender, EventArgs e)
        {
            string tableName = cboTableNames.SelectedValue.ToString();

            if (tableName == "Products")
            {
                int selectedID = (int)cboId.SelectedValue;
                lblName.Text = "Product Name";
                try
                {
                    currentProd = ProductsDB.GetProductById(selectedID);
                    DisplayCurrentProductData();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error while retrieving product with selected ID: " + ex.Message,
                                    ex.GetType().ToString());
                }
            }
            else if (tableName == "Suppliers")
            {
                int selectedID = (int)cboId.SelectedValue;
                lblName.Text = "Supplier Name";
                try
                {
                    currentSupplier = SuppliersDB.GetSupplierById(selectedID);
                    DisplayCurrentSupplierData();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error while retrieving supplier with selected ID: " + ex.Message,
                                    ex.GetType().ToString());
                }
            }
            else if (tableName == "Products_Suppliers")
            {
                int selectedID = (int)cboId.SelectedValue;
                try
                {
                    currentProductSupplier = Products_SuppliersDB.GetProductSupplierById(selectedID);
                    DisplayCurrentProductSupplierData();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error while retrieving product supplier with selected ID: " + ex.Message,
                                    ex.GetType().ToString());
                }
            }
            else if (tableName == "Packages_Products_Suppliers")
            {
                int selectedID = (int)cboId.SelectedValue;
                try
                {
                    productSupplierIds = Packages_Products_SuppliersDB.GetProductSupplierIds(selectedID);
                    DisplayCurrentPackageProductSupplierData();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error while retrieving package product supplier with selected ID: " + ex.Message,
                                    ex.GetType().ToString());
                }
            }
            else if (tableName == "Packages")
            {
                int selectedID = (int)cboId.SelectedValue;
                lblName.Text = "Package Name";
                try
                {
                    productSupplierIds = Packages_Products_SuppliersDB.GetProductSupplierIds(selectedID);
                    DisplayCurrentPackageProductSupplierData();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error while retrieving package product supplier with selected ID: " + ex.Message,
                                    ex.GetType().ToString());
                }
                try
                {
                    currentPackage = PackagesDB.GetPackageById(selectedID);
                    txtName.Text   = currentPackage.PkgName;
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error while retrieving package with selected ID: " + ex.Message,
                                    ex.GetType().ToString());
                }
            }
        }