public static List<ClassDataFile> CompileFileList(string pickUpLocation, ref ClassImportInfoDataTable infoTable, bool useAuditFile) { List<ClassDataFile> fileList = new List<ClassDataFile>(); String[] filePaths = Directory.GetFiles(pickUpLocation); ClassDataFile[] datFiles = new ClassDataFile[filePaths.Count()]; int count = 0; if (useAuditFile) { string auditFileLocation = Properties.Settings.Default.AuditFileLocation; ClassAuditFile auditFile = new ClassAuditFile(auditFileLocation); DataTables.ClassAuditEntriesDataTable auditEntriesTable = new DataTables.ClassAuditEntriesDataTable(); auditEntriesTable = DataTables.ClassAuditEntriesDataTable.FillEntriesTable(auditFile); if (auditEntriesTable.entriesTable.Rows.Count >= 1) { foreach (String fileLoc in filePaths) { datFiles[count] = new ClassDataFile(filePaths[count]); infoTable.AddNewRow(datFiles[count], ref infoTable); string message = string.Empty; message = ClassAuditing.SelfCheck(datFiles[count]); infoTable.UpdateRow(datFiles[count], "Self_Check_Result", message, ref infoTable); message = ClassAuditing.AuditFileCheck(datFiles[count], auditEntriesTable); infoTable.UpdateRow(datFiles[count], "AuditFile_Check_Result", message, ref infoTable); //• ONLY ADD FILE TO LIST IF AUDIT PASSED if ((datFiles[count].PassedSelfCheck == true) && (datFiles[count].PassedAuditFileCheck == true)) fileList.Add(datFiles[count]); count++; } } } else { foreach (String fileLoc in filePaths) { datFiles[count] = new ClassDataFile(filePaths[count]); infoTable.AddNewRow(datFiles[count], ref infoTable); string message = string.Empty; message = ClassAuditing.SelfCheck(datFiles[count]); infoTable.UpdateRow(datFiles[count], "Self_Check_Result", message, ref infoTable); //• ONLY ADD FILE TO LIST IF AUDIT PASSED if (datFiles[count].PassedSelfCheck == true) fileList.Add(datFiles[count]); count++; } } return fileList; }
public static void UpdateInCompleteAudits(DataTable table, ClassAuditEntriesDataTable entriesTable, ref ClassImportInfoDataTable infoTable, string connectionString) { string message; foreach (DataRow dataRow in table.Rows) { ClassDataFile datFile = new ClassDataFile(dataRow); infoTable.AddNewRow(datFile, ref infoTable); message = ClassGatherInfo.VerifyFileIntact(datFile, entriesTable); message = AuditFileCheck(datFile, entriesTable); infoTable.UpdateRow(datFile, "AuditFile_Check_Result", message, ref infoTable); //• ONLY UPDATE THE ENTRY IF AUDIT PASSED if (datFile.PassedAuditFileCheck) ClassSQLAccess.UpdateIncompleteAudit(datFile, connectionString); } }