/// <summary>
/// Imports the subsequence stored in the database
/// </summary>
/// <param name="frame"></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;
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);
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
{
Log.Error("Cannot find entry in table TSW_TestSeqSCItl WHERE TestSequenceID = " + subSequenceID);
}
}
/// <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 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);
}
}