public void UpdateMenuGroupActivation(string menuGroupId, string activationStatus)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                appMenu.UpdateMenuGroupActivation(menuGroupId, activationStatus, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public void UpdateMenuSorting(ListBox groupWiseUserMenuListListBox, string parentMenuId)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                appMenu.UpdateMenuSorting(groupWiseUserMenuListListBox, parentMenuId, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public void SaveUserPrivilegeMenu(string userId, string menuForApp, string menuType, string menuGroupId, List<string> userPrivilegeMenus)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                appMenu.SaveUserPrivilegeMenu(userId, menuForApp, menuType, menuGroupId, userPrivilegeMenus, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public void UpdateMenuGroup()
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                appMenu.UpdateMenuGroup(this, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable LoadParentMenusByMenuAppAndType(string menuForApp, string menuType)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.LoadParentMenusByMenuAppAndType(menuForApp, menuType, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable SaveMenuGroup()
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                DataTable dt = appMenu.SaveMenuGroup(this, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable GetPrivilegedMenuByUserGroup(string userGroupId, string menuForApp, string menuType, string menuGroupId)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.GetPrivilegedMenuByUserGroup(userGroupId, menuForApp, menuType, menuGroupId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable GetUserMenuData(string userId, string menuForApp, string menuType)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.GetUserMenuData(userId, menuForApp, menuType, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable GetMenuTypesByApp(string menuForApp)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.GetMenuTypesByApp(menuForApp, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable GetParentMenusByMenuAppTypeGroupAndLevel(string menuForApp, string menuType, string menuGroupId, string menuLevel)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.GetParentMenusByMenuAppTypeGroupAndLevel(menuForApp, menuType, menuGroupId, menuLevel, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable GetMenuList()
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.GetMenuList(db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable GetMenuGroupById(string menuGroupId)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.GetMenuGroupById(menuGroupId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public DataTable GetChildMenusByParentMenuId(string parentMenuId)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = appMenu.GetChildMenusByParentMenuId(parentMenuId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public string DeleteMenuGroupById(string menuGroupId, string forceToDelete)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                string status = appMenu.DeleteMenuGroupById(menuGroupId, forceToDelete, db);
                db.Stop();

                return status;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }
        public bool CheckDuplicateMenuGroup(string menuGroupName)
        {
            AppMenuDAL appMenu = new AppMenuDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                bool status = appMenu.CheckDuplicateMenuGroup(menuGroupName, db);
                db.Stop();
                return status;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                appMenu = null;
            }
        }