public XbrlNodeCollection GetXbrlNodesWithParent(string node)
{
XbrlNodeCollection nodes = null;
MySqlParameter[] parms = new MySqlParameter[] {
new MySqlParameter("@PARENT_ID", MySqlDbType.VarChar)
};
parms[0].Value = string.Format("%{0}%", node);
//Execute Query
using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.SV_CONN_STRING, SQL_SELECT_XBRL_NODES_PARENT, parms))
{
if (rdr.Read())
{
//If there is one result
nodes = new XbrlNodeCollection();
//Scroll through the results
do
{
nodes.Add(ConvertReaderToXbrlNodeObject(rdr));
}while (rdr.Read());
}
}
return(nodes);
}
public XbrlNodeCollection GetXbrlNodesWithParent(string node)
{
XbrlNodeCollection nodes = null;
MySqlParameter[] parms = new MySqlParameter[] {
new MySqlParameter("@PARENT_ID", MySqlDbType.VarChar)
};
parms[0].Value = string.Format("%{0}%", node);
//Execute Query
using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.SV_CONN_STRING, SQL_SELECT_XBRL_NODES_PARENT, parms))
{
if (rdr.Read())
{
//If there is one result
nodes = new XbrlNodeCollection();
//Scroll through the results
do
{
nodes.Add(ConvertReaderToXbrlNodeObject(rdr));
}
while (rdr.Read());
}
}
return nodes;
}
private List <string> GetChildNodes(string nodeId, XbrlNodeCollection unfilteredNodes)
{
List <string> childNodes = new List <string>();
foreach (XbrlNode node in unfilteredNodes)
{
if (node.parentId.Equals(nodeId))
{
childNodes.Add(node.nodeId);
}
}
return(childNodes);
}
public Dictionary <string, List <string> > PopulateXbrlTaxonomyTree()
{
Dictionary <string, List <string> > xbrlTaxonomyTree = new Dictionary <string, List <string> >();
XbrlNodeCollection nodeList = GetXbrlNodes();
foreach (XbrlNode node in nodeList)
{
if (!xbrlTaxonomyTree.ContainsKey(node.nodeId))
{
xbrlTaxonomyTree.Add(node.nodeId, GetChildNodes(node.nodeId, nodeList));
}
}
return(xbrlTaxonomyTree);
}
public XbrlNodeCollection GetXbrlNodes()
{
XbrlNodeCollection nodes = null;
//Execute Query
using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.SV_CONN_STRING, SQL_SELECT_XBRL_NODES))
{
if (rdr.Read())
{
//If there is one result
nodes = new XbrlNodeCollection();
//Scroll through the results
do
{
nodes.Add(ConvertReaderToXbrlNodeObject(rdr));
}while (rdr.Read());
}
}
return(nodes);
}
public XbrlNodeCollection GetXbrlNodes()
{
XbrlNodeCollection nodes = null;
//Execute Query
using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.SV_CONN_STRING, SQL_SELECT_XBRL_NODES))
{
if (rdr.Read())
{
//If there is one result
nodes = new XbrlNodeCollection();
//Scroll through the results
do
{
nodes.Add(ConvertReaderToXbrlNodeObject(rdr));
}
while (rdr.Read());
}
}
return nodes;
}
private List<string> GetChildNodes(string nodeId, XbrlNodeCollection unfilteredNodes)
{
List<string> childNodes = new List<string>();
foreach (XbrlNode node in unfilteredNodes)
{
if (node.parentId.Equals(nodeId))
{
childNodes.Add(node.nodeId);
}
}
return childNodes;
}
public BalanceSheetFilterItem(string symbol, int year)
{
this._bal = new BalanceSheet();
this._bal.Symbol = symbol;
this._bal.Year = year;
this._cashItems = new List<Item>();
this._currentAssetsItems = new List<Item>();
this._currentLiabilitiesItems = new List<Item>();
this._debtItems = new List<Item>();
this._debtNodes = new XbrlNodeCollection();
this._ppeItems = new List<Item>();
this._shareholderEquityItems = new List<Item>();
this._totalAssetsItems = new List<Item>();
}
private void Initialize()
{
this._bal = new BalanceSheet();
this._cashItems = new List<Item>();
this._currentAssetsItems = new List<Item>();
this._currentLiabilitiesItems = new List<Item>();
this._debtItems = new List<Item>();
this._debtNodes = new XbrlNodeCollection();
this._ppeItems = new List<Item>();
this._shareholderEquityItems = new List<Item>();
this._totalAssetsItems = new List<Item>();
}
