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;
}
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;
}