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); } } } } } } } } } }
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); }
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); } }
public void InsertXbrlNode(XbrlNode node) { _dao.InsertXbrlNode(node); }
private static void SetXbrlNodeParameters(XbrlNode node, MySqlParameter[] parms) { parms[0].Value = node.nodeId; parms[1].Value = node.parentId; parms[2].Value = node.weight; }