public List <HelpLevel3> LoadHelpLevel3ByParentId(int parentId)
{
string query = "SELECT * FROM HelpOnlineLevel3 WHERE parentID =" + parentId + " order by IndexTopic";
List <HelpLevel3> list = new List <HelpLevel3>();
using (SqlConnection con = SQLConnect())
{
using (SqlDataAdapter sda = new SqlDataAdapter(query, con))
{
using (DataTable dt = new DataTable())
{
con.Open();
sda.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
HelpLevel3 level3 = new HelpLevel3();
level3.Id = Convert.ToInt32(row["Id"]);
level3.Title = row["Title"].ToString();
level3.URL = row["URL"].ToString();
level3.ParentId = Convert.ToInt32(row["parentId"]);
HelpLevel2DB helpLevel2DB = new HelpLevel2DB();
level3.ParentTopic = helpLevel2DB.GetHelpLevel2ById(level3.ParentId);
level3.Index = 1;
list.Add(level3);
}
}
}
}
return(list);
}
