private bool TryParseSizeAndGrowth(
IUnitOfWork uow,
SheetRowWorkwearItems row,
List <ImportedColumn <DataTypeWorkwearItems> > columns,
out SizeAndGrowth sizeAndGrowth)
{
sizeAndGrowth = new SizeAndGrowth();
var sizeAndGrowthColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.SizeAndGrowth);
var sizeColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Size);
var growthColumn = columns.FirstOrDefault(x => x.DataType == DataTypeWorkwearItems.Growth);
if (sizeAndGrowthColumn != null)
{
var sizeAndGrowthValue = row.CellStringValue(sizeAndGrowthColumn.Index);
if (!String.IsNullOrEmpty(sizeAndGrowthValue))
{
sizeAndGrowth = SizeParser.ParseSizeAndGrowth(sizeAndGrowthValue, uow, sizeService);
}
}
;
if (sizeColumn != null && sizeAndGrowth.Size != null)
{
sizeAndGrowth.Size = SizeParser.ParseSize(uow, row.CellStringValue(sizeColumn.Index), sizeService, CategorySizeType.Size);
}
if (growthColumn != null && sizeAndGrowth.Growth != null)
{
sizeAndGrowth.Growth = SizeParser.ParseSize(uow, row.CellStringValue(growthColumn.Index), sizeService, CategorySizeType.Height);
}
return(sizeAndGrowth.Size != null || sizeAndGrowth.Growth != null);
}
public static SizeAndGrowth ParseSizeAndGrowth(string value, IUnitOfWork uow, SizeService sizeService)
{
var result = new SizeAndGrowth();
var parts = value.Split(' ');
var onlySize = parts[0];
string size1 = "", size2 = "", growth1 = "", growth2 = "", number = "";
bool isHyphen1 = false, isHyphen2 = false, isSeparator = false, isFloat = false;
var sizeWear = new List <string> {
"M", "L", "XL", "XXL", "XXXL", "4XL", "5XL"
};
if (onlySize.Count(x => x == 'L') == 1)
{
onlySize = onlySize.Replace('2', 'X');
onlySize = onlySize.Replace("3", "XX");
}
if (sizeWear.Contains(onlySize))
{
size1 = onlySize;
}
foreach (var character in onlySize)
{
if (char.IsDigit(character))
{
number += character;
}
else if (character == ',' || character == '.')
{
isFloat = true;
number += ',';
continue;
}
else if (character == '-' && !isSeparator)
{
isHyphen1 = true;
isFloat = false;
number = "";
continue;
}
else if (character == '-' && isSeparator)
{
isHyphen2 = true;
isFloat = false;
number = "";
continue;
}
else if (character == '/')
{
isSeparator = true;
isFloat = false;
number = "";
continue;
}
else
{
number = ""; break;
}
if (number.Length > 0 && !isHyphen1 && !isHyphen2 && !isSeparator)
{
size1 = !isFloat && int.Parse(number) > 70 ? (int.Parse(number) / 2).ToString() : number;
}
else if (number.Length > 0 && isHyphen1 && !isHyphen2 && !isSeparator)
{
size2 = !isFloat && int.Parse(number) > 70 ? (int.Parse(number) / 2).ToString() : number;
}
else if (number.Length > 0 && !isHyphen1 && !isHyphen2 && isSeparator)
{
growth1 = number;
}
else if (number.Length > 0 && isHyphen1 && !isHyphen2 && isSeparator)
{
growth1 = number;
}
else if (number.Length > 0 && isHyphen1 && isHyphen2 && isSeparator)
{
growth2 = number;
}
else if (number.Length > 0 && !isHyphen1 && isHyphen2 && isSeparator)
{
growth2 = number;
}
}
result.Size = ParseSize(uow, size2.Length > 0 ? size1 + "-" + size2 : size1, sizeService, CategorySizeType.Size);
result.Growth = ParseSize(uow, growth2.Length > 0 ? growth1 + "-" + growth2 : growth1, sizeService, CategorySizeType.Height);
return(result);
}