Beispiel #1
0
        private void GridRowChanged(int rowindex)
        {
            DataGridViewRow    row = new DataGridViewRow();
            ProductSubcategory sub = new ProductSubcategory();
            ProductCategory    pc  = new ProductCategory();
            ProductSubcategory psc = new ProductSubcategory();

            if (rowindex < 0)
            {
                row = ProductGrid.CurrentRow;
            }
            else
            {
                row = ProductGrid.Rows[rowindex];
            }

            if (row == null)
            {
                return;
            }
            foreach (DataGridViewCell cell in row.Cells)
            {
                int index = 0;
                switch (cell.OwningColumn.Name)
                {
                case "ID":
                    lblProductID.Text = cell.Value.ToString();
                    break;

                case "Description":
                    txtDescription.Text = cell.Value.ToString();
                    break;

                case "Name":
                    txtName.Text = cell.Value.ToString();
                    break;

                case "ProductNumber":
                    txtProductNumber.Text = cell.Value.ToString();
                    break;

                case "SafetyStockLevel":
                    txtSafetyStockLevel.Text = cell.Value.ToString();
                    break;

                case "Price":
                    txtListPrice.Text = String.Format("{0:##.00}", cell.Value);
                    break;

                //  case "DaysToManufacture":
                //  txtDaysToManufacture.Text = cell.Value.ToString();
                //     break;
                case "Cost":
                    txtStandardCost.Text = String.Format("{0:##.00}", cell.Value);
                    break;

                case "Quantity":
                    txtQuantity.Text = cell.Value.ToString();
                    break;

                case "ReorderPoint":
                    txtReorderPoint.Text = cell.Value.ToString();
                    break;

                case "ProductSubcategoryID":
                    int subCatID = Int32.Parse(cell.Value.ToString());

                    sub = psc.GetProductSubcategory(subCatID);
                    int    productCategoryID = Int32.Parse(sub.ProductCategoryID.ToString());
                    string catName           = pc.GetProductCategory(productCategoryID).Name;
                    int    catIndex          = cmbCategory.FindStringExact(catName);

                    cmbCategory.SelectedIndex = catIndex;
                    LoadProductSubCategories(productCategoryID);
                    int subIndex = cmbProductSubCategories.FindStringExact(sub.Name);
                    cmbProductSubCategories.SelectedIndex = subIndex;

                    break;

                case "Active":
                    if (cell.Value != DBNull.Value)
                    {
                        chkActive.Checked = Boolean.Parse(cell.Value.ToString());
                    }
                    else
                    {
                        chkActive.Checked = false;
                    }
                    break;

                case "Category":
                    index = cmbCategory.FindString(cell.Value.ToString());
                    cmbCategory.SelectedIndex = index;
                    break;

                case "Sub Category":
                    index = cmbProductSubCategories.FindString(cell.Value.ToString());
                    cmbProductSubCategories.SelectedIndex = index;
                    break;

                case "Primary Vendor":
                    index = cmbPrimaryVendor.FindString(cell.Value.ToString());
                    cmbPrimaryVendor.SelectedIndex = index;
                    break;

                case "Sec. Vendor":
                    index = cmbSecondaryVendor.FindString(cell.Value.ToString());
                    cmbSecondaryVendor.SelectedIndex = index;
                    break;

                case "Comments":
                    if (cell.Value != DBNull.Value)
                    {
                        txtComments.Text = cell.Value.ToString();
                    }
                    else
                    {
                        txtComments.Text = "";
                    }
                    break;

                    //case "SellStartDate":
                    //    dtSellingStartsDate.Value = DateTime.Parse(cell.Value.ToString());
                    //    break;
                    //case "SellEndDate":
                    //    dtSellingEndsDate.Value = DateTime.Parse(cell.Value.ToString());
                    //    break;
                    //case "DiscontinuedDate":
                    //    dtDiscontinuedDate.Value = DateTime.Parse(cell.Value.ToString());
                    //    break;
                }
            }
            int pid = string.IsNullOrEmpty(lblProductID.Text) ? 0 : Convert.ToInt32(lblProductID.Text);

            PopulateSpecialOfferGrid(pid);
        }