public static string GetCheckWrapper(CustomNode node, string sqlToWrap)
{
string level1Type = ExtendedPropertiesHelper.GetLevel1Type(node.Type);
string level1Name = ExtendedPropertiesHelper.GetLevel1Name(node);
string level2Type = ExtendedPropertiesHelper.GetLevel2Type(node.Type);
string level2Name = ExtendedPropertiesHelper.GetLevel2Name(node);
return(GetCheckWrapper(level1Type, level1Name, level2Type, level2Name, sqlToWrap));
}
public static int CustomNodeToIndex(DatabaseOperation databaseOperation, CustomNode node)
{
string level1Type = GetLevel1NodeTypeString(node.Type);
string level1Name;
string level2Type = GetLevel2NodeTypeString(node.Type);
string level2Name = "";
if (node.Type == NodeType.Database || node.Type == NodeType.Tables || node.Type == NodeType.Views || node.Type == NodeType.Programmability || node.Type == NodeType.StoredProcedures || node.Type == NodeType.Functions || node.Type == NodeType.TableValuedFunctions || node.Type == NodeType.ScalarValuedFunctions)
{
if (node.Type == NodeType.Database || node.Type == NodeType.Programmability || node.Type == NodeType.Functions)
{
level1Name = GetFirstLevel1NodeName(databaseOperation, (CustomNode)node.Nodes[0]);
}
else
{
level1Name = GetFirstLevel1NodeName(databaseOperation, node);
}
}
else
{
if (node.Type == NodeType.TableColumns || node.Type == NodeType.TableKeys || node.Type == NodeType.TableConstraints || node.Type == NodeType.TableTriggers || node.Type == NodeType.TableIndexes || node.Type == NodeType.ViewColumns || node.Type == NodeType.ViewTriggers || node.Type == NodeType.ViewIndexes || node.Type == NodeType.StoredProcedureParameters || node.Type == NodeType.TableValuedFunctionParameters || node.Type == NodeType.ScalarValuedFunctionParameters)
{
level1Name = ExtendedPropertiesHelper.GetLevel1Name(node.ParentNode);
level2Name = GetFirstLevel2NodeName(databaseOperation, node);
}
else
{
level1Name = ExtendedPropertiesHelper.GetLevel1Name(node);
if (ExtendedPropertiesHelper.AddLevel2(node.Type))
{
level2Name = ExtendedPropertiesHelper.GetLevel2Name(node);
}
}
}
int treeId = databaseOperation.GetIdFromName(level1Type, level1Name, level2Type, level2Name);
return(treeId - 1);
}