public void AddXbrlNodes(XbrlDocument xbrlDoc)
{
foreach (var frag in xbrlDoc.XbrlFragments)
{
foreach (XbrlSchema schema in frag.Schemas)
{
if (schema != null)
{
foreach (JeffFerguson.Gepsio.LinkbaseDocument linkbase in schema.LinkbaseDocuments)
{
if (linkbase.CalculationLinks.Count != 0)
{
foreach (CalculationLink calcLink in linkbase.CalculationLinks)
{
if (calcLink.CalculationArcs.Count != 0)
{
foreach (CalculationArc calcArc in calcLink.CalculationArcs)
{
if (!NodeExists(calcArc.ToLocators[0].HrefResourceId.Split(new[] { '_' })[1], calcArc.FromLocator.HrefResourceId.Split(new[] { '_' })[1]))
{
XbrlNode nodeToAdd = new XbrlNode(
calcArc.ToLocators[0].HrefResourceId.Split(new[] { '_' })[1],
calcArc.FromLocator.HrefResourceId.Split(new[] { '_' })[1],
(int)calcArc.Weight);
InsertXbrlNode(nodeToAdd);
}
}
}
}
}
}
}
}
}
}
public void InsertXbrlNode(XbrlNode node)
{
_dao.InsertXbrlNode(node);
}
private XbrlNode ConvertReaderToXbrlNodeObject(MySqlDataReader rdr)
{
XbrlNode node = new XbrlNode();
node.nodeId = MySqlHelper.ConvertReaderToString(rdr, "NODE_ID");
node.parentId = MySqlHelper.ConvertReaderToString(rdr, "PARENT_ID");
node.weight = MySqlHelper.ConvertReaderToInt(rdr, "WEIGHT");
return node;
}
private static void SetXbrlNodeParameters(XbrlNode node, MySqlParameter[] parms)
{
parms[0].Value = node.nodeId;
parms[1].Value = node.parentId;
parms[2].Value = node.weight;
}
public void InsertXbrlNode(XbrlNode node)
{
MySqlParameter[] parms = GetXbrlNodeParameters();
SetXbrlNodeParameters(node, parms);
using (MySqlConnection conn = new MySqlConnection(MySqlHelper.SV_CONN_STRING))
{
conn.Open();
MySqlHelper.ExecuteNonQuery(conn, SQL_INSERT_XBRL_NODES, parms);
}
}
