public void DeleteUserGroup(string userId)
        {
            UserGroupDAL userGroup = new UserGroupDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                userGroup.DeleteUserGroup(userId, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }
        public bool CheckDuplicateUserGroup(string userGroupName)
        {
            UserGroupDAL userGroup = new UserGroupDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                bool status = userGroup.CheckDuplicateUserGroup(userGroupName, db);
                db.Stop();
                return status;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }
        public DataTable GetActiveUserGroupList()
        {
            UserGroupDAL userGroup = new UserGroupDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = userGroup.GetActiveUserGroupList(db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }
        public DataTable GetDeletedUserGroupListByDateRangeAll(string fromDate, string toDate, string search)
        {
            UserGroupDAL userGroup = new UserGroupDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = userGroup.GetDeletedUserGroupListByDateRangeAll(fromDate, toDate, search, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }
        public void UpdateUserGroupActivation(string userId, string activationStatus)
        {
            UserGroupDAL userGroup = new UserGroupDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                userGroup.UpdateUserGroupActivation(userId, activationStatus, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }
        public void UpdateUserGroup()
        {
            UserGroupDAL userGroup = new UserGroupDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                userGroup.UpdateUserGroup(this, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }
        public DataTable SaveUserGroup()
        {
            UserGroupDAL userGroup = new UserGroupDAL();

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

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }
        public DataTable GetUserGroupById(string userId)
        {
            UserGroupDAL userGroup = new UserGroupDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = userGroup.GetUserGroupById(userId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                userGroup = null;
            }
        }