public static bool AddSidebar(Sidebar sbObj)
 {
     try
     {
         return(DashboardDataProvider.AddSidebar(sbObj));
     }
     catch (Exception)
     {
         throw;
     }
 }
 public static List <Sidebar> GetParentLinks(int SidebarItemID)
 {
     try
     {
         List <Sidebar> lstSidebar = DashboardDataProvider.GetParentLinks(SidebarItemID);
         Sidebar        zeroItem   = new Sidebar();
         zeroItem.DisplayName = "[None Specified]";
         lstSidebar.Insert(0, zeroItem);
         return(lstSidebar);
     }
     catch (Exception)
     {
         throw;
     }
 }
        public static bool UpdateSidebar(Sidebar sbObj)
        {
            string sp = "[dbo].[usp_DashboardSidebarUpdate]";
            SQLHandler sagesql = new SQLHandler();
            try
            {
                List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
                ParamCollInput.Add(new KeyValuePair<string, object>("@DisplayName", sbObj.DisplayName));
                ParamCollInput.Add(new KeyValuePair<string, object>("@Depth", sbObj.Depth));
                ParamCollInput.Add(new KeyValuePair<string, object>("@ImagePath", sbObj.ImagePath));
                ParamCollInput.Add(new KeyValuePair<string, object>("@URL", sbObj.URL));
                ParamCollInput.Add(new KeyValuePair<string, object>("@ParentID", sbObj.ParentID));
                ParamCollInput.Add(new KeyValuePair<string, object>("@IsActive", sbObj.IsActive));               
                ParamCollInput.Add(new KeyValuePair<string, object>("@SidebarItemID", sbObj.SidebarItemID));
                ParamCollInput.Add(new KeyValuePair<string, object>("@PageID", sbObj.PageID));

                sagesql.ExecuteNonQuery(sp, ParamCollInput);

                return true;
            }
            catch (Exception)
            {

                throw;
            }
        }
 public static bool AddSidebar(Sidebar sbObj)
 {
     try
     {
         return (DashboardDataProvider.AddSidebar(sbObj));
     }
     catch (Exception)
     {
         
         throw;
     }
 }
 public static List<Sidebar> GetParentLinks(int SidebarItemID)
 {
     try
     {
         List<Sidebar> lstSidebar = DashboardDataProvider.GetParentLinks(SidebarItemID);
         Sidebar zeroItem = new Sidebar();
         zeroItem.DisplayName = "[None Specified]";
         lstSidebar.Insert(0, zeroItem);
         return lstSidebar;
     }
     catch (Exception)
     {
         
         throw;
     }
 }