public void GetSubStringIndex_NoSubstring()
{
var column = "D";
var actual = MappingTemplate.GetSubStringIndexes(column);
Assert.Empty(actual);
}
public void GetSubStringIndex_HasSubstring_DoubleDigit()
{
var column = "D(1-15)";
var actual = MappingTemplate.GetSubStringIndexes(column);
Assert.Equal(2, actual.Count);
Assert.Equal(1, actual[0]);
Assert.Equal(15, actual[1]);
}
private bool HaveValidExcelColumnIdentifiers(string mappingTemplate)
{
foreach (var part in MappingTemplate.Parse(mappingTemplate))
{
try
{
var column = MappingTemplate.GetColumn(part);
if (MappingTemplate.IsSubstring(part))
{
var subStringIndex = MappingTemplate.GetSubStringIndexes(part);
if (subStringIndex.Count != 0 && subStringIndex.Count != 2)
{
return(false);
}
if (subStringIndex.Count == 2)
{
if (subStringIndex[0] >= subStringIndex[1])
{
return(false);
}
}
}
if (!Utils.IsValidExcelColumn((column)) && column != CommissionTypes.GROUP_COMMISSION_TYPE)
{
return(false);
}
}
catch
{
return(false);
}
}
return(true);
}
public static string GetCommissionTypeValue(IExcelDataReader reader, SheetConfig config, List <GroupValue> groupValues)
{
var parts = MappingTemplate.Parse(config.CommissionTypes.MappingTemplate);
if (!parts.Any())
{
return(config.CommissionTypes.DefaultCommissionTypeCode);
}
var values = new List <string>();
foreach (var part in parts)
{
string value = "";
if (part == CommissionTypes.GROUP_COMMISSION_TYPE)
{
value = GetGroupValue(groupValues, GroupFieldNames.CommissionType);
}
else
{
var column = MappingTemplate.GetColumn(part);
var index = ExcelUtils.ColumnToIndex(column);
value = Utils.GetValue(reader, index);
//Update value is substring is defined
if (MappingTemplate.IsSubstring(part))
{
try
{
var subStringIndex = MappingTemplate.GetSubStringIndexes(part);
var startIndex = subStringIndex[0] - 1;
var length = subStringIndex[1] - subStringIndex[0] + 1;
value = value.Substring(startIndex, length);
}
catch { }
}
//Update value is regex is defined
if (MappingTemplate.IsRegex(part))
{
try
{
var regex = MappingTemplate.GetRegex(part);
var match = Regex.Match(value, regex, RegexOptions.IgnoreCase);
if (match.Success)
{
value = match.Value;
}
else
{
value = "";
}
}
catch { }
}
}
values.Add(value);
}
return(MappingTemplate.Format(values));
}