public static void UpdateAncientChecksTableFromFile(string uploadedFile) { List <DispositionRow> researchRows = CheckManager.GetResearchRows(uploadedFile); // Handle incidental checks before persisting unmatched checks. // This way an Interview Research file cannot add to the set // of resolved checks by mistake. // For example, the Interview Research File may contain both // Estes, Jason TID = 74726, TID Disposition = Voided/Replaced // Justice, Mark TID = 74726, TID Disposition = ? // In this case, check number 74726 was mistakenly assigned to both // the TID for Jason Estes and the TID for Mark Justice. // If incidental checks are handled after unmatched checks are persisted, // then the check for Jason Estes will resolve the check for Mark Justice. // We don't want this to happen! Most likely, the check number 74726 // for Mark Justice was a typo. // PLB 12/14/2018 CheckManager.HandleIncidentalChecks(researchRows); CheckManager.RebuildAncientChecksTable(researchRows); // PLB 12/14/2018 Don't call RemoveTypoChecks // CheckManager.RemoveTypoChecks(); }