private void LoadCategory(DropDownList ddlCategory)
 {
     try
     {
         _objItemCategorySetupController = new ItemCategorySetupController();
         _objItemCategorySetupController.GetCategory(_connectionString, ddlCategory);
         if (TreeViewCategory.Nodes.Count > 0)
         {
             ddlCategory.Items.RemoveAt(0);
         }
     }
     catch (Exception msgException)
     {
         throw msgException;
     }
 }
        private void AddValuesToCategory()
        {
            try
            {
                _objItemCategorySetup                = new ItemCategorySetup();
                _objItemCategorySetup.CompanyID      = Convert.ToInt32(Session["company"].ToString());
                _objItemCategorySetup.BranchID       = Convert.ToInt32(Session["branch"].ToString());
                _objItemCategorySetup.CategoryTypeID = Convert.ToInt32(ddlProductType.SelectedValue);
                _objItemCategorySetup.ItemCategoryID = CreateCategoryID();
                _objItemCategorySetup.CategoryName   = txtCategoryName.Text == string.Empty ? null : txtCategoryName.Text;

                _objItemCategorySetup.ParentCategoryID = ddlParentCategory.SelectedValue == "-1" ? Convert.ToInt32("1" + _objItemCategorySetup.CompanyID.ToString() + _objItemCategorySetup.BranchID.ToString()) :
                                                         Convert.ToInt32(ddlParentCategory.SelectedValue);
                _objItemCategorySetup.StartingItemCode = 0;
                _objItemCategorySetup.EndingItemCode   = 0;
                _objItemCategorySetup.SeqNo            = Convert.ToInt32(Session["sequenceNumber"].ToString());
                _objItemCategorySetup.TierNo           = Convert.ToInt32(Session["tierNumber"].ToString());
                _objItemCategorySetup.CurrentBalance   = 0;
                _objItemCategorySetup.DataUsed         = "A";
                _objItemCategorySetup.EntryUserName    = Session["entryUserCode"].ToString();
                _objItemCategorySetupController        = new ItemCategorySetupController();
                _objItemCategorySetupController.Save(_connectionString, _objItemCategorySetup);
                ClearCategory();
                TreeViewCategory.Nodes.Clear();
                PopulateRootLevel();
                LoadCategory(ddlCategory);
                LoadCategory(ddlParentCategory);
            }
            catch (SqlException msgException)
            {
                throw msgException;
            }
            catch (Exception msgException)
            {
                throw msgException;
            }
        }