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...");
}