private void EditPieChartDatasets() { List <string> chartPie = new List <string>(); try { using (StreamReader sr = new StreamReader("..\\..\\..\\template\\assets\\chart-pie.js")) { string line; while ((line = sr.ReadLine()) != null) { chartPie.Add(line); } } } catch { NotifyLoadFile.ShowBalloonTip(100, "Error", "File is not available", ToolTipIcon.Error); } TestPlan.BuildResults(); chartPie[4] = "dataFunctionalNewFeatures = [" + TestPlan.FunctionalNewFeaturesResults[1].ToString() + ", " + TestPlan.FunctionalNewFeaturesResults[0].ToString() + "];"; chartPie[5] = "dataFunctionalEnhancements = [" + TestPlan.FunctionalEnhancementsResults[1].ToString() + ", " + TestPlan.FunctionalEnhancementsResults[0].ToString() + "];"; chartPie[6] = "dataNonFunctionalNewFeatures = [" + TestPlan.NonFunctionalNewFeaturesResults[1].ToString() + ", " + TestPlan.NonFunctionalNewFeaturesResults[0].ToString() + "];"; chartPie[7] = "dataNonFunctionalEnhancements = [" + TestPlan.NonFunctionalEnhancementsResults[1].ToString() + ", " + TestPlan.NonFunctionalEnhancementsResults[0].ToString() + "];"; using (StreamWriter sw = new StreamWriter("..\\..\\..\\template\\assets\\chart-pie.js")) { foreach (string line in chartPie) { sw.WriteLine(line); } } }
public void PerformChanges(TestPlan _TestPlan) { try { Clear(); _TestPlan.BuildDatasets(); _TestPlan.BuildResults(); // Test Plan General Information App.Worksheets["Test Plan"].Range["E1"].Value = _TestPlan.Name; App.Worksheets["Test Plan"].Range["E5"].Value = _TestPlan.Introduction; App.Worksheets["Test Plan"].Range["E11"].Value = _TestPlan.SetupEnvironment; App.Worksheets["Test Plan"].Range["E15"].Value = _TestPlan.Scope; App.Worksheets["Test Plan"].Range["E19"].Value = _TestPlan.Fixes; App.Worksheets["Test Plan"].Range["E23"].Value = _TestPlan.Regression; // Test Cases int row = 2; string range; _Excel.Range selectedCells; foreach (TestCase tc in _TestPlan.GetTestCasesReadOnly()) { App.Worksheets["Test Cases"].Range["A" + row.ToString()].Value = tc.TestArea; App.Worksheets["Test Cases"].Range["B" + row.ToString()].Value = tc.Component; App.Worksheets["Test Cases"].Range["C" + row.ToString()].Value = tc.Type; App.Worksheets["Test Cases"].Range["D" + row.ToString()].Value = tc.ID; App.Worksheets["Test Cases"].Range["E" + row.ToString()].Value = tc.TestScenario; App.Worksheets["Test Cases"].Range["F" + row.ToString()].Value = tc.Description; App.Worksheets["Test Cases"].Range["G" + row.ToString()].Value = tc.Tag; App.Worksheets["Test Cases"].Range["H" + row.ToString()].Value = tc.PreConditions; App.Worksheets["Test Cases"].Range["I" + row.ToString()].Value = tc.Steps; App.Worksheets["Test Cases"].Range["J" + row.ToString()].Value = tc.ExpectedBehaviour; App.Worksheets["Test Cases"].Range["K" + row.ToString()].Value = tc.Status; App.Worksheets["Test Cases"].Range["L" + row.ToString()].Value = tc.Result; App.Worksheets["Test Cases"].Range["M" + row.ToString()].Value = tc.Notes; range = "A" + row.ToString() + ":" + "M" + row.ToString(); selectedCells = App.Worksheets["Test Cases"].Range[range]; selectedCells.Borders.Color = Color.LightGray; selectedCells.Borders.Weight = 2; ++row; } // Passed - Failed App.Worksheets["Charts Data"].Range["A4"].Value = _TestPlan.FunctionalNewFeaturesResults[0]; App.Worksheets["Charts Data"].Range["B4"].Value = _TestPlan.FunctionalNewFeaturesResults[1]; App.Worksheets["Charts Data"].Range["C4"].Value = _TestPlan.FunctionalEnhancementsResults[0]; App.Worksheets["Charts Data"].Range["D4"].Value = _TestPlan.FunctionalEnhancementsResults[1]; App.Worksheets["Charts Data"].Range["E4"].Value = _TestPlan.NonFunctionalNewFeaturesResults[0]; App.Worksheets["Charts Data"].Range["F4"].Value = _TestPlan.NonFunctionalNewFeaturesResults[1]; App.Worksheets["Charts Data"].Range["G4"].Value = _TestPlan.NonFunctionalEnhancementsResults[0]; App.Worksheets["Charts Data"].Range["H4"].Value = _TestPlan.NonFunctionalEnhancementsResults[1]; // General Charts | A == 65, Q == 81. string[] functionalNF = _TestPlan.FunctionalNewFeatures.Split(','); string[] functionalEN = _TestPlan.FunctionalEnhancements.Split(','); string[] nonFunctionalNF = _TestPlan.NonFunctionalNewFeatures.Split(','); string[] nonFunctionalEN = _TestPlan.NonFunctionalEnhancements.Split(','); for (int i = 65; i < 82; ++i) { App.Worksheets["Charts Data"].Range[(char)i + "8"].Value = functionalNF[i - 65]; App.Worksheets["Charts Data"].Range[(char)i + "12"].Value = functionalEN[i - 65]; App.Worksheets["Charts Data"].Range[(char)i + "16"].Value = nonFunctionalNF[i - 65]; App.Worksheets["Charts Data"].Range[(char)i + "20"].Value = nonFunctionalEN[i - 65]; } App.ActiveWorkbook.Sheets[1].Select(); Workbook.Close(true); _TestPlan.ClearResults(); App.Quit(); } catch { App.Quit(); MainFormNotifyIcon.ShowBalloonTip(100, "Error", "An error occurred trying to save changes", ToolTipIcon.Error); } }