예제 #1
0
        //populate combo boxes so there is a supplierID and product ID to choose from
        //Populate the Product list with products from the database
        //Populate the Supplier list with supplier from the database
        private void FillComboBoxes()
        {
            // return list of productID created in GetProductName()
            List <Product> myProdList = ProductsDB.GetProducts();

            // adding product names to the CBName (combo box)
            var prodLinq = from prod in myProdList
                           select new
            {
                prod.ProductId
            };

            foreach (var item in prodLinq)
            {
                cboProdID.Items.Add(item.ProductId);
            }

            // return list of supplierID names created in GetProductName()
            List <Supplier> mySupList = SuppliersDB.GetSuppliers();

            // adding package names to the CBName (combo box)
            var supLinq = from sup in mySupList
                          select new
            {
                sup.SupplierId
            };

            foreach (var item in supLinq)
            {
                cboSupID.Items.Add(item.SupplierId);
            }
        }
        private void PutSupplierData(Supplier newsupplier)
        {
            try
            {
                if (Validator1.IsProvided(txtSupId, "Supplier Id") &&
                    Validator1.IsProvided(txtSupName, "Supplier Name") &&
                    Validator1.IsNonNegativeDecimal(txtSupId, "Supplier Id"))
                {
                    supplier.SupplierId = Convert.ToInt32(txtSupId.Text);
                    supplier.SupName    = txtSupName.Text.ToString();

                    SuppliersDB.AddNewSupplier(supplier);

                    this.DialogResult = DialogResult.OK;
                    MessageBox.Show("Supplier has been saved");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString());
            }
        }
예제 #3
0
        // populate drop down with names of sup objects from the Suppliers list
        private void PopulateSuppliers()
        {
            // return list of suppliers created in GetSuppliers()
            List <Supplier> supplierList = SuppliersDB.GetSuppliers();
            //if (btnUpdateClicked)
            // {
            // adding supplier names to the CBName (combo box)
            var supplierLinq = from sup in supplierList
                               select new
            {
                sup.SupName
            };

            foreach (var item in supplierLinq)
            {
                cBName.Items.Add(item.SupName);
            }
            // }
            // else
            // {
            //// adding supplier names to the CBName (combo box)
            //var supplierLinq = from sup in supplierList
            //                   select new
            //                   {
            //                       sup.SupplierId
            //                   };

            //foreach (var item in supplierLinq)
            //{
            //    cbSupID.Items.Add(item.SupplierId);
            //}


            cbSupID.DataSource    = supplierList;
            cbSupID.DisplayMember = "SupName";
            cbSupID.ValueMember   = "SupplierId";
            //}
        }
예제 #4
0
        //Saving the Data in database
        private void btnSave_Click(object sender, EventArgs e)
        {
            bool updated = false;

            //if Supplier button is clicked
            if (btnSupClicked)
            {
                //Validating Supplier Table
                if (Validator1.IsProvidedCombo(cBName, "Supplier Name"))
                {
                    Supplier newSup = new Supplier();
                    newSup.SupName = cBName.Text;  //for new supplier name

                    updated = SuppliersDB.UpdateSupplier(newSup, SingleSup);
                    if (updated)
                    {
                        MessageBox.Show("Supplier Updated");
                    }
                    else
                    {
                        MessageBox.Show("Supplier not Updated. Please try again.");
                    }
                }
            }
            //If Products button is clicked
            if (btnProdClicked)
            {
                //Validating Product Table
                if (Validator1.IsProvidedCombo(cBName, "Product Name"))
                {
                    Product NewProd = new Product();
                    NewProd.ProdName = cBName.Text; //for new Product name

                    updated = ProductsDB.UpdateProducts(NewProd, SingleProd);
                    if (updated)
                    {
                        MessageBox.Show("Products Updated");
                    }
                    else
                    {
                        MessageBox.Show("Products not Updated. Please try again");
                    }
                }
            }
            if (btnProdSupClicked)// this does not work yet
            {
                //Validating Product-Supplier table
                if (Validator1.IsProvidedCombo(cbProdID, "Product Id") &&
                    Validator1.IsProvidedCombo(cbSupID, "Supplier Id"))
                {
                    ProdSupplier newProdSupplier = new ProdSupplier();
                    newProdSupplier.ProductId  = Convert.ToInt32(cbProdID.SelectedValue);
                    newProdSupplier.SupplierId = Convert.ToInt32(cbSupID.SelectedValue);

                    updated = ProdSuppliersDB.UpdateProdSupplier(newProdSupplier, SingleProdSup);
                    if (updated)
                    {
                        MessageBox.Show("Product_Supplier is Updated");
                    }
                    else
                    {
                        MessageBox.Show("Product_Supplier is not Updated. Please try again");
                    }
                }
            }
            if (btnPackClicked)  // Otherwise just load Packages
            {
                //Validating data for Packages
                if (Validator1.IsProvidedCombo(cBName, "Package Name") &&
                    Validator1.IsProvided(txtDesc, "Describtion") &&
                    Validator1.IsProvided(txtBasePrice, "Base Price") &&
                    Validator1.IsProvided(txtAgencyComm, "Agency Commission"))
                {
                    Package NewPackage = new Package();
                    NewPackage.PkgName = cBName.Text;

                    //Start Date cannnot be greater then End Date
                    if (dTPStartDate.Value.Date >= dTPEndDate.Value.Date)
                    {
                        MessageBox.Show("Package start date cannot be later than end date");
                    }

                    //Agency commission cannot be greater then base price
                    else if (Convert.ToDecimal(txtBasePrice.Text.Replace("$", "")) < (Convert.ToDecimal(txtAgencyComm.Text.Replace("$", ""))))
                    {
                        MessageBox.Show("Agency Comission cannot be more than Package Base price!");
                    }
                    else
                    {
                        NewPackage.PkgStartDate        = dTPStartDate.Value.ToString("yyyy-MM-dd");
                        NewPackage.PkgEndDate          = dTPEndDate.Value.ToString("yyyy-MM-dd");
                        NewPackage.PkgDesc             = txtDesc.Text;
                        NewPackage.PkgBasePrice        = Convert.ToDecimal(txtBasePrice.Text.Replace("$", ""));
                        NewPackage.PkgAgencyCommission = Convert.ToDecimal(txtAgencyComm.Text.Replace("$", ""));

                        updated = PackageDB.UpdatePackage(NewPackage, SinglePkg);
                    }

                    if (updated)
                    {
                        MessageBox.Show("Package is Updated");
                    }
                    else
                    {
                        MessageBox.Show("Package is not Updated, Please try again.");
                    }
                }
            }
        }
예제 #5
0
        // when name combo box (ddl) is used to select an object from the list
        private void cBPkgName_SelectedIndexChanged(object sender, EventArgs e)
        {
            // if the Products button was most recently clicked
            if (btnProdClicked)
            {
                // return list of packages created in GetProducts()
                List <Product> productList = ProductsDB.GetProducts();

                // display information about the selected product
                if (cBName.SelectedIndex != -1)
                {
                    var prod = (from selectedprod in productList where
                                selectedprod.ProdName == cBName.Text
                                select selectedprod).First();

                    txtID.Text = prod.ProductId.ToString();

                    //Maryam
                    SingleProd = prod;
                }
            }

            // if the Suppliers button was most recently clicked
            else if (btnSupClicked)
            {
                // return list of packages created in GetSuppliers()
                List <Supplier> supplierList = SuppliersDB.GetSuppliers();

                // if a selection is made from the combobox
                if (cBName.SelectedIndex != -1)
                {
                    // display information about the selected supplier
                    var sup = (from selectedsup in supplierList
                               where selectedsup.SupName == cBName.Text
                               select selectedsup).First();

                    txtID.Text = sup.SupplierId.ToString();

                    //Maryam
                    SingleSup            = new Supplier();
                    SingleSup.SupplierId = Convert.ToInt32(txtID.Text);
                    SingleSup.SupName    = cBName.Text;
                }
            }

            // if the Packages button was most recently clicked
            // or on form load
            else
            {
                // return list of packages created in GetPackages()
                List <Package> packageList = MainPackageDB.GetPackages();

                // if a selection is made from the combo box
                if (cBName.SelectedIndex != -1)
                {
                    // display information about the selected package
                    var pkg = (from selectedpkg in packageList where
                               selectedpkg.PkgName == cBName.Text
                               select selectedpkg).First();

                    txtID.Text         = pkg.PackageId.ToString();
                    dTPStartDate.Value = Convert.ToDateTime(pkg.PkgStartDate);
                    dTPEndDate.Value   = Convert.ToDateTime(pkg.PkgEndDate);
                    txtDesc.Text       = pkg.PkgDesc;
                    txtBasePrice.Text  = pkg.PkgBasePrice.ToString("c");
                    txtAgencyComm.Text = pkg.PkgAgencyCommission.ToString("c");

                    //Maryam
                    SinglePkg = pkg;
                }
            }
        }