public List <ContractRequirement> GatherAndWriteContractRequirementToDb() { ContractAndMectRequirementExcelTools contractAndMectRequirementTools = new ContractAndMectRequirementExcelTools(_props); List <ContractRequirement> allContractRequirement = contractAndMectRequirementTools.GatherContractRequirements(); return(allContractRequirement); }
public void Setup() { Logger logger = new Logger(); string path = AppDomain.CurrentDomain.BaseDirectory; PropertiesReader config = new PropertiesReader("Data\\config.txt"); Properties props = new Properties { PersonalAccessToken = config.get("personalaccesstoken"), TestPlanId = Convert.ToInt32(config.get("testplanid")), TestSuiteId = Convert.ToInt32(config.get("testsuiteid")), Project = config.get("project"), Uri = config.get("server"), SaveLocation = path + "\\Output\\", FileName = StringTools.addExtension(config.get("fileName"), "xlsx") }; props.ExecutionSheetName = config.get("executionsheetname"); props.ScriptSheetName = config.get("scriptsheetname"); props.Logger = logger; _contractAndMectRequirementExcelTools = new ContractAndMectRequirementExcelTools(props); }
public List <ContractRequirement> UpdateContractRequirementsAndAllLinks() { ContractAndMectRequirementExcelTools contractAndMectRequirementTools = new ContractAndMectRequirementExcelTools(_props); List <ContractRequirement> allContractRequirement = contractAndMectRequirementTools.GatherContractRequirements(); UpdateContractRequirement updateContractRequirement = new UpdateContractRequirement(_props); List <ContractRequirement> res = updateContractRequirement.UpdateContractRequirementsAndAllLinks(allContractRequirement).Result; return(res); }
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..."); }