CategoryFieldsRenderer

CategoryFieldsRenderer.cs

using Dynamicweb.Ecommerce.Products;
using System;
using System.Collections.Generic;
using System.Linq;

namespace Dynamicweb.Education.Ecommerce
{
    public class CategoryFieldsRenderer
    {
        public string Render(IEnumerable<ProductInfo> products, string categoryId)
        {
            var fields = GetCategoryFields(categoryId);
            var result = "<table class=\"table\"><thead><tr>";            
            foreach (var field in fields)
            {
                result += $"<th>{field.Name}</th>";
            }
            result += "</tr></thead>";
            result += "<tbody>";
            foreach(var productInfo in products)
            {
                var product = Dynamicweb.Ecommerce.Services.Products.GetProductById(productInfo.ProductId, productInfo.VariantId, productInfo.LanguageId);
                if (product == null)
                {
                    continue;
                }
                result += "<tr>";
                foreach (var field in fields)
                {
                    var propValue = Dynamicweb.Ecommerce.Services.Products.GetFieldValue(product, field);
                    result += $"<td>{(propValue.Succeeded && propValue.Data != null ? propValue.Data : string.Empty)}</td>";
                }
                result += "</tr>";
            }
            result += "</tbody></table>";
            return result;
        }

        private IEnumerable<ProductField> GetCategoryFields(string categoryId)
        {
            var categoriesFieldsIdx = ProductField.GetCategoryFields().ToDictionary(f => f.SystemName);
            var category = Dynamicweb.Ecommerce.Services.ProductCategories.GetCategoryById(categoryId);
            if (category == null)
            {
                throw new ArgumentException($"The category {categoryId} doesn't exist");
            }
            var fields = category.Fields;
            var result = new List<ProductField>();
            foreach(var field in fields)
            {
                var sysName = $"ProductCategory|{field.Category.Id}|{field.Id}";
                ProductField prodField;
                if (categoriesFieldsIdx.TryGetValue(sysName, out prodField))
                {
                    result.Add(prodField);
                }
            }
            return result;
        }
    }
}

ProductInfo.cs

namespace Dynamicweb.Education.Ecommerce
{
    public class ProductInfo
    {
        public string ProductId { get; set; }
        public string LanguageId { get; set; }
        public string VariantId { get; set; }
    }
}