| public Add_Child ( string NewSegment, int NewWebContentID = null ) : SobekCM.Core.WebContent.Hierarchy.WebContent_Hierarchy_Node | ||
| NewSegment | string | Segment name for this element with the web content hierarchy |
| NewWebContentID | int | [Optional] Primary key for this web content page, from the database |
| return | SobekCM.Core.WebContent.Hierarchy.WebContent_Hierarchy_Node | |
/// <summary> Gets the hierarchy of all global content pages AND redirects, used for looking for a match from a requested URL </summary>
/// <param name="ReturnValue"> Web content hierarchy object to populate - should be pre-cleared </param>
/// <param name="Tracer"> Trace object keeps a list of each method executed and important milestones in rendering </param>
/// <returns> Flag indicating if this ran successfully, TRUE if successful, otherwise FALSE </returns>
/// <remarks> This calls the 'SobekCM_WebContent_All_Brief' stored procedure </remarks>
public static bool WebContent_Populate_All_Hierarchy(WebContent_Hierarchy ReturnValue, Custom_Tracer Tracer)
{
if (Tracer != null)
{
Tracer.Add_Trace("Engine_Database.WebContent_Populate_All_Hierarchy", "Gets the hierarchy tree of all content pages and redirects");
}
try
{
// Create the database agnostic reader
EalDbReaderWrapper readerWrapper = EalDbAccess.ExecuteDataReader(DatabaseType, Connection_String, CommandType.StoredProcedure, "SobekCM_WebContent_All_Brief");
// Get ready to step through all the rows returned from the reader
WebContent_Hierarchy_Node[] list = new WebContent_Hierarchy_Node[7];
// Read through each milestone
DbDataReader reader = readerWrapper.Reader;
while (readerWrapper.Reader.Read())
{
// Grab the values out
string redirect = (!reader.IsDBNull(9)) ? reader.GetString(9) : null;
int id = reader.GetInt32(0);
// Handle the first segment
string segment1 = reader.GetString(1);
if ((list[0] == null) || (String.Compare(list[0].Segment, segment1, StringComparison.OrdinalIgnoreCase) != 0))
{
// Build the node and add to the root nodes
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment1, id, redirect);
ReturnValue.Add_Child( newNode );
// If there are additional non-null segments, than this node does not represent the
// actual node that corresponds to this web content page or redirect
if (!reader.IsDBNull(2))
newNode.WebContentID = -1;
// Also save in the right spot in the list and clear the next level
list[0] = newNode;
list[1] = null;
}
// If there is a second segment here, handle that
if (!reader.IsDBNull(2))
{
string segment2 = reader.GetString(2);
// Is this a new segment 2 value?
if ((list[1] == null) || (String.Compare(list[1].Segment, segment2, StringComparison.OrdinalIgnoreCase) != 0))
{
// Build the node and add to the current parent node
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment2, id, redirect);
list[0].Add_Child(newNode);
// If there are additional non-null segments, than this node does not represent the
// actual node that corresponds to this web content page or redirect
if (!reader.IsDBNull(3))
newNode.WebContentID = -1;
// Also save in the right spot in the list and clear the next level
list[1] = newNode;
list[2] = null;
}
// Is there a third segment to add as well
if (!reader.IsDBNull(3))
{
string segment3 = reader.GetString(3);
// Is this a new segment 3 value?
if ((list[2] == null) || (String.Compare(list[2].Segment, segment3, StringComparison.OrdinalIgnoreCase) != 0))
{
// Build the node and add to the current parent node
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment3, id, redirect);
list[1].Add_Child(newNode);
// If there are additional non-null segments, than this node does not represent the
// actual node that corresponds to this web content page or redirect
if (!reader.IsDBNull(4))
newNode.WebContentID = -1;
// Also save in the right spot in the list and clear the next level
list[2] = newNode;
list[3] = null;
}
// Is there a fourth segment to add as well
if (!reader.IsDBNull(4))
{
string segment4 = reader.GetString(4);
// Is this a new segment 4 value?
if ((list[3] == null) || (String.Compare(list[3].Segment, segment4, StringComparison.OrdinalIgnoreCase) != 0))
{
// Build the node and add to the current parent node
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment4, id, redirect);
list[2].Add_Child(newNode);
// If there are additional non-null segments, than this node does not represent the
// actual node that corresponds to this web content page or redirect
if (!reader.IsDBNull(5))
newNode.WebContentID = -1;
// Also save in the right spot in the list and clear the next level
list[3] = newNode;
list[4] = null;
}
// Is there a fifth segment to add as well
if (!reader.IsDBNull(5))
{
string segment5 = reader.GetString(5);
// Is this a new segment 5 value?
if ((list[4] == null) || (String.Compare(list[4].Segment, segment5, StringComparison.OrdinalIgnoreCase) != 0))
{
// Build the node and add to the current parent node
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment5, id, redirect);
list[3].Add_Child(newNode);
// If there are additional non-null segments, than this node does not represent the
// actual node that corresponds to this web content page or redirect
if (!reader.IsDBNull(6))
newNode.WebContentID = -1;
// Also save in the right spot in the list and clear the next level
list[4] = newNode;
list[5] = null;
}
// Is there a sixth segment to add as well
if (!reader.IsDBNull(6))
{
string segment6 = reader.GetString(6);
// Is this a new segment 6 value?
if ((list[5] == null) || (String.Compare(list[5].Segment, segment6, StringComparison.OrdinalIgnoreCase) != 0))
{
// Build the node and add to the current parent node
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment6, id, redirect);
list[4].Add_Child(newNode);
// If there are additional non-null segments, than this node does not represent the
// actual node that corresponds to this web content page or redirect
if (!reader.IsDBNull(7))
newNode.WebContentID = -1;
// Also save in the right spot in the list and clear the next level
list[5] = newNode;
list[6] = null;
}
// Is there a seventh segment to add as well
if (!reader.IsDBNull(7))
{
string segment7 = reader.GetString(7);
// Is this a new segment 7 value?
if ((list[6] == null) || (String.Compare(list[6].Segment, segment7, StringComparison.OrdinalIgnoreCase) != 0))
{
// Build the node and add to the current parent node
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment7, id, redirect);
list[5].Add_Child(newNode);
// If there are additional non-null segments, than this node does not represent the
// actual node that corresponds to this web content page or redirect
if (!reader.IsDBNull(8))
newNode.WebContentID = -1;
// Also save in the right spot in the list.. no next level to clear
list[6] = newNode;
}
// Is there an eigth segment? (Will always be a new one since the bottom of the unique hierarchy list)
if (!reader.IsDBNull(8))
{
string segment8 = reader.GetString(8);
// Build the node and add to the current parent node
WebContent_Hierarchy_Node newNode = new WebContent_Hierarchy_Node(segment8, id, redirect);
list[6].Add_Child(newNode);
// Note, this last node always represents the web content page or redirect if
// it made it this far. No need to check next level and assign id to -1 if not null
}
}
}
}
}
}
}
}
// Close the reader (which also closes the connection)
readerWrapper.Close();
// Return the built list
return true;
}
catch (Exception ee)
{
Last_Exception = ee;
if (Tracer != null)
{
Tracer.Add_Trace("Engine_Database.WebContent_Populate_All_Hierarchy", "Exception caught during database work", Custom_Trace_Type_Enum.Error);
Tracer.Add_Trace("Engine_Database.WebContent_Populate_All_Hierarchy", ee.Message, Custom_Trace_Type_Enum.Error);
Tracer.Add_Trace("Engine_Database.WebContent_Populate_All_Hierarchy", ee.StackTrace, Custom_Trace_Type_Enum.Error);
}
return false;
}
}
