public void UpdateMectAndContractRequirementIdsToExcel()
        {
            GetWorkItemType            getWorkItemType      = new GetWorkItemType(_props);
            List <ContractRequirement> contractRequirements = getWorkItemType.GetContractRequirements();
            List <MectRequirement>     mectRequirements     = getWorkItemType.GetMectRequirements();

            ContractAndMectRequirementExcelTools contractAndMectRequirementTools = new ContractAndMectRequirementExcelTools(_props);

            contractAndMectRequirementTools.UpdateMectAndContractRequirementIds(contractRequirements, mectRequirements);
            contractAndMectRequirementTools.ExcelCleanup();
        }
        public void GatherAndWriteContractMectRequirementMappingToDb()
        {
            ContractAndMectRequirementExcelTools         contractAndMectRequirementTools = new ContractAndMectRequirementExcelTools(_props);
            List <ContractRequirementMectRequirementMap> contractMectRequirementMap      = contractAndMectRequirementTools.GatherContractRequirementMectMapping();

            contractAndMectRequirementTools.ExcelCleanup();

            Console.Write("Inserting Contract Requirement/Mect Requirement Map to DB... ");

            PostHelper <ContractRequirementMectRequirementMap>(contractMectRequirementMap, "/api/CrMrMap");

            Console.WriteLine("Finished Inserting Maps to DB...");
        }