/// <summary>
/// Imports the paragraphs from the provided worksheet to the provided chapter
/// </summary>
/// <param name="aChapter"></param>
/// <param name="aWorksheet"></param>
private void importParagraphs(Chapter aChapter, string chapterId, Worksheet aWorksheet)
{
Range aRange = aWorksheet.UsedRange;
int paragraphId = 1;
string text = "";
bool skipRow = false;
for (int i = 2; i <= aRange.Rows.Count; i++)
{
string specId = (string)(aRange.Cells[i, 1] as Range).Value2;
if (specId != null)
{
// Create the new paragraph
Paragraph aParagraph = (Paragraph)acceptor.getFactory().createParagraph();
aParagraph.setId(chapterId + "." + paragraphId.ToString());
paragraphId++;
aParagraph.setType(acceptor.Paragraph_type.aNOTE);
aParagraph.setImplementationStatus(acceptor.SPEC_IMPLEMENTED_ENUM.Impl_NotImplementable);
// Add the requirement set "Onboard"
aParagraph.setObsoleteScopeOnBoard(false);
aParagraph.setObsoleteScopeTrackside(false);
RequirementSetReference requirementSetReference =
(RequirementSetReference)acceptor.getFactory().createRequirementSetReference();
RequirementSet requirementSet = TheDictionary.findRequirementSet("Scope", false);
if (requirementSet != null)
{
requirementSet = requirementSet.findRequirementSet("Onboard", false);
if (requirementSet != null)
{
requirementSetReference.setTarget(requirementSet.Guid);
aParagraph.appendRequirementSets(requirementSetReference);
}
else
{
throw new Exception("Requirement set Onboard not found");
}
}
else
{
throw new Exception("Requirement set Scope not found");
}
// Add the paragraph to the chapter
aChapter.appendParagraphs(aParagraph);
// Create of the text of paragraph
aParagraph.Text = (string)(aRange.Cells[i, 2] as Range).Value2 + "\n"; // description
text = (string)(aRange.Cells[i, 6] as Range).Value2; // start condition
if (text != null)
{
aParagraph.Text += "START: " + text + "\n";
if (specId.Equals((string)(aRange.Cells[i + 1, 1] as Range).Value2))
// the following element can give the stop condition for the current element
{
text = (string)(aRange.Cells[i + 1, 7] as Range).Value2; // stop condition
if (text != null)
{
aParagraph.Text += "STOP: " + text + "\n";
skipRow = true;
// the remaining information of the following document is identical => let's skip it
}
}
}
text = (string)(aRange.Cells[i, 7] as Range).Value2; // stop condition
if (text != null)
{
aParagraph.Text += "STOP: " + text + "\n";
}
text = (string)(aRange.Cells[i, 8] as Range).Value2; // comment
if (text != null)
{
aParagraph.Text += "Comment: " + text + "\n";
}
// Create the reference to a paragraph from Subset-026
Specification subset026 = findSubset026Specification();
specId = specId.Replace(" ", ".");
Paragraph refParagraph = subset026.FindParagraphByNumber(specId);
if (refParagraph != null)
{
ReqRef aReqRef = (ReqRef)acceptor.getFactory().createReqRef();
aReqRef.Paragraph = aParagraph;
refParagraph.appendRequirements(aReqRef);
}
else
{
aParagraph.Text += "SUBSET-026 REFERENCE: " + specId + "\n";
}
// DMI references
text = (string)(aRange.Cells[i, 3] as Range).Value2; // DMI object
if (text != null)
{
aParagraph.Text += "DMI OBJECT: " + text + "\n";
text = (string)(aRange.Cells[i, 4] as Range).Value2; // DMI area
if (text != null)
{
aParagraph.Text += "DMI AREA: " + text + "\n";
object reference = (aRange.Cells[i, 5] as Range).Value2; // DMI reference
if (reference != null)
{
aParagraph.Text += "DMI REFERENCE: " + reference.ToString();
}
}
}
if (skipRow)
{
i++;
skipRow = false;
}
}
}
}
