public CellSet GetCells(ItemDto item, string culture)
{
var cellSetRow = new CellSet.Row { key = Encoding.UTF8.GetBytes(item.Code) };
var cells = new List<Cell>();
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:Status"), data = Encoding.UTF8.GetBytes(item.Status) });
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:MH" + item.MerchandiseHierarchy.Code), data = _serializer.SerializeToBson(item.MerchandiseHierarchy) });
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:CreatedDate"), data = Encoding.UTF8.GetBytes(DateTime.Now.ToString()) });
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:UpdatedDate"), data = Encoding.UTF8.GetBytes(DateTime.Now.ToString()) });
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:Long_" + culture), data = Encoding.UTF8.GetBytes(item.Description) });
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:Short_" + culture), data = Encoding.UTF8.GetBytes(item.ShortDescription) });
foreach (var group in item.Groups)
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:G" + group.Code), data = _serializer.SerializeToBson(group) });
foreach (var identifier in item.Identifiers)
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:I" + identifier.Type), data = Encoding.UTF8.GetBytes(identifier.Value) });
foreach (var attributes in item.Attributes)
cells.Add(new Cell { column = Encoding.UTF8.GetBytes("CF1:A" + culture + "_" + attributes.Id), data = _serializer.SerializeToBson(attributes.Value) });
cellSetRow.values.AddRange(cells);
var cellSet = new CellSet();
cellSet.rows.Add(cellSetRow);
return cellSet;
}
public ItemDto GetDto(CellSet cellSet, string culture)
{
var itemRow = cellSet.rows.First();
//Retrieve a cell by its key.
var columnNameMapping = itemRow.values.ToDictionary(o => Encoding.UTF8.GetString(o.column), o => o.data);
var item = new ItemDto();
item.Code = Encoding.UTF8.GetString(itemRow.key);
item.Status = Encoding.UTF8.GetString(columnNameMapping["CF1:Status"]);
var hierarchyColumnKey = columnNameMapping.Keys.Where(o => o.StartsWith("CF1:MH"));
item.MerchandiseHierarchy = _serializer.DeseralizeFromBson<HierarchyDto>(columnNameMapping[hierarchyColumnKey.First()]);
item.CreatedDate = DateTime.Parse(Encoding.UTF8.GetString(columnNameMapping["CF1:CreatedDate"]));
item.LastUpdateDate = DateTime.Parse(Encoding.UTF8.GetString(columnNameMapping["CF1:UpdatedDate"]));
item.Description = Encoding.UTF8.GetString(columnNameMapping["CF1:Long_" + culture]);
item.ShortDescription = Encoding.UTF8.GetString(columnNameMapping["CF1:Short_" + culture]);
var groupColumnKeys = columnNameMapping.Keys.Where(o => o.StartsWith("CF1:G"));
item.Groups = new List<HierarchyDto>();
foreach (var groupKey in groupColumnKeys)
item.Groups.Add(_serializer.DeseralizeFromBson<HierarchyDto>(columnNameMapping[groupKey]));
var identifiersColumnKeys = columnNameMapping.Keys.Where(o => o.StartsWith("CF1:I"));
item.Identifiers = new List<Identifier>();
foreach (var identifierKey in identifiersColumnKeys)
item.Identifiers.Add(new Identifier{ Value= Encoding.UTF8.GetString(columnNameMapping[identifierKey]),Type= identifierKey.Substring(5)});
var attributesColumnKeys = columnNameMapping.Keys.Where(o => o.StartsWith("CF1:A" + culture));
item.Attributes = new List<AttributeDto>();
foreach (var attributeKey in attributesColumnKeys)
item.Attributes.Add(new AttributeDto { Id = attributeKey.Substring(11), Value = _serializer.DeseralizeFromBson<AttributeValue>(columnNameMapping[attributeKey]) });
return item;
}