Exception-Nikhil, C#

Exception-Nikhil

//Rextester.Program.Main is the entry point for your code. Don't change it.
//Compiler version 4.0.30319.17929 for Microsoft (R) .NET Framework 4.5

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;

namespace Rextester
{
    public class Program
    {
        public static void Main(string[] args)
        {
            //Your code goes here
     
        List<string> modelInventory = new string[]{"Id","QTMParents","QTMChildren","QTMNumber","LoB","QTMName","SubLoB","SegmentName","HistoricalModelNumber","DevelopmentValidationCategory","QTMUses","OtherQTMUses","StressIndicator","QTMOwner","ImplementationDate","ValidationDate","Validators","ValidatedBy","ValidationResult","ValidationActivity","AnnualReviewDate","AnnualReviewBy","AnnualReviewResult","AnnualReviewComments","VersionReviewed","DeepDiveReview","AnnualRiskRankAssessmentDate","AnnualRiskRankAssessmentResults","LoBRecoRiskRank","LoBsUsingQTM","QTMUsers","FinalApprovedRiskRank","RiskRankApprovedDate","CMoRRiskRankComments","CertificationDate","CertificationBy","CertificationComments","RetiredQTM","RetiredQTMComments","EconomicVariables","ACLRatings","NextValidationDate","Developers","Version","LastRevisionDate","RetiredDate","IssuesStatusFlag","OpenExceptionIndicator","ApprovalDates","ApprovalComments","PerformanceMonitoringMetric","AttestedDate","AttestationComments","NumberOfModelsInScorecardSuite","VendorModel","ThirdPartyVendorName","VendorEngagementId","ModelRiskOfficer","ModelRiskScore","NextAnnualReviewDate","RABU","CMoRModelRating","AddDate","CreditScoringModelType","CurrentApprovalStatus","RiskRankId","CFMO","ModelLifeCycleStatus","CMOR1","CMOR2","LOB1","LOB2","LOB3","Groups","QTMDescription","MonitoringStatus","MonitoringProgramReferenceNumber","QTMIDStatus","ReviewPeriod","ModelPerformanceReviewResult","LOBGovernance","CMoRPerformanceReviewer","MonitoringLead","ApprovalStatus","ApprovalCategory","ApprovalDate","QTMRegulatoryReportingType","QTMRegulatoryReportingUses","ApprovedQTMUses","ApprovedQTMUseDetails","QTMRestrictions","QTMLimitations","ApprovalDescription","ValidationComment","ValidationVersionReviewed","LimRefNo","LimActiveDate","LimInActiveDate","LimSeverity","LimStatus","LimOriginator","ResRefNo","ResActiveDate","ResInActiveDate","ResStatus"}.ToList(); 
        List<string> exceptionInventory = new string[]{"ExtId","LOB","SubLOBName","ExceptionId","ExceptionCreatedBy","ExceptionCreatedDate","StartDate","Description","Status","ContinuationStatus","ExceptionStatusFlag","Reason","DateCreated","CreatedOn","ActionResolution","IndividualResponsible","OriginalResolutionDeadline","ResDeadline","CurrentResolutionDeadline","NewResDeadline","ModelPerformance","LOBComments","SystemDate","MORODecision","MoROOriginalApprovalDate","MORODecisionDate","MORODecisionBy","MOROComments","CFMODecision","CFMOOriginalApprovalDate","CFMODecisionDate","CFMODecisionBy","CFMOComments","CMORDecision","CMOROriginalApprovalDate","CMORDecisionDate","CMORDecisionBy","CMORComments","CMORGovDecision","CMORGovOriginalApprovalDate","CMORGovDecisionDate","CMORGovDecisionBy","CMORGovComments","ContinuationCounter","CMOR","CMORGovernance","CloseDate","ClosedComments","CanceledComments","AdditionalLOBComments","QTMRegulatoryReportingType","QTMRegulatoryReportingUses","Id","QTMNumber","QTMName","SegmentName","DevelopmentValidationCategory","OtherQTMUses","StressIndicator","ImplementationDate","ValidationDate","ValidatedBy","AnnualReviewDate","AnnualReviewBy","AnnualReviewResult","AnnualReviewComments","LOBsUsingQTM","QTMUsers","RiskRankApprovedDate","CMoRRiskRankComments","CertificationDate","CertificationBy","RetiredQTMComments","EconomicVariables","ACLRatings","Developers","Version","LastRevisionDate","IssuesStatusFlag","ApprovalDates","ApprovalComments","PerformanceMonitoringMetric","AttestedDate","AttestationComments","NumberofModelsinScorecardSuite","ModelRiskScore","CMoRModelRating","AddDate","CreditScoringModelType","CurrentApprovalStatus","RiskRankId","CMoR1","CMoR2","LOB1","LOB2","LOB3","Groups","QTMDescription","MonitoringStatus","MonitoringProgramReferenceNumber","ModelPerformanceReviewResult","LOBGovernance","CMoRPerformanceReviewer","MonitoringLead","ApprovedQTMUses","QTMLimitations","ApprovedQTMUseDetails","QTMRestrictions","ApprovalStatus","ApprovalCategory","ApprovalDate","DeepDiveReview","AnnualRiskRankAssessmentDate","AnnualRiskRankAssessmentResults","QTMChildren","QTMIDStatus","ModelLifeCycleStatus","QTMParents","QTMUses","RABU","RetiredQTM","RetiredComments","RetiredDate","QTMOwner","CFMO","ModelRiskOfficer","ReviewPeriod","FinalApprovedRiskRank","ValidationResult","ValidationBy","ValidationActivity","Validators","VendorModel","ThirdPartyVendorName","VendorEngagementId","VersionReviewed","HistoricalModelNumber","CertificationComments","LoBRecoRiskRank","NextAnnualReviewDate","NextValidationDate","ValidationComment","ValidationVersionReviewed","QTMDescription","RiskRankApprovalDate","Version","SegmentName","ModelRiskScore","ImplementationDate","LastRevisionDate","LOB1","LOB2","LOB3","CMoR1","CMoR2","ACLRatings","AnnualReviewBy","AnnualReviewDate","AnnualReviewResult","ApprovalCategory","ApprovalDate","ApprovalStatus","ApprovalComments","AttestedDate","AttestationComments","CMoRPerformanceReviewer","CCARMidCycleStressIndicator","CertificationBy","CertificationDate","CMoRRiskRankComments","CreditScoringQTMType","Developers","EconomicVariables","IssueStatusFlag","Groups","LOBsUsingQTM","ModelPerformanceReviewResult","MonitoringLead","MonitoringProgramReferenceNumber"}.ToList();
        List<string> issuesInventory = new string[]{"Id","IssueStatus","ReferenceNumber","IssueSource","IssueSeverity","RiskRankFinalApproval","RiskRankCMORApproved","QTMNumber","LOB","Issue","ValidationComment","ValidationVersionReviewed","LOBIssueStatusDate","IssueStatusDate","LOBStatusUpdate","IssueOriginatorStatusDate","RemediationStatus","IssueOpenedDate","IssueClosedDate","IssueType","IssueOriginatorRecommendations","LOBIssueContact_CICAT","LOBIssueContact_s","OriginalLOBCommitmentDate","PreviousLOBCommitmentDate","CurrentLOBCommitmentDate","LOBRecommendation","IssueOriginator","OriginalIssueOriginatorCommitmentDate","PreviousIssueOriginatorCommitmentDate","CurrentIssueOriginatorCommitmentDate","LOBActionPlan_CommitmentDateReview","RemediationAssessment","CICATIssueID","ReviewTitle","ReviewingEntity","ReportDate","ReviewRating","IssueCategory","IssueOriginatorCommitmentDateExtended","LOBCommitmentDateExtended","CurrentClosurePlanStatus","QTMName","CFMO","SubLOB","SegmentName","HistoricalModelNumber","QTMUses","ACLRatings","AnnualReviewDate","AnnualReviewBy","AnnualReviewResult","AnnualReviewComments","AnnualReviewVersionReviewed","ApprovalDates","ApprovalComments","AttestedDate","AttestationComments","StressIndicator","CertificationDate","CertificationBy","CertificationComments","CMORRankComment","CMOR1","CMOR2","CreditScoringQTMType","CurrentApprovalStatus","Developers","EconomicVariables","Groups","ImplementationDate","LastRevisionDate","LoBsUsingQTM","LOB1","LOB2","LOB3","ModelPerformanceReviewResult","ModelRiskOfficer","ModelRiskScore","MonitoringLead","MonitoringStatus","MonitoringStatus","MonitoringProgramReferenceNumber","NextAnnualReviewDate","NextValidationDate","ValidationComment","ValidationVersionReviewed","NoModelsScoreCardSuite","QTMChildren","QTMDescription","ModelLifeCycleStatus","QTMParents","QTMUsers","RABU","RetiredDate","RetiredComment","ReviewPeriod","RiskRankFinalApproval","RiskRankLOBRecommended","RiskRankApprovedDate","SystemDate","ValidationDate","DeepDiveReview","Validators","ValidatedBy","ValidationResult","IsVendor","ThirdPartyVendorName","VendorEngagementId","Version","EmailResponsibleParties","LOBGovernance","QTMRegulatoryReportingType","QTMRegulatoryReportingUses","ApprovedQTMUses","ApprovedQTMUseDetails","QTMRestrictions","QTMLimitations","LOBCommitmentDateExtendedCount","IssueOriginatorCommitmentDateExtendedCount","ApprovalStatus","ApprovalCategory","IssuesStatusFlag","OpenExceptionIndicator","QTMIDStatus","ValidationActivity","AnnualRiskRankAssessmentDate","AnnualRiskRankAssessmentResults"}.ToList();
        
        List<string> baseInventory = new string[]{"annualreviewversionreviewed","annualriskrankassessmentresults","cicatissueid","cmorrankcomment","creditscoringqtmtype","currentclosureplanstatus","emailresponsibleparties","issue","issuecategory","issueoriginator","issueoriginatorcommitmentdateextended","issueoriginatorcommitmentdateextendedcount","issueoriginatorrecommendations","issueseverity","issuesource","issuestatus","issuetype","isvendor","lobcommitmentdateextended","lobcommitmentdateextendedcount","lobissuecontactcicat","lobissuecontact","lobrecommendation","lobstatusupdate","nomodelsscorecardsuite","referencenumber","remediationassessment","remediationstatus","retiredcomment","reviewingentity","reviewrating","reviewtitle","riskrankcmorapproved","riskrankfinalapproval","riskranklobrecommended","qtmparents","qtmchildren","qtmnumber","lob","qtmname","sublob","segmentname","historicalmodelnumber","stressindicator","validationactivity","validators","validatedby","validationresult","validationcomment","validationversionreviewed","deepdivereview","annualreviewby","annualreviewresult","annualreviewcomments","lobsusingqtm","qtmusers","certificationby","certificationcomments","economicvariables","aclratings","modellifecyclestatus","developers","version","issuesstatusflag","openexceptionindicator","approvalcomments","attestationcomments","thirdpartyvendorname","vendorengagementid","modelriskofficer","modelriskscore","rabu","currentapprovalstatus","cfmo","cmor1","cmor2","lob1","lob2","lob3","groups","qtmdescription","monitoringlead","monitoringstatus","monitoringprogramreferencenumber","qtmidstatus","reviewperiod","modelperformancereviewresult","lobgovernance","approvalstatus","approvalcategory","qtmregulatoryreportingtype","qtmregulatoryreportinguses","approvedqtmuses","approvedqtmusedetails","qtmrestrictions","qtmlimitations"}.ToList();
        Console.WriteLine("BaseInventory = " + baseInventory.Count()  + "   ExceptionInventory = " + exceptionInventory.Count());
            
            
        var exceptList1 = exceptionInventory.Except(baseInventory,StringComparer.OrdinalIgnoreCase).ToList();
            
            foreach(var item in exceptList1.ToList())
            {
                Console.WriteLine(item);
            }
        
            
            Console.WriteLine("==============");
            
            
            var exceptList2 = exceptionInventory.Except(issuesInventory,StringComparer.OrdinalIgnoreCase).ToList();
            
              foreach(var item in exceptList2.ToList())
            {
               // Console.WriteLine(item);
            }
            
        }
    }
}


run \| edit \| history \| help	0

λ

                                      .NET NoSQL database for rapid development