protected void LoadPosition2DDL()
        {
            ddlPosition.Items.Clear(); //DROPDOWNLIST        
            string status = "1";
            BannerPosition objTree = new BannerPosition();
            DataTable dtNodes = objTree.GetListByStatus(status); //select all the nodes from DB
            RecursiveFillTree(dtNodes, 0);

           // ddlPosition.Items.Insert(0, new ListItem("- Root -", "0")); //DROPDOWNLIST
            ddlPosition.SelectedIndex = 0;
            ddlPosition.AutoPostBack = true;
        }
        private void ShowTreeNodes()
        {
            ddlTreeNode.Items.Clear(); //DROPDOWNLIST        

            BannerPosition objTree = new BannerPosition();
            DataTable dtNodes = objTree.GetAll(); //select all the nodes from DB
            RecursiveFillTree(dtNodes, 0);

            ddlTreeNode.Items.Insert(0, new ListItem("- Root -", "0")); //DROPDOWNLIST
            ddlTreeNode.SelectedIndex = 0;

        }
        protected void LoadPosition2DDL()
        {
            //Load list item to dropdownlist
            //ListItemCollection lstColl = new ListItemCollection();
            //lstColl.Add(new ListItem("Top", "top"));
            //lstColl.Add(new ListItem("Left", "left"));
            //lstColl.Add(new ListItem("Right", "right"));
            //lstColl.Add(new ListItem("Bottom", "bottom"));

            //ddlPosition.DataSource = lstColl;
            //ddlPosition.DataTextField = "Text";
            //ddlPosition.DataValueField = "Value";
            //ddlPosition.DataBind();
            //ddlPosition.Items.Insert(0, new ListItem("- Chọn vị trí -", "")); // add the new item at the top of the list
            //ddlPosition.SelectedIndex = 0; // Select the first item

            ddlPosition.Items.Clear(); //DROPDOWNLIST        
            string status = "1";
            BannerPosition objTree = new BannerPosition();
            DataTable dtNodes = objTree.GetListByStatus(status); //select all the nodes from DB
            RecursiveFillTree(dtNodes, 0);

            //ddlPosition.Items.Insert(0, new ListItem("- Root -", "0")); //DROPDOWNLIST
            ddlPosition.SelectedIndex = 0;
        }
        private void ShowTreeNodes(string ParentId)
        {
            lstTreeNode.Items.Clear(); //LISTBOX        

            BannerPosition objTree = new BannerPosition();
            DataTable dtNodes = objTree.GetAll(); //select all the nodes from DB
            RecursiveFillTree(dtNodes, 0);

            lstTreeNode.Items.Insert(0, new ListItem("- Root -", "0")); //LISTBOX
            lstTreeNode.SelectedValue = ParentId;
        }
        private int UpdateData()
        {            
            string UserId = Session["UserId"].ToString();
            string strParentID = null;
            if (lstTreeNode.SelectedValue == _idx.ToString())
            {
                strParentID = ViewState["parentid"].ToString();
            }
            else
            {
                strParentID = lstTreeNode.SelectedValue;
            }
            int parent_id = Convert.ToInt32(strParentID);

            string banner_position = txtBannerPosition.Text;
            string description = txtDescription.Text;
            string status = rdlDiscontinued.SelectedValue;
            string Discontinued = rdlDiscontinued.SelectedValue;

            BannerPosition banner_position_obj = new BannerPosition();
            int i = banner_position_obj.Update(_idx, parent_id, banner_position, description, status);            
            return i;
        }
        private void LoadData()
        {
            BannerPosition banner_position_obj = new BannerPosition();
            DataTable dt = banner_position_obj.GetDetailById(_idx);

            txtBannerPosition.Text = dt.Rows[0]["BannerPosition"].ToString();
            txtDescription.Text = dt.Rows[0]["Description"].ToString();
            string sortkey = dt.Rows[0]["SortKey"].ToString();
            string status = dt.Rows[0]["Status"].ToString();
            LoadStatusList2DDL(status);

            /***** PARENT ID ***********************************************/
            ViewState["parentid"] = dt.Rows[0]["ParentId"].ToString();
            ShowTreeNodes(dt.Rows[0]["ParentId"].ToString());
            /******************************************************************/
            
        }
 private int AddData()
 {
     string UserId = Session["UserId"].ToString();
     int parentid = Convert.ToInt32(ddlTreeNode.SelectedValue);
     string banner_position = txtBannerPosition.Text;
     string description = txtDescription.Text;
     bool bStatus = ChkBoxStatus.Checked;
     string status = string.Empty;
     if (bStatus == true)
     {
         status = "1";
     }
     else
     {
         status = "0";
     }
     BannerPosition banner_position_obj = new BannerPosition();
     int i = banner_position_obj.Insert(parentid, banner_position, description, status);
     return i;
 }