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); }