private void ButtonSetupTestPlanAddTestCase_Click(object sender, EventArgs e)
{
if (ComboBoxSetupTestPlanTestArea.Text != "" && ComboBoxSetupTestPlanType.Text != "" && ComboBoxSetupTestPlanComponent.Text != "" && textBox1.Text != "")
{
TestPlan.AddTestCase(new TestCase(ComboBoxSetupTestPlanTestArea.Text, ComboBoxSetupTestPlanType.Text, ComboBoxSetupTestPlanComponent.Text, textBox1.Text));
LabelSetupTestPlanTestOutput.ForeColor = Color.LightGreen;
LabelSetupTestPlanTestOutput.Text = "Test case added successfully";
CurrentPanel.Refresh();
Thread.Sleep(2000);
LabelSetupTestPlanTestOutput.Text = "";
ComboBoxSetupTestPlanTestArea.Text = "";
ComboBoxSetupTestPlanType.Text = "";
ComboBoxSetupTestPlanComponent.Text = "";
textBox1.Text = "";
}
else
{
LabelSetupTestPlanTestOutput.ForeColor = Color.PaleVioletRed;
LabelSetupTestPlanTestOutput.Text = "Select an option for every field";
CurrentPanel.Refresh();
Thread.Sleep(2000);
LabelSetupTestPlanTestOutput.Text = "";
}
CurrentPanel = PanelSetupTestPlanContinuation;
}
public void LoadData(TestPlan _TestPlan)
{
// Test Plan General Information
if (App.Worksheets["Test Plan"].Range["E1"].Value != null)
{
_TestPlan.Name = App.Worksheets["Test Plan"].Range["E1"].Value.ToString();
}
else
{
_TestPlan.Name = "";
}
if (App.Worksheets["Test Plan"].Range["E5"].Value != null)
{
_TestPlan.Introduction = App.Worksheets["Test Plan"].Range["E5"].Value.ToString();
}
else
{
_TestPlan.Introduction = "";
}
if (App.Worksheets["Test Plan"].Range["E11"].Value != null)
{
_TestPlan.SetupEnvironment = App.Worksheets["Test Plan"].Range["E11"].Value.ToString();
}
else
{
_TestPlan.SetupEnvironment = "";
}
if (App.Worksheets["Test Plan"].Range["E15"].Value != null)
{
_TestPlan.Scope = App.Worksheets["Test Plan"].Range["E15"].Value.ToString();
}
else
{
_TestPlan.Scope = "";
}
if (App.Worksheets["Test Plan"].Range["E19"].Value != null)
{
_TestPlan.Fixes = App.Worksheets["Test Plan"].Range["E19"].Value.ToString();
}
else
{
_TestPlan.Fixes = "";
}
if (App.Worksheets["Test Plan"].Range["E23"].Value != null)
{
_TestPlan.Regression = App.Worksheets["Test Plan"].Range["E23"].Value.ToString();
}
else
{
_TestPlan.Regression = "";
}
// Test Cases
int row = 2;
TestCase tc = new TestCase();
while (App.Worksheets["Test Cases"].Range["A" + row.ToString()].Value != null)
{
tc.TestArea = App.Worksheets["Test Cases"].Range["A" + row.ToString()].Value.ToString();
tc.Component = App.Worksheets["Test Cases"].Range["B" + row.ToString()].Value.ToString();
tc.Type = App.Worksheets["Test Cases"].Range["C" + row.ToString()].Value.ToString();
tc.ID = App.Worksheets["Test Cases"].Range["D" + row.ToString()].Value.ToString();
if (App.Worksheets["Test Cases"].Range["E" + row.ToString()].Value != null)
{
tc.TestScenario = App.Worksheets["Test Cases"].Range["E" + row.ToString()].Value.ToString();
}
else
{
tc.TestScenario = "";
}
if (App.Worksheets["Test Cases"].Range["F" + row.ToString()].Value != null)
{
tc.Description = App.Worksheets["Test Cases"].Range["F" + row.ToString()].Value.ToString();
}
else
{
tc.Description = "";
}
if (App.Worksheets["Test Cases"].Range["G" + row.ToString()].Value != null)
{
tc.Tag = App.Worksheets["Test Cases"].Range["G" + row.ToString()].Value.ToString();
}
else
{
tc.Tag = "";
}
if (App.Worksheets["Test Cases"].Range["H" + row.ToString()].Value != null)
{
tc.PreConditions = App.Worksheets["Test Cases"].Range["H" + row.ToString()].Value.ToString();
}
else
{
tc.PreConditions = "";
}
if (App.Worksheets["Test Cases"].Range["I" + row.ToString()].Value != null)
{
tc.Steps = App.Worksheets["Test Cases"].Range["I" + row.ToString()].Value.ToString();
}
else
{
tc.Steps = "";
}
if (App.Worksheets["Test Cases"].Range["J" + row.ToString()].Value != null)
{
tc.ExpectedBehaviour = App.Worksheets["Test Cases"].Range["J" + row.ToString()].Value.ToString();
}
else
{
tc.ExpectedBehaviour = "";
}
if (App.Worksheets["Test Cases"].Range["K" + row.ToString()].Value != null)
{
tc.Status = App.Worksheets["Test Cases"].Range["K" + row.ToString()].Value.ToString();
}
else
{
tc.Status = "";
}
if (App.Worksheets["Test Cases"].Range["L" + row.ToString()].Value != null)
{
tc.Result = App.Worksheets["Test Cases"].Range["L" + row.ToString()].Value.ToString();
}
else
{
tc.Result = "";
}
if (App.Worksheets["Test Cases"].Range["M" + row.ToString()].Value != null)
{
tc.Notes = App.Worksheets["Test Cases"].Range["M" + row.ToString()].Value.ToString();
}
else
{
tc.Notes = "";
}
_TestPlan.AddTestCase(new TestCase(tc));
++row;
}
Workbook.Close(false);
App.Quit();
}