示例#1
0
        private bool IsValid()
        {
            bool result = true;

            #region Class Code 唔可以吉
            errorProvider.SetError(txtCode, string.Empty);
            if (txtCode.Text.Length == 0)
            {
                errorProvider.SetError(txtCode, "Cannot be blank!");
                return(false);
            }
            #endregion

            #region 新增,要 check Class Code 係咪 in use
            errorProvider.SetError(txtCode, string.Empty);
            var isClassCodeInUse = _ClassMode == ProductHelper.Classes.Class1 ?
                                   ProductClass1Ex.IsClassCodeInUse(txtCode.Text.Trim()) : _ClassMode == ProductHelper.Classes.Class2 ?
                                   ProductClass2Ex.IsClassCodeInUse(txtCode.Text.Trim()) : _ClassMode == ProductHelper.Classes.Class3 ?
                                   ProductClass3Ex.IsClassCodeInUse(txtCode.Text.Trim()) : _ClassMode == ProductHelper.Classes.Class4 ?
                                   ProductClass4Ex.IsClassCodeInUse(txtCode.Text.Trim()) : _ClassMode == ProductHelper.Classes.Class5 ?
                                   ProductClass5Ex.IsClassCodeInUse(txtCode.Text.Trim()) : _ClassMode == ProductHelper.Classes.Class6 ?
                                   ProductClass6Ex.IsClassCodeInUse(txtCode.Text.Trim()) : false;
            if (_ClassId == Guid.Empty && isClassCodeInUse)
            {
                errorProvider.SetError(txtCode, "Class Code in use");
                return(false);
            }
            #endregion

            return(result);
        }
示例#2
0
        private void Delete()
        {
            bool result = false;

            switch (_ClassType)
            {
            case ProductHelper.Classes.Class1:
                result = ProductClass1Ex.Delete(_ClassId);
                break;

            case ProductHelper.Classes.Class2:
                result = ProductClass2Ex.Delete(_ClassId);
                break;

            case ProductHelper.Classes.Class3:
                result = ProductClass3Ex.Delete(_ClassId);
                break;

            case ProductHelper.Classes.Class4:
                result = ProductClass4Ex.Delete(_ClassId);
                break;

            case ProductHelper.Classes.Class5:
                result = ProductClass5Ex.Delete(_ClassId);
                break;

            case ProductHelper.Classes.Class6:
                result = ProductClass6Ex.Delete(_ClassId);
                break;
            }
            MessageBox.Show(result ? "Record Removed" : "Can't Delete Record...", "Delete Result");
        }
        private void FillClass6()
        {
            ProductClass6Ex.LoadCombo(ref cboClass6, "Class6Code", false, true, "", "");

            /**
             * cboClass6.Items.Clear();
             *
             * string[] orderBy = new string[] { "Class6Code" };
             * ProductClass6Collection oC6List = ProductClass6.LoadCollection(orderBy, true);
             * oC6List.Add(new ProductClass6());
             * cboClass6.DataSource = oC6List;
             * cboClass6.DisplayMember = "Class6Code";
             * cboClass6.ValueMember = "Class6Id";
             */
        }
示例#4
0
        private void FillFromClass6List()
        {
            ProductClass6Ex.LoadCombo(ref cboClass6_From, "Class6Code", false, true, "", "");

            /**
             * cboClass6_From.Items.Clear();
             *
             * string[] orderBy = new string[] { "Class6Code" };
             * ProductClass6Collection prodCls6List = ProductClass6.LoadCollection(orderBy, true);
             * prodCls6List.Add(new ProductClass6());
             * cboClass6_From.DataSource = prodCls6List;
             * cboClass6_From.DisplayMember = "Class6Code";
             * cboClass6_From.ValueMember = "Class6Id";
             */
            cboClass6_From.SelectedIndex = cboClass6_From.Items.Count - 1;
        }
 private void FillClasses()
 {
     /**
      * FillClass1();
      * FillClass2();
      * FillClass3();
      * FillClass4();
      * FillClass5();
      * FillClass6();
      */
     ProductClass1Ex.LoadCombo(ref cboClass1, "Class1Code", false, true, "", "");
     ProductClass2Ex.LoadCombo(ref cboClass2, "Class2Code", false, true, "", "");
     ProductClass3Ex.LoadCombo(ref cboClass3, "Class3Code", false, true, "", "");
     ProductClass4Ex.LoadCombo(ref cboClass4, "Class4Code", false, true, "", "");
     ProductClass5Ex.LoadCombo(ref cboClass5, "Class5Code", false, true, "", "");
     ProductClass6Ex.LoadCombo(ref cboClass6, "Class6Code", false, true, "", "");
 }
示例#6
0
        private void FillComboBox()
        {
            string fieldText = this.ClassType.Trim() + "Code";

            switch (this.ClassType.Trim().ToUpper())
            {
            case "CLASS1":
                ProductClass1Ex.LoadCombo(ref cmbFrom, fieldText, false);
                ProductClass1Ex.LoadCombo(ref cmbTo, fieldText, false);
                break;

            case "CLASS2":
                ProductClass2Ex.LoadCombo(ref cmbFrom, fieldText, false);
                ProductClass2Ex.LoadCombo(ref cmbTo, fieldText, false);
                break;

            case "CLASS3":
                ProductClass3Ex.LoadCombo(ref cmbFrom, fieldText, false);
                ProductClass3Ex.LoadCombo(ref cmbTo, fieldText, false);
                break;

            case "CLASS4":
                ProductClass4Ex.LoadCombo(ref cmbFrom, fieldText, false);
                ProductClass4Ex.LoadCombo(ref cmbTo, fieldText, false);
                break;

            case "CLASS5":
                ProductClass5Ex.LoadCombo(ref cmbFrom, fieldText, false);
                ProductClass5Ex.LoadCombo(ref cmbTo, fieldText, false);
                break;

            case "CLASS6":
                ProductClass6Ex.LoadCombo(ref cmbFrom, fieldText, false);
                ProductClass6Ex.LoadCombo(ref cmbTo, fieldText, false);
                break;
            }

            cmbTo.SelectedIndex = cmbTo.Items.Count - 1;
        }
示例#7
0
        // Verify the data from excel file exists or not
        private string VerifyDuplicatedData(int iCount, DataRow row)
        {
            iCount = iCount + 1;
            StringBuilder returnResult   = new StringBuilder();
            StringBuilder verifiedResult = new StringBuilder();

            verifiedResult.Append("Row#").Append(iCount.ToString()).Append(":");

            int iLen = verifiedResult.ToString().Length;

            // Check whether the StockCode is duplicate or not
            //string sql = @"STKCODE = '" + Utility.VerifyQuotes(row[colSTKCode].ToString().Trim()) + "' AND APPENDIX1 = '" + Utility.VerifyQuotes(row[colAppendix1].ToString().Trim())
            //    + "' AND APPENDIX2 = '" + Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()) + "' AND APPENDIX3 = '" + Utility.VerifyQuotes(row[colAppendix3].ToString().Trim()) + "'";

            //RT2020.DAL.Product oStockItem = RT2020.DAL.Product.LoadWhere(sql);
            //if (oStockItem != null)
            if (ProductHelper.IsDuplicated(
                    Utility.VerifyQuotes(row[colSTKCode].ToString().Trim()),
                    Utility.VerifyQuotes(row[colAppendix1].ToString().Trim()),
                    Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()),
                    Utility.VerifyQuotes(row[colAppendix3].ToString().Trim())))
            {
                returnResult.Append("Duplicated Stock Code;");
            }

            // Appendix1
            //sql = "Appendix1Code = '" + Utility.VerifyQuotes(row[colAppendix1].ToString().Trim()) + "'";
            //ProductAppendix1 oApp1 = ProductAppendix1.LoadWhere(sql);
            //if (oApp1 != null)
            if (ProductAppendix1Ex.IsAppendixCodeInUse(Utility.VerifyQuotes(row[colAppendix3].ToString())))
            {
                verifiedResult.Append(colAppendix1).Append(";");
            }

            // Appendix2
            //sql = "Appednix2Code = '" + Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()) + "'";
            //ProductAppendix2 oApp2 = ProductAppendix2.LoadWhere(sql);
            //if (oApp2 != null)
            if (ProductAppendix2Ex.IsAppendixCodeInUse(Utility.VerifyQuotes(row[colAppendix3].ToString())))
            {
                verifiedResult.Append(colAppendix2).Append(";");
            }

            // Appendix3
            //sql = "Appendix3Code = '" + Utility.VerifyQuotes(row[colAppendix3].ToString().Trim()) + "'";
            //ProductAppendix3 oApp3 = ProductAppendix3.LoadWhere(sql);
            //if (oApp3 != null)
            if (ProductAppendix3Ex.IsAppendixCodeInUse(Utility.VerifyQuotes(row[colAppendix3].ToString())))
            {
                verifiedResult.Append(colAppendix3).Append(";");
            }

            // Class1
            //sql = "Class1Code = '" + Utility.VerifyQuotes(row[colClass1].ToString().Trim()) + "'";
            //ProductClass1 oCls1 = ProductClass1.LoadWhere(sql);
            //if (oCls1 != null)
            if (ProductClass1Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass1].ToString().Trim())))
            {
                verifiedResult.Append(colClass1).Append(";");
            }

            // Class2
            //sql = "Class2Code = '" + Utility.VerifyQuotes(row[colClass2].ToString().Trim()) + "'";
            //ProductClass2 oCls2 = ProductClass2.LoadWhere(sql);
            //if (oCls2 != null)
            if (ProductClass2Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass2].ToString().Trim())))
            {
                verifiedResult.Append(colClass2).Append(";");
            }

            // Class3
            //sql = "Class3Code = '" + Utility.VerifyQuotes(row[colClass3].ToString().Trim()) + "'";
            //ProductClass3 oCls3 = ProductClass3.LoadWhere(sql);
            //if (oCls3 != null)
            if (ProductClass3Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass3].ToString().Trim())))
            {
                verifiedResult.Append(colClass3).Append(";");
            }

            // Class4
            //sql = "Class4Code = '" + Utility.VerifyQuotes(row[colClass4].ToString().Trim()) + "'";
            //ProductClass4 oCls4 = ProductClass4.LoadWhere(sql);
            //if (oCls4 != null)
            if (ProductClass4Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass4].ToString().Trim())))
            {
                verifiedResult.Append(colClass4).Append(";");
            }

            // Class5
            //sql = "Class5Code = '" + Utility.VerifyQuotes(row[colClass5].ToString().Trim()) + "'";
            //ProductClass5 oCls5 = ProductClass5.LoadWhere(sql);
            //if (oCls5 != null)
            if (ProductClass5Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass5].ToString().Trim())))
            {
                verifiedResult.Append(colClass5).Append(";");
            }

            // Class6
            //sql = "Class6Code = '" + Utility.VerifyQuotes(row[colClass6].ToString().Trim()) + "'";
            //ProductClass6 oCls6 = ProductClass6.LoadWhere(sql);
            //if (oCls6 != null)
            if (ProductClass6Ex.IsClassCodeInUse(Utility.VerifyQuotes(row[colClass6].ToString().Trim())))
            {
                verifiedResult.Append(colClass6).Append(";");
            }

            // Barcode
            var barcode = Utility.VerifyQuotes(row[colSTKCode].ToString().Trim()) + Utility.VerifyQuotes(row[colAppendix1].ToString().Trim()) + Utility.VerifyQuotes(row[colAppendix2].ToString().Trim()) + Utility.VerifyQuotes(row[colAppendix3].ToString().Trim());
            var sql     = "BARCODE = '" + barcode + "'";

            if (ProductBarcodeEx.IsBarcodeInUse(barcode))
            {
                returnResult.Append("Duplicated Barcode;");
            }

            if (verifiedResult.ToString().Length > iLen)
            {
                duplicatedRec.Add(verifiedResult.ToString());
            }

            return(returnResult.ToString());
        }
示例#8
0
        private void CreateProducts(ListViewItem listItem)
        {
            using (var ctx = new EF6.RT2020Entities())
            {
                // Check BatchId(listItem.SubItems[1].Text) and Stock Code(listItem.SubItems[2].Text)
                Guid batchId = Guid.Empty;
                if (IsValid() && Guid.TryParse(listItem.SubItems[1].Text, out batchId) && listItem.SubItems[2].Text.Length > 0)
                {
                    var oBatch = ctx.ProductBatch.Find(batchId);
                    if (oBatch != null)
                    {
                        string a1 = listItem.SubItems[3].Text.Trim();
                        string a2 = listItem.SubItems[4].Text.Trim();
                        string a3 = listItem.SubItems[5].Text.Trim();

                        Guid a1Id = Guid.Empty, a2Id = Guid.Empty, a3Id = Guid.Empty;
                        Guid.TryParse(listItem.SubItems[6].Text, out a1Id);
                        Guid.TryParse(listItem.SubItems[7].Text, out a2Id);
                        Guid.TryParse(listItem.SubItems[8].Text, out a3Id);

                        string prodCode = listItem.SubItems[2].Text + a1 + a2 + a3;
                        if (prodCode.Length <= 22)
                        {
                            var stkcode = listItem.SubItems[2].Text.Trim();

                            StringBuilder sql = new StringBuilder();
                            sql.Append(" STKCODE = '").Append(listItem.SubItems[2].Text.Trim()).Append("' ");
                            sql.Append(" AND APPENDIX1 = '").Append(a1.Trim()).Append("' ");
                            sql.Append(" AND APPENDIX2 = '").Append(a2.Trim()).Append("' ");
                            sql.Append(" AND APPENDIX3 = '").Append(a3.Trim()).Append("' ");

                            var oItem = ctx.Product.Where(x => x.STKCODE == stkcode && x.APPENDIX1 == a1 && x.APPENDIX2 == a2 && x.APPENDIX3 == a3).FirstOrDefault();
                            if (oItem == null)
                            {
                                #region add new Product
                                oItem           = new EF6.Product();
                                oItem.ProductId = Guid.NewGuid();
                                oItem.STKCODE   = listItem.SubItems[2].Text;
                                oItem.APPENDIX1 = a1;
                                oItem.APPENDIX2 = a2;
                                oItem.APPENDIX3 = a3;

                                oItem.Status = Convert.ToInt32(EnumHelper.Status.Active.ToString("d"));

                                oItem.CLASS1 = oBatch.CLASS1;
                                oItem.CLASS2 = oBatch.CLASS2;
                                oItem.CLASS3 = oBatch.CLASS3;
                                oItem.CLASS4 = oBatch.CLASS4;
                                oItem.CLASS5 = oBatch.CLASS5;
                                oItem.CLASS6 = oBatch.CLASS6;

                                oItem.ProductName     = oBatch.Description;
                                oItem.ProductName_Chs = oBatch.Description;
                                oItem.ProductName_Cht = oBatch.Description;
                                oItem.Remarks         = oBatch.REMARKS;

                                oItem.NormalDiscount = oBatch.NRDISC.Value;
                                oItem.UOM            = oBatch.MAINUNIT;
                                oItem.NatureId       = ProductNatureEx.GetIdByCode(oBatch.NATURE);

                                oItem.FixedPriceItem = false;

                                oItem.CreatedBy  = ConfigHelper.CurrentUserId;
                                oItem.CreatedOn  = DateTime.Now;
                                oItem.ModifiedBy = ConfigHelper.CurrentUserId;
                                oItem.ModifiedOn = DateTime.Now;

                                ctx.Product.Add(oItem);

                                var productId = oItem.ProductId;
                                #endregion

                                #region SaveProductBarcode(oBatch, productId, prodCode);
                                var oBarcode = ctx.ProductBarcode.Where(x => x.ProductId == productId).FirstOrDefault();
                                if (oBarcode == null)
                                {
                                    oBarcode = new EF6.ProductBarcode();
                                    oBarcode.ProductBarcodeId  = Guid.NewGuid();
                                    oBarcode.ProductId         = productId;
                                    oBarcode.Barcode           = prodCode;
                                    oBarcode.BarcodeType       = "INTER";
                                    oBarcode.PrimaryBarcode    = true;
                                    oBarcode.DownloadToPOS     = (oBatch.RETAILITEM == "F") ? false : true;
                                    oBarcode.DownloadToCounter = (oBatch.COUNTER_ITEM == "F") ? false : true;

                                    ctx.ProductBarcode.Add(oBarcode);
                                    ctx.SaveChanges();
                                }
                                #endregion

                                #region Appendix / Class
                                System.Guid c1Id = ProductClass1Ex.GetClassIdByCode(oBatch.CLASS1);
                                System.Guid c2Id = ProductClass2Ex.GetClassIdByCode(oBatch.CLASS2);
                                System.Guid c3Id = ProductClass3Ex.GetClassIdByCode(oBatch.CLASS3);
                                System.Guid c4Id = ProductClass4Ex.GetClassIdByCode(oBatch.CLASS4);
                                System.Guid c5Id = ProductClass5Ex.GetClassIdByCode(oBatch.CLASS5);
                                System.Guid c6Id = ProductClass6Ex.GetClassIdByCode(oBatch.CLASS6);
                                // SaveProductCode(productId, a1Id, a2Id, a3Id, c1Id, c2Id, c3Id, c4Id, c5Id, c6Id);
                                var oCode = ctx.ProductCode.Where(x => x.ProductId == productId).FirstOrDefault();
                                if (oCode == null)
                                {
                                    oCode             = new EF6.ProductCode();
                                    oCode.CodeId      = Guid.NewGuid();
                                    oCode.ProductId   = productId;
                                    oCode.Appendix1Id = a1Id;
                                    oCode.Appendix2Id = a2Id;
                                    oCode.Appendix3Id = a3Id;

                                    ctx.ProductCode.Add(oCode);
                                }
                                oCode.Class1Id = c1Id;
                                oCode.Class2Id = c2Id;
                                oCode.Class3Id = c3Id;
                                oCode.Class4Id = c4Id;
                                oCode.Class5Id = c5Id;
                                oCode.Class6Id = c6Id;

                                ctx.SaveChanges();
                                #endregion

                                // Product Price
                                #region SaveProductSupplement(oBatch, oItem.ProductId);
                                //string sql = "ProductId = '" + productId.ToString() + "'";
                                var oProdSupp = ctx.ProductSupplement.Where(x => x.ProductId == productId).FirstOrDefault();
                                if (oProdSupp == null)
                                {
                                    oProdSupp = new EF6.ProductSupplement();
                                    oProdSupp.SupplementId = Guid.NewGuid();
                                    oProdSupp.ProductId    = productId;

                                    ctx.ProductSupplement.Add(oProdSupp);
                                }
                                oProdSupp.VendorCurrencyCode = oBatch.VCURR;
                                oProdSupp.VendorPrice        = oBatch.VPRC;
                                oProdSupp.ProductName_Memo   = oBatch.DESC_MEMO;
                                oProdSupp.ProductName_Pole   = oBatch.DESC_POLE;

                                ctx.SaveChanges();
                                #endregion

                                #region SaveProductPrice(oBatch, oItem.ProductId);
                                SaveProductPrice(productId, ProductHelper.Prices.BASPRC.ToString(), "HKD", oBatch.BASPRC.ToString());
                                SaveProductPrice(productId, ProductHelper.Prices.ORIPRC.ToString(), "HKD", oBatch.ORIPRC.ToString());
                                SaveProductPrice(productId, ProductHelper.Prices.VPRC.ToString(), oBatch.VCURR, oBatch.VPRC.ToString());
                                SaveProductPrice(productId, ProductHelper.Prices.WHLPRC.ToString(), "HKD", oBatch.WHLPRC.ToString());
                                #endregion

                                // Remarks
                                #region SaveProductRemarks(oBatch, oItem.ProductId);
                                var oRemarks = ctx.ProductRemarks.Where(x => x.ProductId == productId).FirstOrDefault();
                                if (oRemarks == null)
                                {
                                    oRemarks = new EF6.ProductRemarks();
                                    oRemarks.ProductRemarksId = Guid.NewGuid();
                                    oRemarks.ProductId        = productId;

                                    ctx.ProductRemarks.Add(oRemarks);
                                }
                                oRemarks.Photo = oBatch.PHOTO;

                                oRemarks.BinX = oBatch.BINX;
                                oRemarks.BinY = oBatch.BINY;
                                oRemarks.BinZ = oBatch.BINZ;

                                oRemarks.DownloadToShop    = (oBatch.RETAILITEM == "F") ? false : true;
                                oRemarks.OffDisplayItem    = (oBatch.OFF_DISPLAY_ITEM == "F") ? false : true;
                                oRemarks.DownloadToCounter = (oBatch.COUNTER_ITEM == "F") ? false : true;

                                oRemarks.REMARK1 = oBatch.REMARK1;
                                oRemarks.REMARK2 = oBatch.REMARK2;
                                oRemarks.REMARK3 = oBatch.REMARK3;
                                oRemarks.REMARK4 = oBatch.REMARK4;
                                oRemarks.REMARK5 = oBatch.REMARK5;
                                oRemarks.REMARK6 = oBatch.REMARK6;

                                ctx.SaveChanges();
                                #endregion

                                oBatch.STATUS = "OK";
                                ctx.SaveChanges();
                            }
                        }
                    }
                }
            }
        }
示例#9
0
        private bool IsValid()
        {
            bool result = true;

            errorProvider.SetError(txtClassCode, string.Empty);

            #region Class Code 唔可以吉
            if (txtClassCode.Text.Length == 0)
            {
                errorProvider.SetError(txtClassCode, "Cannot be blank!");
                errorProvider.SetIconAlignment(txtClassCode, ErrorIconAlignment.TopLeft);
                result = false;
            }
            #endregion

            #region 新增,要 check Tag Code 係咪 in use
            if (_ClassId == Guid.Empty)
            {
                switch (_ClassType)
                {
                case ProductHelper.Classes.Class1:
                    #region ProductClass1
                    if (ProductClass1Ex.IsClassCodeInUse(txtClassCode.Text.Trim()))
                    {
                        errorProvider.SetError(txtClassCode, "Class Code in use");
                        errorProvider.SetIconAlignment(txtClassCode, ErrorIconAlignment.TopLeft);
                        result = false;
                    }
                    break;

                    #endregion
                case ProductHelper.Classes.Class2:
                    #region ProductClass2
                    if (ProductClass2Ex.IsClassCodeInUse(txtClassCode.Text.Trim()))
                    {
                        errorProvider.SetError(txtClassCode, "Class Code in use");
                        errorProvider.SetIconAlignment(txtClassCode, ErrorIconAlignment.TopLeft);
                        result = false;
                    }
                    break;

                    #endregion
                case ProductHelper.Classes.Class3:
                    #region ProductClass3
                    if (ProductClass3Ex.IsClassCodeInUse(txtClassCode.Text.Trim()))
                    {
                        errorProvider.SetError(txtClassCode, "Class Code in use");
                        errorProvider.SetIconAlignment(txtClassCode, ErrorIconAlignment.TopLeft);
                        result = false;
                    }
                    break;

                    #endregion
                case ProductHelper.Classes.Class4:
                    #region ProductClass4
                    if (ProductClass4Ex.IsClassCodeInUse(txtClassCode.Text.Trim()))
                    {
                        errorProvider.SetError(txtClassCode, "Class Code in use");
                        errorProvider.SetIconAlignment(txtClassCode, ErrorIconAlignment.TopLeft);
                        result = false;
                    }
                    break;

                    #endregion
                case ProductHelper.Classes.Class5:
                    #region ProductClass5
                    if (ProductClass5Ex.IsClassCodeInUse(txtClassCode.Text.Trim()))
                    {
                        errorProvider.SetError(txtClassCode, "Class Code in use");
                        errorProvider.SetIconAlignment(txtClassCode, ErrorIconAlignment.TopLeft);
                        result = false;
                    }
                    break;

                    #endregion
                case ProductHelper.Classes.Class6:
                    #region ProductClass6
                    if (ProductClass6Ex.IsClassCodeInUse(txtClassCode.Text.Trim()))
                    {
                        errorProvider.SetError(txtClassCode, "Class Code in use");
                        errorProvider.SetIconAlignment(txtClassCode, ErrorIconAlignment.TopLeft);
                        result = false;
                    }
                    break;
                    #endregion
                }
            }
            #endregion

            return(result);
        }
示例#10
0
        private void FillParentClassList()
        {
            string sql;

            string[] orderBy;

            switch (_ClassMode)
            {
            case ProductHelper.Classes.Class1:
                #region fill Class1 combo
                sql     = "Class1Id NOT IN ('" + _ClassId.ToString() + "')";
                orderBy = new string[] { "Class1Code" };

                ProductClass1Ex.LoadCombo(ref cboParentClass, "Class1Code", false, true, "", sql, orderBy);
                ProductClass1Ex.LoadCombo(ref cboAltClass, "Class1Code", false, true, "", sql, orderBy);
                break;

                #endregion
            case ProductHelper.Classes.Class2:
                #region fill Class2 combo
                sql     = "Class2Id NOT IN ('" + _ClassId.ToString() + "')";
                orderBy = new string[] { "Class2Code" };

                ProductClass2Ex.LoadCombo(ref cboParentClass, "Class2Code", false, true, "", sql, orderBy);
                ProductClass2Ex.LoadCombo(ref cboAltClass, "Class2Code", false, true, "", sql, orderBy);
                break;

                #endregion
            case ProductHelper.Classes.Class3:
                #region fill Class3 combo
                sql     = "Class3Id NOT IN ('" + _ClassId.ToString() + "')";
                orderBy = new string[] { "Class3Code" };

                ProductClass3Ex.LoadCombo(ref cboParentClass, "Class3Code", false, true, "", sql, orderBy);
                ProductClass3Ex.LoadCombo(ref cboAltClass, "Class3Code", false, true, "", sql, orderBy);
                break;

                #endregion
            case ProductHelper.Classes.Class4:
                #region fill Class4 combo
                sql     = "Class4Id NOT IN ('" + _ClassId.ToString() + "')";
                orderBy = new string[] { "Class4Code" };

                ProductClass4Ex.LoadCombo(ref cboParentClass, "Class4Code", false, true, "", sql, orderBy);
                ProductClass4Ex.LoadCombo(ref cboAltClass, "Class4Code", false, true, "", sql, orderBy);
                break;

                #endregion
            case ProductHelper.Classes.Class5:
                #region fill Class5 combo
                sql     = "Class5Id NOT IN ('" + _ClassId.ToString() + "')";
                orderBy = new string[] { "Class5Code" };

                ProductClass5Ex.LoadCombo(ref cboParentClass, "Class5Code", false, true, "", sql, orderBy);
                ProductClass5Ex.LoadCombo(ref cboAltClass, "Class5Code", false, true, "", sql, orderBy);
                break;

                #endregion
            case ProductHelper.Classes.Class6:
                #region fill Class6 combo
                sql     = "Class6Id NOT IN ('" + _ClassId.ToString() + "')";
                orderBy = new string[] { "Class6Code" };

                ProductClass6Ex.LoadCombo(ref cboParentClass, "Class6Code", false, true, "", sql, orderBy);
                ProductClass6Ex.LoadCombo(ref cboAltClass, "Class6Code", false, true, "", sql, orderBy);
                break;
                #endregion
            }
        }