/// <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);
}
}