internal static void ManipulateColumns(List <string> commonHeaderTemplate)
{
foreach (string file in Directory.EnumerateFiles(ConfigurationManager.AppSettings["PremierLeagueData"], "*.csv"))
{
InteropExcel.GetValues(file, commonHeaderTemplate);
}
}
internal static void CheckColumnsOrder()
{
List <string> templateModel = new List <string>();
List <string> dataModel = new List <string>();
int k = 0;
#warning hardcode...data/output content
foreach (string file in Directory.EnumerateFiles(@"D:\Andrei\Cariera\Proiecte Git\csv-parser\csv-parser\Data\Output\PremierLeague", "*.csv"))
{
List <string> fileColumns = CSVParser_IO.ReadCSV(file);
List <string> fileHeaderColumn = new List <string>();
int numberofcolumns = InteropExcel.GetNumberOfColumns(file);
for (int i = 0; i < numberofcolumns; i++)
{
fileHeaderColumn.Add(fileColumns[i]);
}
foreach (var elem in fileHeaderColumn)
{
if (k == 0)
{
templateModel.Add(elem);
}
else
{
dataModel.Add(elem);
}
}
if (k > 0)
{
if (templateModel.SequenceEqual(dataModel))
{
Console.WriteLine("OK");
}
else
{
Console.WriteLine("NOT OK");
}
}
k = k + 1;
dataModel = new List <string>();
}
}
internal static void RemoveColumns(List <string> commonHeaderTemplate)
{
foreach (string file in Directory.EnumerateFiles(ConfigurationManager.AppSettings["PremierLeagueData"], "*.csv"))
{
List <string> fileColumns = CSVParser_IO.ReadCSV(file);
List <string> fileHeaderColumn = new List <string>();
int numberofcolumns = InteropExcel.GetNumberOfColumns(file);
for (int i = 0; i < numberofcolumns; i++)
{
fileHeaderColumn.Add(fileColumns[i]);
}
List <string> extraColumns = new List <string>();
foreach (var item in fileHeaderColumn)
{
if (!commonHeaderTemplate.Contains(item))
{
extraColumns.Add(item);
}
}
InteropExcel.RemoveColumns(file, extraColumns);
}
}
