public IEnumerable <string> Read(Stream stream)
{
var groupLoader = new CommissionGroupLoader();
var sheetGroups = groupLoader.LoadForSheet(_sheet, stream);
var commissionTypes = new List <string>();
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
var sheetNumber = 0;
do
{
//Increment the sheet number
sheetNumber++;
if (_sheet.Position != sheetNumber)
{
continue;
}
var rowNumber = 0;
var header = new HeaderLocator(_sheet.Config.HeaderIdentifier);
while (reader.Read())
{
rowNumber++;
if (!header.Found)
{
header.Check(reader);
continue;
}
var groupValues = new List <GroupValue>();
if (sheetGroups != null)
{
groupValues = sheetGroups.RowGroups.Single(r => r.RowNumber == rowNumber).GroupValues;
}
//Ignore row if any of the primary field values are empty
var requiredFields = _sheet.Config.Fields.Where(f => Fields.PrimaryFieldNames().Any(p => p == f.Name));
var anyMissingRequiredFields = requiredFields.Any(field =>
{
var fieldValue = Utils.GetValue(reader, ExcelUtils.ColumnToIndex(field.Column));
return(string.IsNullOrWhiteSpace(fieldValue));
});
if (anyMissingRequiredFields)
{
continue;
}
var value = CommissionImportReader.GetCommissionTypeValue(reader, _sheet.Config, groupValues);
commissionTypes.Add(value);
}
} while (reader.NextResult());
}
return(commissionTypes.Distinct().ToList());
}
private SheetGroups GetSheetGroups(IExcelDataReader reader, SheetConfig config, int sheetNumber)
{
var sheetGroups = new SheetGroups()
{
SheetNumber = sheetNumber,
RowGroups = new List <RowGroups>()
};
var rowNumber = 0;
var header = new HeaderLocator(config.HeaderIdentifier);
while (reader.Read())
{
rowNumber++;
if (!header.Found)
{
header.Check(reader);
continue;
}
var rowGroups = new RowGroups(rowNumber);
//Check groupings
int hierarchyOrder = 0;
foreach (var group in config.Groups)
{
hierarchyOrder++;
var groupValue = new GroupValue(group.FieldName, hierarchyOrder);
//Check for match
var isMatch = true;
foreach (var identifier in group.Identifiers)
{
var value = CommissionImportReader.GetValue(reader, identifier.Column) ?? "";
if (Regex.Matches(value, identifier.Value).Count == 0)
{
isMatch = false;
}
}
if (isMatch)
{
var value = CommissionImportReader.GetValue(reader, group.Column) ?? "";
if (!string.IsNullOrEmpty(group.Formatter))
{
var match = Regex.Match(value, group.Formatter);
if (match.Success)
{
value = match.Value;
}
}
groupValue.Value = value;
groupValue.IsInherited = false;
}
rowGroups.GroupValues.Add(groupValue);
}
sheetGroups.RowGroups.Add(rowGroups);
}
;
return(sheetGroups);
}
