private List <FamilyImporter> GetLanguageItems(List <TalentExcelImport> importList,
ref List <TalentExcelImport> writingList, ref List <TalentExcelImport> speakingList)
{
var result = new List <FamilyImporter>();
writingList = new List <TalentExcelImport>();
speakingList = new List <TalentExcelImport>();
FamilyImporter currentFamilyImport = null;
var pos = 0;
foreach (var item in importList)
{
var rowType = TalentExcelImportType(item);
if (rowType == ExcleRowType.Title)
{
currentFamilyImport = new FamilyImporter
{
Family = new LanguageFamily(RemoveTitel(item.Sprache))
};
pos = 0;
result.Add(currentFamilyImport);
}
else if (rowType == ExcleRowType.ValidTalent)
{
if (!string.IsNullOrEmpty(item.Sprache))
{
item.OrginalPosition = pos;
item.Talent = item.Sprache;
speakingList.Add(item);
currentFamilyImport.Speaking.Add(item);
}
if (!string.IsNullOrEmpty(item.Schrift))
{
var itemWriting = new TalentExcelImport
{
BE = item.Komplex2,
Talent = item.Schrift,
OrginalPosition = pos
};
;
writingList.Add(itemWriting);
currentFamilyImport.Writing.Add(itemWriting);
}
pos++;
}
}
return(result);
}
private ExcleRowType TalentExcelImportType(TalentExcelImport talent)
{
if (talent.Talent != null && talent.Talent.StartsWith(EXCELTITLE, StringComparison.CurrentCulture))
{
return(ExcleRowType.Title);
}
else if (talent.Sprache != null && talent.Sprache.StartsWith(EXCELTITLE, StringComparison.CurrentCulture))
{
return(ExcleRowType.Title);
}
else if (string.IsNullOrEmpty(talent.Talent) && string.IsNullOrEmpty(talent.Schrift) && string.IsNullOrEmpty(talent.Sprache))
{
return(ExcleRowType.NoValidTalent);
}
return(ExcleRowType.ValidTalent);
}
