/// <summary>
/// Imports the subsequence stored in the database
/// </summary>
/// <param name="frame"></param>
private void importInitialValues(DataDictionary.Tests.SubSequence subSequence, int subSequenceID)
{
// Level is a reserved word...
string sql = "SELECT D_LRBG, TSW_TestSeqSCItl.Level, Mode, NID_LRBG, Q_DIRLRBG, Q_DIRTRAIN, Q_DLRBG, RBC_ID, RBCPhone FROM TSW_TestSeqSCItl WHERE TestSequenceID = " + subSequenceID;
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, Connection);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables.Count > 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
int i = 0;
string D_LRBG = dataRow.ItemArray.GetValue(i++) as string;
string Level = dataRow.ItemArray.GetValue(i++) as string;
string Mode = dataRow.ItemArray.GetValue(i++) as string;
string NID_LRBG = dataRow.ItemArray.GetValue(i++) as string;
string Q_DIRLRBG = dataRow.ItemArray.GetValue(i++) as string;
string Q_DIRTRAIN = dataRow.ItemArray.GetValue(i++) as string;
string Q_DLRBG = dataRow.ItemArray.GetValue(i++) as string;
string RBC_ID = dataRow.ItemArray.GetValue(i++) as string;
string RBCPhone = dataRow.ItemArray.GetValue(i++) as string;
subSequence.setD_LRBG(D_LRBG);
subSequence.setLevel(Level);
subSequence.setMode(Mode);
subSequence.setNID_LRBG(NID_LRBG);
subSequence.setQ_DIRLRBG(Q_DIRLRBG);
subSequence.setQ_DIRTRAIN(Q_DIRTRAIN);
subSequence.setQ_DLRBG(Q_DLRBG);
subSequence.setRBC_ID(RBC_ID);
subSequence.setRBCPhone(RBCPhone);
DataDictionary.Tests.TestCase testCase = (DataDictionary.Tests.TestCase)DataDictionary.Generated.acceptor.getFactory().createTestCase();
testCase.Name = "Setup";
subSequence.appendTestCases(testCase);
DataDictionary.Tests.Step initializeTrainDataStep = (DataDictionary.Tests.Step)DataDictionary.Generated.acceptor.getFactory().createStep();;
initializeTrainDataStep.setTCS_Order(0);
initializeTrainDataStep.setDistance(0);
initializeTrainDataStep.setDescription("Initialize train data");
initializeTrainDataStep.setTranslationRequired(true);
testCase.appendSteps(initializeTrainDataStep);
DataDictionary.Tests.Step setupStep = (DataDictionary.Tests.Step)DataDictionary.Generated.acceptor.getFactory().createStep();;
setupStep.setTCS_Order(0);
setupStep.setDistance(0);
setupStep.setDescription("Setup test sequence");
setupStep.setTranslationRequired(true);
testCase.appendSteps(setupStep);
DataDictionary.Tests.Step manualSetupStep = (DataDictionary.Tests.Step)DataDictionary.Generated.acceptor.getFactory().createStep();;
manualSetupStep.setTCS_Order(0);
manualSetupStep.setDistance(0);
manualSetupStep.setDescription("Manual setup test sequence");
manualSetupStep.setTranslationRequired(true);
testCase.appendSteps(manualSetupStep);
}
}
else
{
Log.Error("Cannot find entry in table TSW_TestSeqSCItl WHERE TestSequenceID = " + subSequenceID);
}
}
/// <summary>
/// Imports the steps in a sub sequence
/// </summary>
/// <param name="subSequence"></param>
private void importSteps(DataDictionary.Tests.SubSequence subSequence)
{
string sql = "SELECT TCSOrder, Distance, FT_NUMBER, TC_NUMBER, ST_STEP, ST_DESCRIPTION, UserComment, ST_IO, ST_INTERFACE, ST_COMMENTS, TestLevelIn, TestLevelOut, TestModeIn, TestModeOut FROM TSW_TCStep ORDER BY TCSOrder";
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, Connection);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables.Count > 0)
{
DataDictionary.Tests.TestCase testCase = null;
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
object[] items = dataRow.ItemArray;
int order = (int)items[0];
int distance = (int)items[1];
int feature = (int)items[2];
int testCaseNr = (int)items[3];
string stepType = items[4] as string;
string description = items[5] as string;
string userComment = items[6] as string;
string io = items[7] as string;
string intrface = items[8] as string;
string comment = items[9] as string;
string testLevelIn = items[10] as string;
string testLevelOut = items[11] as string;
string testModeIn = items[12] as string;
string testModeOut = items[13] as string;
// we do not want to import steps "Followed by" or "Preceded by"
if (io != null && stepType != null && !stepType.Equals("Followed by") && !stepType.Equals("Preceded by"))
{
if (testCase != null)
{
if (testCase.getFeature() != feature || testCase.getCase() != testCaseNr)
{
testCase = null;
}
}
if (testCase == null)
{
testCase = (DataDictionary.Tests.TestCase)DataDictionary.Generated.acceptor.getFactory().createTestCase();
testCase.Name = "Feature " + feature + " Test case " + testCaseNr;
testCase.setCase(testCaseNr);
testCase.setFeature(feature);
subSequence.appendTestCases(testCase);
}
DataDictionary.Tests.Step step = (DataDictionary.Tests.Step)DataDictionary.Generated.acceptor.getFactory().createStep();
step.Name = "Step " + order;
step.setTCS_Order(order);
step.setDistance(distance);
step.setDescription(description);
step.setUserComment(userComment);
step.setIO_AsString(io);
if (intrface != null)
{
step.setInterface_AsString(intrface);
}
step.setComment(comment);
if (testLevelIn != null)
{
step.setLevelIN_AsString(testLevelIn);
}
if (testLevelOut != null)
{
step.setLevelOUT_AsString(testLevelOut);
}
if (testModeIn != null)
{
step.setModeIN_AsString(testModeIn);
}
if (testModeOut != null)
{
step.setModeOUT_AsString(testModeOut);
}
step.setTranslationRequired(true);
importStepMessages(step);
testCase.appendSteps(step);
}
}
}
else
{
Log.Error("Cannot find sub sequence table in database");
}
}
/// <summary>
/// Imports the subsequence stored in the database
/// </summary>
/// <param name="subSequence"></param>
/// <param name="subSequenceId"></param>
private void ImportInitialValues(SubSequence subSequence, int subSequenceId)
{
// Level is a reserved word...
string sql =
"SELECT D_LRBG, TSW_TestSeqSCItl.Level, Mode, NID_LRBG, Q_DIRLRBG, Q_DIRTRAIN, Q_DLRBG, RBC_ID, RBCPhone FROM TSW_TestSeqSCItl WHERE TestSequenceID = " +
subSequenceId;
OleDbDataAdapter adapter = new OleDbDataAdapter(sql, Connection);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables.Count > 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
int i = 0;
// ReSharper disable InconsistentNaming
string D_LRBG = dataRow.ItemArray.GetValue(i++) as string;
string Level = dataRow.ItemArray.GetValue(i++) as string;
string Mode = dataRow.ItemArray.GetValue(i++) as string;
string NID_LRBG = dataRow.ItemArray.GetValue(i++) as string;
string Q_DIRLRBG = dataRow.ItemArray.GetValue(i++) as string;
string Q_DIRTRAIN = dataRow.ItemArray.GetValue(i++) as string;
string Q_DLRBG = dataRow.ItemArray.GetValue(i++) as string;
string RBC_ID = dataRow.ItemArray.GetValue(i++) as string;
string RBCPhone = dataRow.ItemArray.GetValue(i++) as string;
// ReSharper restore InconsistentNaming
subSequence.setD_LRBG(D_LRBG);
subSequence.setLevel(Level);
subSequence.setMode(Mode);
subSequence.setNID_LRBG(NID_LRBG);
subSequence.setQ_DIRLRBG(Q_DIRLRBG);
subSequence.setQ_DIRTRAIN(Q_DIRTRAIN);
subSequence.setQ_DLRBG(Q_DLRBG);
subSequence.setRBC_ID(RBC_ID);
subSequence.setRBCPhone(RBCPhone);
TestCase testCase = (TestCase)acceptor.getFactory().createTestCase();
testCase.Name = "Setup";
subSequence.appendTestCases(testCase);
Step initializeTrainDataStep = (Step)acceptor.getFactory().createStep();
initializeTrainDataStep.setTCS_Order(0);
initializeTrainDataStep.setDistance("0");
initializeTrainDataStep.setDescription("Initialize train data");
initializeTrainDataStep.setTranslationRequired(true);
testCase.appendSteps(initializeTrainDataStep);
Step defaultValuesStep = (Step)acceptor.getFactory().createStep();
defaultValuesStep.setTCS_Order(0);
defaultValuesStep.setDistance("0");
defaultValuesStep.setDescription("Set default values");
defaultValuesStep.setTranslationRequired(true);
testCase.appendSteps(defaultValuesStep);
Step manualSetupStep = (Step)acceptor.getFactory().createStep();
manualSetupStep.setTCS_Order(0);
manualSetupStep.setDistance("0");
manualSetupStep.setDescription("Manual setup test sequence");
manualSetupStep.setTranslationRequired(false);
testCase.appendSteps(manualSetupStep);
}
}
else
{
throw new Exception("Cannot find entry in table TSW_TestSeqSCItl WHERE TestSequenceID = " + subSequenceId);
}
}