예제 #1
0
        private void btnUpdateSupplier_Click(object sender, EventArgs e)
        {
            if (Validation.IsPresent(txtSupplier, "Supplier Name", lblSuppError))
            {
                updateSupplierName(lstSupplier.SelectedItem.ToString(), txtSupplier.Text);
                gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();
                ResetPrdSupplierPage();
                ResetProductSupllierList();
                ResetSupplierList();

                List <int>    suppupdated = SuppliersDB.GetSupplierIDs();
                List <string> supplier    = new List <string>();

                foreach (var sup in suppupdated)
                {
                    supplier.Add(SuppliersDB.GetSupplier(sup).SupName);
                }
                comboSupplier.DataSource = supplier;

                List <int>    prod    = ProductsDB.GetProductID();
                List <string> product = new List <string>();

                foreach (var prd in prod)
                {
                    product.Add(ProductsDB.GetProduct(prd).ProdName);
                }
                comboProduct.DataSource = null;
                comboProduct.DataSource = product;

                txtSupplier.Text  = "";
                lblSuppError.Text = "";
            }
        }
예제 #2
0
        //PAGE LOAD
        private void TravelExpert_Load(object sender, EventArgs e)
        {
            this.FormBorderStyle = FormBorderStyle.FixedDialog;
            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;

            foreach (var pkg in pack)
            {
                lstPkg.Items.Add(pkg.PkgName);
            }

            gridProductSuppliers.DataSource = productSupplierList;

            gridProductSuppliers.Columns[0].Visible = false;

            foreach (var prd in prod)
            {
                product.Add(ProductsDB.GetProduct(prd).ProdName);
            }

            foreach (var sup in supp)
            {
                supplier.Add(SuppliersDB.GetSupplier(sup).SupName);
            }


            var distinctPrd = productSupplierList.Select(o => o.ProdName).Distinct().ToList();

            comboPrdPack.DataSource  = distinctPrd;
            comboProduct.DataSource  = product;
            comboSupplier.DataSource = supplier;

            var lstsup = new List <string>();

            foreach (var supname in productSupplierList)
            {
                if (supname.ProdName == comboPrdPack.SelectedItem.ToString())
                {
                    listSuppPkg.Items.Add(supname.SupName);
                }
            }


            gridProductSuppliers.Columns[1].HeaderText = "Product Supplier ID";
            gridProductSuppliers.Columns[2].HeaderText = "Product Name";
            gridProductSuppliers.Columns[3].HeaderText = "Supplier Name";
            gridProductSuppliers.Columns[1].Width      = 150;
            gridProductSuppliers.Columns[2].Width      = 300;
            gridProductSuppliers.Columns[3].Width      = 300;
            gridProductSuppliers.ClearSelection();

            ResetPrdSupplierPage();
            ResetProductList();
            ResetSupplierList();

            //disables the DateTimePickers, re-enabled when add or edit button clicked
            dtpPkgStrt.Enabled    = false;
            dtpPkgEndDate.Enabled = false;
        }
예제 #3
0
        // Adding Supplier to supplier table
        private void btnSaveAddSupp_Click(object sender, EventArgs e)
        {
            if (Validation.IsPresent(txtSupplier, "Supplier Name", lblSuppError))
            {
                Suppliers suppAdd = new Suppliers();


                List <int> supp         = SuppliersDB.GetSupplierIDs();
                var        newsuppindex = supp[supp.Count - 1] + 1;

                suppAdd.SupplierID = newsuppindex;

                suppAdd.SupName = txtSupplier.Text;

                SuppliersDB.AddSupplier(suppAdd);

                gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();


                List <int>    suppupdated = SuppliersDB.GetSupplierIDs();
                List <string> supplier    = new List <string>();

                foreach (var sup in suppupdated)
                {
                    supplier.Add(SuppliersDB.GetSupplier(sup).SupName);
                }

                comboSupplier.DataSource = null;
                comboSupplier.DataSource = supplier;


                List <int>    prod    = ProductsDB.GetProductID();
                List <string> product = new List <string>();

                foreach (var prd in prod)
                {
                    product.Add(ProductsDB.GetProduct(prd).ProdName);
                }

                comboProduct.DataSource = null;
                comboProduct.DataSource = product;

                ResetSupplierList();
                ResetPrdSupplierPage();
                ResetProductSupllierList();

                txtSupplier.Text  = "";
                lblSuppError.Text = "";
            }
        }
예제 #4
0
        private void saveProdSup_Click(object sender, EventArgs e)
        {
            ResetPrdSupplierPage();

            try
            {
                Products_Suppliers addPrdSupp = new Products_Suppliers();

                List <int> prod = ProductsDB.GetProductID();
                List <int> supp = SuppliersDB.GetSupplierIDs();

                foreach (var item in prod)
                {
                    if (comboProduct.SelectedItem.ToString() == ProductsDB.GetProduct(item).ProdName)
                    {
                        addPrdSupp.ProductId = item;
                    }
                }

                foreach (var item in supp)
                {
                    if (comboSupplier.SelectedItem.ToString() == SuppliersDB.GetSupplier(item).SupName)
                    {
                        addPrdSupp.SupplierId = item;
                    }
                }

                Products_SuppliersDB.AddProdSupplier(addPrdSupp);
                gridProductSuppliers.DataSource            = null;
                gridProductSuppliers.DataSource            = Products_SuppliersDB.GetProductsSuppliers();
                gridProductSuppliers.Columns[0].Visible    = false;
                gridProductSuppliers.Columns[1].HeaderText = "Product Supplier ID";
                gridProductSuppliers.Columns[2].HeaderText = "Product Name";
                gridProductSuppliers.Columns[3].HeaderText = "Supplier Name";
                gridProductSuppliers.Columns[1].Width      = 150;
                gridProductSuppliers.Columns[2].Width      = 300;
                gridProductSuppliers.Columns[3].Width      = 300;
                ResetProductList();
                ResetSupplierList();
                ResetPrdSupplierPage();
                ResetProductSupllierList();
            }

            catch
            {
                lblPckProdError.Text = "Same Product Supplier Already Exist";
            }
        }
예제 #5
0
        public void updateSupplierName(string supplierName, string updatedsupplierName)
        {
            List <int> supp = SuppliersDB.GetSupplierIDs();

            foreach (var item in supp)
            {
                if (supplierName == SuppliersDB.GetSupplier(item).SupName)
                {
                    Suppliers updatedSupplier = new Suppliers();

                    updatedSupplier.SupplierID = item;
                    updatedSupplier.SupName    = updatedsupplierName;

                    SuppliersDB.UpdateSupplier(item, updatedSupplier);
                }
            }
        }
예제 #6
0
        // Adding Product to Product list ** Need Validation of Data
        private void btnAddSaveProd_Click(object sender, EventArgs e)
        {
            if (Validation.IsPresent(txtProductName, "Product Name", lblProdsError))
            {
                Products prodAdd = new Products();

                prodAdd.ProdName = txtProductName.Text;

                List <int>    prod    = ProductsDB.GetProductID();
                List <string> product = new List <string>();

                foreach (var prd in prod)
                {
                    product.Add(ProductsDB.GetProduct(prd).ProdName);
                }
                comboProduct.DataSource = null;
                comboProduct.DataSource = product;


                List <int>    suppupdated = SuppliersDB.GetSupplierIDs();
                List <string> supplier    = new List <string>();

                foreach (var sup in suppupdated)
                {
                    supplier.Add(SuppliersDB.GetSupplier(sup).SupName);
                }

                comboSupplier.DataSource = null;
                comboSupplier.DataSource = supplier;

                ProductsDB.AddProduct(prodAdd);

                gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();
                ResetProductList();
                ResetPrdSupplierPage();
                ResetProductSupllierList();

                txtProductName.Text = "";
                lblProdsError.Text  = "";
            }
        }
예제 #7
0
        public void ResetSupplierList()
        {
            lstSupplier.Items.Clear();

            List <int> supp1 = SuppliersDB.GetSupplierIDs();

            foreach (var supItem in supp1)
            {
                lstSupplier.Items.Add(SuppliersDB.GetSupplier(supItem).SupName);
            }

            btnAddSupplier.Visible  = true;
            btnAddSupplier.Enabled  = true;
            btnEditSupplier.Visible = true;
            btnEditSupplier.Enabled = true;

            lblSupplierName.Visible   = false;
            txtSupplier.Visible       = false;
            btnSaveAddSupp.Visible    = false;
            btnUpdateSupplier.Visible = false;
            lstSupplier.Enabled       = true;
        }