/// <summary>
/// Generates variants into DataSet and DataTable.
/// </summary>
/// <returns>DataSet of generated variants</returns>
private DataSet GenerateVariants()
{
List <ProductVariant> productVariantList;
// Creating new variants and some has been already generated
if ((NewCategories.Count > 0) && (ExistingCategories.Count > 0))
{
ProductAttributeSet productAttributeSet = new ProductAttributeSet(CategorySelector.SelectedCategories.Values.Where(x => x > VariantOptionInfo.NewOption));
List <ProductVariant> oldVariants = VariantHelper.AddNewCategoriesToVariantsOfProduct(ProductID, productAttributeSet);
productVariantList = VariantHelper.GetAllPossibleVariants(oldVariants);
}
else
{
productVariantList = VariantHelper.GetAllPossibleVariants(ProductID, NewCategories.Concat(ExistingCategories));
}
DataSet ds = new DataSet("VariantsDS");
DataTable dt = new DataTable("VariantsDT");
// Combine new and existing categories in right order
var combinedCategories = ExistingCategories.Union(NewCategories).OrderBy(cID => mAllCategoriesOptions.FindIndex(ca => ca.Item1.CategoryID == cID));
// Build DataTable and UniGrid structure
foreach (int categoryId in combinedCategories)
{
var optionCategory = mAllCategoriesOptions.FirstOrDefault(k => k.Item1.CategoryID == categoryId);
// Add columns to DataTable
dt.Columns.Add(new DataColumn(categoryId.ToString(), typeof(String)));
// Add column with option category live site display name to the grid with variant preview. In case live site display name is not available option category display name is used
if (optionCategory != null)
{
AddGridColumn(ResHelper.LocalizeString(optionCategory.Item1.CategoryTitle), categoryId.ToString(), "#transform: ecommerce.skuoption.SKUName");
}
}
// Add RowNumber column to DataTable
dt.Columns.Add(new DataColumn("RowNumber", typeof(int)));
AddGridColumn("RowNumber", "RowNumber", string.Empty, true);
// Add Exist column to DataTable
dt.Columns.Add(new DataColumn("Exist", typeof(bool)));
// Add Variant number column to DataTable and UniGrid
dt.Columns.Add(new DataColumn("VariantNumber", typeof(string)));
AddGridColumn(GetString("com.sku.skunumber"), "VariantNumber");
// Fill DataTable
int index = 0;
foreach (ProductVariant productVariant in productVariantList)
{
DataRow dr = dt.NewRow();
int i = 0;
foreach (int categoryId in productVariant.ProductAttributes.CategoryIDs)
{
// Fill values to dynamically added column
var optionCategory = mAllCategoriesOptions.FirstOrDefault(k => k.Item1.CategoryID == categoryId);
if (optionCategory != null)
{
dr[optionCategory.Item1.CategoryID.ToString()] = productVariant.ProductAttributes[i].SKUID;
i++;
}
}
dr["RowNumber"] = index;
dr["Exist"] = productVariant.Existing;
dr["VariantNumber"] = productVariant.Variant.SKUNumber;
dt.Rows.Add(dr);
index++;
}
ds.Tables.Add(dt);
return(ds);
}