/// <summary>
/// Imports the subsequence stored in the database
/// </summary>
/// <param name="frame"></param>
private void importSubSequence(DataDictionary.Tests.Frame frame)
{
string sql = "SELECT TestSequenceID, TestSequenceName FROM TSW_TestSequence";
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 subSequenceID = (int)dataRow.ItemArray.GetValue(0);
string subSequenceName = (string)dataRow.ItemArray.GetValue(1);
DataDictionary.Tests.SubSequence newSubSequence = (DataDictionary.Tests.SubSequence)DataDictionary.Generated.acceptor.getFactory().createSubSequence();
newSubSequence.Name = subSequenceName;
importInitialValues(newSubSequence, subSequenceID);
importSteps(newSubSequence);
DataDictionary.Tests.SubSequence oldSubSequence = frame.findSubSequence(subSequenceName);
if (oldSubSequence != null)
{
int cnt = 0;
foreach (DataDictionary.Tests.TestCase oldTestCase in oldSubSequence.TestCases)
{
if (cnt < newSubSequence.TestCases.Count)
{
DataDictionary.Tests.TestCase newTestCase = newSubSequence.TestCases[cnt] as DataDictionary.Tests.TestCase;
if (newTestCase != null)
{
if (oldTestCase.Name.Equals(newTestCase.Name))
{
newTestCase.Merge(oldTestCase);
}
else
{
throw new Exception(newTestCase.FullName + " is found instead of " + oldTestCase.FullName + " while importing sub-sequence " + newSubSequence.FullName);
}
}
}
else
{
throw new Exception("The test case " + oldTestCase.FullName + " is not present in the new data base");
}
cnt++;
}
oldSubSequence.Delete();
}
frame.appendSubSequences(newSubSequence);
}
}
else
{
Log.Error("Cannot find table TSW_TestSequence in database");
}
}
/// <summary>
/// Imports the subsequence stored in the database
/// </summary>
/// <param name="frame"></param>
/// <param name="keepManualTranslations">Indicates that manual translation for be kept during import</param>
private void ImportSubSequence(Frame frame, bool keepManualTranslations)
{
const string sql = "SELECT TestSequenceID, TestSequenceName FROM TSW_TestSequence";
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 subSequenceId = (int)dataRow.ItemArray.GetValue(0);
string subSequenceName = (string)dataRow.ItemArray.GetValue(1);
SubSequence newSubSequence = (SubSequence)acceptor.getFactory().createSubSequence();
newSubSequence.Name = subSequenceName;
ImportInitialValues(newSubSequence, subSequenceId);
ImportSteps(newSubSequence);
newSubSequence.setCompleted(false);
SubSequence previousSubSequence = frame.findSubSequence(subSequenceName);
if (previousSubSequence != null)
{
newSubSequence.setGuid(previousSubSequence.getGuid());
newSubSequence.setCompleted(previousSubSequence.getCompleted());
int cnt = 0;
foreach (TestCase previousTestCase in previousSubSequence.TestCases)
{
if (cnt < newSubSequence.TestCases.Count)
{
TestCase newTestCase = newSubSequence.TestCases[cnt] as TestCase;
if (newTestCase != null)
{
if (previousTestCase.Name.Equals(newTestCase.Name))
{
newTestCase.Merge(previousTestCase, keepManualTranslations);
}
else
{
throw new Exception(newTestCase.FullName + " is found instead of " +
previousTestCase.FullName + " while importing sub-sequence " +
newSubSequence.FullName);
}
}
}
else
{
throw new Exception("The test case " + previousTestCase.FullName +
" is not present in the new data base");
}
cnt++;
}
previousSubSequence.Delete();
}
frame.appendSubSequences(newSubSequence);
}
}
else
{
throw new Exception("Cannot find table TSW_TestSequence in database");
}
}