Add Group reference to Product by GroupNumber

Hi Dynamicweb,

Will it be possible to have extended the below search in the EcomProvider with: or GroupNumber= '" + group + "':

private void AddGroupReferenceToProduct(string productID, string languageID, string group, string sorting, string primaryGroup)

        {
            bool isPrimary = (group == primaryGroup) ? true : false;
            group = group.Replace("'", "''");
            DataRow[] groupRows = ExistingGroups.Select("GroupID='" + group + "' or GroupName= '" + group + "'");
            if (groupRows.Length > 0)
            {
                AddGroupReferenceToProduct(productID, (string)groupRows[0]["GroupID"], sorting, isPrimary);
            }
            else
            {
                groupRows = DataToWrite.Tables["EcomGroups"].Select("GroupID='" + group + "' or GroupName = '" + group + "'");
                if (groupRows.Length > 0)
                {
                    AddGroupReferenceToProduct(productID, (string)groupRows[0]["GroupID"], sorting, isPrimary);
                }
                else
                {
                    LastGroupId = LastGroupId + 1;
                    var newGroup = DataToWrite.Tables["EcomGroups"].NewRow();

                    newGroup["GroupID"] = "ImportedGROUP" + LastGroupId;
                    if (string.IsNullOrEmpty(languageID))
                    {
                        newGroup["GroupLanguageID"] = _defaultLanguageId;
                    }
                    else
                    {
                        newGroup["GroupLanguageID"] = languageID;
                    }
                    newGroup["GroupName"] = group;
                    DataToWrite.Tables["EcomGroups"].Rows.Add(newGroup);
                    AddShopReferenceToGroup("ImportedGROUP" + LastGroupId, DefaultShop, 0);
                    AddGroupReferenceToProduct(productID, (string)newGroup["GroupID"], sorting, isPrimary);
                }
            }
        }

If possible, then please also add to the latest version of 8.9.

Thank you very much,

Anders

Developer forum

Add Group reference to Product by GroupNumber

Replies