public List <TestCase> GetTestCasesInSuite()
{
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(_props);
List <TestCase> allTestCasesInSuite = getTestCasesInSuite.GatherTestCases();
return(allTestCasesInSuite);
}
public TestCase GetSingleTestCase(int testCaseId, int suiteId)
{
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(_props);
TestCase singleTestCase = getTestCasesInSuite.GetSingleTestCase(testCaseId, suiteId).Result;
return(singleTestCase);
}
public List <TestCase> GetTestCaseGivenPlanSuite(int suite)
{
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(_props, 149579, suite);
List <TestCase> allTestCasesInSuite = getTestCasesInSuite.GatherTestCases();
return(allTestCasesInSuite);
}
public List <int> DeleteNonExistingTestsCases(List <TestCase> allTestCases = null)
{
List <int> deletedTestCases = new List <int>();
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(_props);
List <TestCase> allTestCasesInSuite;
if (allTestCases == null)
{
allTestCasesInSuite = getTestCasesInSuite.GatherTestCases();
}
else
{
allTestCasesInSuite = allTestCases;
}
List <int> allTestCaseIdInSuite = new List <int>();
foreach (TestCase curr in allTestCasesInSuite)
{
allTestCaseIdInSuite.Add(curr.TestCaseId);
}
TestCaseWebApiTools testCaseWebApiTools = new TestCaseWebApiTools();
List <int> allTestCasesInDb = testCaseWebApiTools.GetAllTestCaseIds().Result;
foreach (int currId in allTestCasesInDb)
{
if (!allTestCaseIdInSuite.Contains(currId))
{
deletedTestCases.Add(currId);
}
}
Console.WriteLine("Test");
Console.WriteLine(deletedTestCases.Count);
foreach (int curr in deletedTestCases)
{
Console.WriteLine(curr);
HttpClientInitiator client = new HttpClientInitiator("https://localhost:44369/");
HttpClient newClient = client.CreateHttpClient();
newClient.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
string requestUri = "/api/TestCase/" + curr;
var method = new HttpMethod("DELETE");
var request = new HttpRequestMessage(method, requestUri)
{
};
var response = newClient.SendAsync(request).Result;
}
return(deletedTestCases);
}
public void UpdateExcelExecutionInputData(Properties props)
{
List <TestCase> allTestCaseInSuite = new List <TestCase>();
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(props);
allTestCaseInSuite = getTestCasesInSuite.GatherTestCases();
UpdateExecutionInputData updateInputData = new UpdateExecutionInputData(props);
updateInputData.UpdateExcelExecutionInputData(allTestCaseInSuite);
updateInputData.ExcelCleanup();
}
public void UpdateExcelDefectWithTestCaseCount()
{
//GetTestCasesWebApi getTestCasesWebApi = new GetTestCasesWebApi();
//List<int> _allTestCaseIds = getTestCasesWebApi.GetAllTestCaseIds().Result;
DateTime earliestTime = new DateTime(2019, 4, 1);
GetDefectWithTestCaseCount getDefectWithTestCaseCount = new GetDefectWithTestCaseCount(_props);
List <Defect> res = getDefectWithTestCaseCount.DefectTestCaseCountTFS(earliestTime);
Console.WriteLine("BreakPoint");
if (_props.UseWebApi == 1)
{
Console.Write("Writing Defects to DB... ");
PostHelper <Defect>(res, "/api/Defect");
Console.WriteLine();
Console.WriteLine("Finished writing Defects to DB...");
}
else
{
Console.Write("Not using WebAPI. Not writing to DB... ");
}
List <TestCase> allTestCaseInSuite;
if (_props.UseWebApi == 1)
{
allTestCaseInSuite = GetTestCasesWebApi.GetAllTestCases().Result;
}
else
{
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(_props);
allTestCaseInSuite = getTestCasesInSuite.GatherTestCases();
}
List <Defect> defectsFromTFS = GetDefectWebApi.GetDefects().Result;
UpdateDefectWithTestCaseCount updateDefectWithTestCaseCount = new UpdateDefectWithTestCaseCount(_props);
updateDefectWithTestCaseCount.UpdateDefectOnlySheet(defectsFromTFS, earliestTime, true);
updateDefectWithTestCaseCount.UpdateTestCaseWithDefect(defectsFromTFS, allTestCaseInSuite);
updateDefectWithTestCaseCount.UpdateTfsProposed(defectsFromTFS);
updateDefectWithTestCaseCount.ExcelCleanup();
//AddDefectWebApi addDefectWebApi = new AddDefectWebApi();
//List<Defect> insertedDefects = addDefectWebApi.UpdateListDefects(res).Result;
//Console.WriteLine(res.Count);
}
public void UpdateTestsCasesInDB()
{
Console.WriteLine("Gathering Test Cases from Test Plan ID #" + _props.TestPlanId + ": ");
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(_props);
List <TestCase> allTestCasesInSuite = getTestCasesInSuite.GatherTestCases();
Console.WriteLine("Finished gathering Test Cases");
Console.WriteLine("Writing Test Cases into DB: ");
PostHelper <TestCase>(allTestCasesInSuite, "/api/TestCase");
Console.WriteLine("Finished inserting Test Cases to DB");
DeleteNonExistingTestsCases(allTestCasesInSuite);
}
public void UpdateExcelExecutionInputData()
{
List <TestCase> allTestCaseInSuite;
if (_props.UseWebApi == 1)
{
allTestCaseInSuite = GetTestCasesWebApi.GetAllTestCases().Result;
}
else
{
GetTestCasesInSuite getTestCasesInSuite = new GetTestCasesInSuite(_props);
allTestCaseInSuite = getTestCasesInSuite.GatherTestCases();
}
UpdateExecutionInputData updateInputData = new UpdateExecutionInputData(_props);
updateInputData.UpdateExcelExecutionInputData(allTestCaseInSuite);
updateInputData.ExcelCleanup();
}
