protected void Page_Load(object sender, EventArgs e)
{
rec = new plantsoverflowEntities();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
con.Close();
con.Open();
if(home.token == "home" || contact.token == "contact")
{
RadMenu1.Enabled = false;//make sure does not persist on other page loads
RadMenu1.Visible = false;
home.token = "";
contact.token = "";
}
if (recipe.token == "recipe")
{
SqlCommand cmd = new SqlCommand("SELECT * FROM menurecipe", con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet links = new DataSet();
adapter.Fill(links);
RadMenu1.DataTextField = "ptext";
RadMenu1.DataFieldID = "id";
//RadMenu1.DataFieldParentID = "id";
RadMenu1.DataSource = links;
RadMenu1.DataBind();
recipe.token = "";
}
if (gardenguide.token == "gardenguide")
{
SqlCommand cmd = new SqlCommand("SELECT * FROM menuyear", con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet links = new DataSet();
adapter.Fill(links);
RadMenu1.DataTextField = "ptext";
RadMenu1.DataFieldID = "id";
//RadMenu1.DataFieldParentID = "id";
RadMenu1.DataSource = links;
RadMenu1.DataBind();
gardenguide.token = "";
}
if (kids.token == "kids")
{
SqlCommand cmd = new SqlCommand("SELECT * FROM menukids", con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet links = new DataSet();
adapter.Fill(links);
RadMenu1.DataTextField = "ptext";
RadMenu1.DataFieldID = "id";
//RadMenu1.DataFieldParentID = "id";
RadMenu1.DataSource = links;
RadMenu1.DataBind();
kids.token = "";
}
con.Close();
//comments to be loaded
}
//private void LoadMenu()
//{
// string pageName = this.Page.ToString().Substring(4, this.Page.ToString().Substring(4).Length - 5) + ".aspx";
// string[] page = pageName.Split('_');
// int id = 1;
// switch (page[1])
// {
// case "home.aspx":
// id = 1;
// break;
// case "":
// break;
// case "":
// break;
// case "":
// break;
// case "":
// break;
// };
//}
private void getMenu(int id)
{
RadMenu1.Items.Clear();
rec = new plantsoverflowEntities();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
con.Open();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string sql = "Select * from MainMenu";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
da.Fill(ds);
dt = ds.Tables[0];
DataRow[] drowpar = dt.Select("ParentID=" + 0 + " and MenuID=" + 4);
foreach (DataRow dr in drowpar)
{
RadMenuItem eg = new RadMenuItem();
eg.Text = dr["MenuText"].ToString();
eg.Value = dr["MenuID"].ToString();
RadMenu1.Items.Add(eg);
}
DataRow[] sm = dt.Select("ParentID >" + 0);
foreach (DataRow dr in sm)
{
RadMenuItem mnu = new RadMenuItem(dr["MenuText"].ToString(), "#");
RadMenuItem rmi = RadMenu1.FindItemByValue(dr["ParentID"].ToString());
if (rmi != null)
{
RadMenu1.FindItemByValue(dr["ParentID"].ToString()).Items.Add(mnu);
}
}
con.Close();
RadMenu1.DataBind();
}
