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