public static void VerifyFileNames()
{
DataTable dt = new DataTable();
dt.Columns.Add("FileName");
dt.Columns.Add("ExtractedID");
dt.Columns.Add("Match");
string dir = $@"{jobDir}\PDF Extraction\Transcripts\Fixed\New folder";
string[] files = Directory.GetFiles(dir);
string id = "";
foreach (var file in files)
{
id = ReadID(file);
DataRow r = dt.NewRow();
r["FileName"] = file;
r["ExtractedID"] = id;
r["Match"] = System.IO.Path.GetFileNameWithoutExtension(file).Split('-')[0] == id ? "True" : "False";
dt.Rows.Add(r);
}
TextFileRW.writeTableToTxtFile(dt, $@"{jobDir}\PDF Extraction\FileNameVerification.txt", "\t");
}
public static void MatchIDs()
{
DataTable source = TextFileRW.readTextFileToTable($@"{jobDir}\{dataFile}", "\t");
source.Columns.Add("PageCount");
source.Columns.Add("Index");
DataTable sample = TextFileRW.readTextFileToTable($@"{jobDir}\PDF Extraction\PageCounts.txt", "\t");
sample.Columns.Add("Matched");
foreach (DataRow sourceRow in source.Rows)
{
foreach (DataRow sampleRow in sample.Rows)
{
if (sourceRow["Person Id"].ToString() == sampleRow["ID"].ToString())
{
sourceRow["PageCount"] = sampleRow["PageCount"];
sourceRow["Index"] = sampleRow["Index"];
sampleRow["Matched"] = "True";
}
}
}
TextFileRW.writeTableToTxtFile(source, $@"{jobDir}\{dataFile.Replace(".txt","")}_merged.txt", "\t");
TextFileRW.writeTableToTxtFile(sample, $@"{jobDir}\Transcripts List.txt", "\t");
}