public string GetPersonalNumber(SettingsWorkwearItemsViewModel settings, SheetRowWorkwearItems row, int columnIndex)
{
var original = settings.ConvertPersonnelNumber ?
EmployeeParse.ConvertPersonnelNumber(row.CellStringValue(columnIndex)) : row.CellStringValue(columnIndex);
return(original?.Trim());
}
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);
}