public List <TwoDateColumnRelationContainer <string> > getExistRelationFormExistExcel() { List <TwoDateColumnRelationContainer <string> > relationContainerList = new List <TwoDateColumnRelationContainer <string> >(); DirectoryInfo TheFolder = new DirectoryInfo(relationExcelFolderPath); foreach (FileInfo NextFile in TheFolder.GetFiles()) { if (NextFile.Extension.Equals(excelExtensions[0]) || NextFile.Extension.Equals(excelExtensions[1])) { if (NextFile.Extension.Equals(excelExtensions[0])) { string nameWithoutExtension = NextFile.Name.Remove(NextFile.Name.Length - 5, 5); TwoDateColumnRelationContainer <string> twoDateColumnRelationContainer = packageNameWithoutExtension(nameWithoutExtension); relationContainerList.Add(twoDateColumnRelationContainer); } if (NextFile.Extension.Equals(excelExtensions[1])) { string nameWithoutExtension = NextFile.Name.Remove(NextFile.Name.Length - 4, 4); TwoDateColumnRelationContainer <string> twoDateColumnRelationContainer = packageNameWithoutExtension(nameWithoutExtension); relationContainerList.Add(twoDateColumnRelationContainer); } } } return(relationContainerList); }
private TwoDateColumnRelationContainer <string> packageNameWithoutExtension(string nameWithoutExtension) { string[] relationColumns = nameWithoutExtension.Split(new char[1] { '-' }); TwoDateColumnRelationContainer <string> twoDateColumnRelationContainer = new TwoDateColumnRelationContainer <string>(); twoDateColumnRelationContainer.Add(relationColumns[0]); twoDateColumnRelationContainer.Add(relationColumns[1]); return(twoDateColumnRelationContainer); }