public void RemoveCMApplicationCategory(string appName, string categoryName)
        {
            SmsProvider          smsProvider       = new SmsProvider();
            WqlConnectionManager connectionManager = smsProvider.Connect(SiteServer);

            ObservableCollection <CMApplicationCategory> applicationCategories = GetCMApplicationCategories(false);

            string appQuery = string.Format("SELECT * FROM SMS_ApplicationLatest WHERE (IsHidden = 0) AND (LocalizedDisplayName = '{0}')", appName);

            IResultObject appQueryResult = connectionManager.QueryProcessor.ExecuteQuery(appQuery);

            if (appQueryResult != null)
            {
                foreach (IResultObject app in appQueryResult)
                {
                    ArrayList appCategories = new ArrayList(app["CategoryInstance_UniqueIDs"].StringArrayValue);

                    CMApplicationCategory applicationCategory = applicationCategories.Where(c => c.LocalizedCategoryInstanceName == categoryName).First();

                    if (appCategories.Contains(applicationCategory.CategoryInstance_UniqueID))
                    {
                        appCategories.Remove(applicationCategory.CategoryInstance_UniqueID);

                        app["CategoryInstance_UniqueIDs"].StringArrayValue = (string[])appCategories.ToArray(typeof(string));
                        app.Put();
                    }
                    else
                    {
                        MessageBox.Show(appName + " doesn't contain " + categoryName);
                    }
                }
            }
        }
        public List <CMApplication> GetCMApplicationsByCategory(string category)
        {
            List <CMApplication> cmApps = new List <CMApplication>();

            SmsProvider          smsProvider       = new SmsProvider();
            WqlConnectionManager connectionManager = smsProvider.Connect(SiteServer);

            string appQuery = null;

            if (category == "All")
            {
                appQuery = string.Format("SELECT * FROM SMS_ApplicationLatest WHERE (IsHidden = 0)");
            }
            else
            {
                appQuery = string.Format("SELECT * FROM SMS_ApplicationLatest WHERE (IsHidden = 0) AND (LocalizedCategoryInstanceNames = '{0}')", category);
            }

            try {
                IResultObject appQueryResult = connectionManager.QueryProcessor.ExecuteQuery(appQuery);

                if (appQueryResult != null)
                {
                    foreach (IResultObject app in appQueryResult)
                    {
                        CMApplication application = new CMApplication();
                        application.ApplicationName = app["LocalizedDisplayName"].StringValue;

                        if (app["LocalizedCategoryInstanceNames"] != null)
                        {
                            foreach (string appCategory in app["LocalizedCategoryInstanceNames"].StringArrayValue)
                            {
                                if (!string.IsNullOrEmpty(appCategory))
                                {
                                    application.ApplicationCategories.Add(appCategory);
                                }
                            }
                        }

                        cmApps.Add(application);
                    }
                }
            } catch (SmsException e) {
                MessageBox.Show("Error in GetCMApplicationsByCategory SmsException: " + e.Message);
            } catch (NullReferenceException e) {
                MessageBox.Show("Error in GetCMApplicationsByCategory NullReferenceException: " + e.Message);
            }

            return(cmApps);
        }
        public ObservableCollection <CMApplicationCategory> GetCMApplicationCategories(bool includeAllApplications)
        {
            ObservableCollection <CMApplicationCategory> applicationCategories = new ObservableCollection <CMApplicationCategory>();

            SmsProvider          smsProvider       = new SmsProvider();
            WqlConnectionManager connectionManager = smsProvider.Connect(SiteServer);

            string appCatagoriesQuery = "SELECT * FROM SMS_CategoryInstance WHERE (CategoryTypeName = 'AppCategories')";

            try {
                IResultObject appCategoriesQueryResult = connectionManager.QueryProcessor.ExecuteQuery(appCatagoriesQuery);

                if (appCategoriesQueryResult != null)
                {
                    foreach (IResultObject appCategory in appCategoriesQueryResult)
                    {
                        CMApplicationCategory cmApplicationCategory = new CMApplicationCategory();

                        cmApplicationCategory.CategoryInstanceID            = appCategory["CategoryInstanceID"].IntegerValue;
                        cmApplicationCategory.CategoryInstance_UniqueID     = appCategory["CategoryInstance_UniqueID"].StringValue;
                        cmApplicationCategory.CategoryTypeName              = appCategory["CategoryTypeName"].StringValue;
                        cmApplicationCategory.LocalizedCategoryInstanceName = appCategory["LocalizedCategoryInstanceName"].StringValue;
                        cmApplicationCategory.ParentCategoryInstanceID      = appCategory["ParentCategoryInstanceID"].IntegerValue;
                        cmApplicationCategory.SourceSite = appCategory["SourceSite"].StringValue;

                        applicationCategories.Add(cmApplicationCategory);
                    }

                    // Add All Categories Option
                    if (includeAllApplications)
                    {
                        CMApplicationCategory allCategory = new CMApplicationCategory {
                            LocalizedCategoryInstanceName = "All"
                        };

                        applicationCategories.Add(allCategory);
                    }
                }
            } catch (SmsException e) {
                MessageBox.Show("Error connecting to site server " + SiteServer + ": " + e.Message);
            } catch (NullReferenceException e) {
                MessageBox.Show("Error in GetCMApplicationCategories NullReferenceException: " + e.Message);
            }

            return(applicationCategories);
        }
        public List <CMApplication> GetCMApplications(string filter)
        {
            List <CMApplication> cmApps = new List <CMApplication>();

            SmsProvider          smsProvider       = new SmsProvider();
            WqlConnectionManager connectionManager = smsProvider.Connect(SiteServer);

            string appQuery = null;

            if (!string.IsNullOrEmpty(filter))
            {
                appQuery = string.Format("SELECT * FROM SMS_ApplicationLatest WHERE (IsHidden = 0) AND (LocalizedDisplayName = '{0}')", filter);
            }
            else
            {
                appQuery = "SELECT * FROM SMS_ApplicationLatest WHERE (IsHidden = 0)";
            }

            IResultObject appQueryResult = connectionManager.QueryProcessor.ExecuteQuery(appQuery);

            if (appQueryResult != null)
            {
                foreach (IResultObject app in appQueryResult)
                {
                    CMApplication application = new CMApplication();

                    application.ApplicationName = app["LocalizedDisplayName"].StringValue;

                    if (app["LocalizedCategoryInstanceNames"] != null)
                    {
                        foreach (string category in app["LocalizedCategoryInstanceNames"].StringArrayValue)
                        {
                            if (!String.IsNullOrEmpty(category))
                            {
                            }
                        }
                    }
                    cmApps.Add(application);
                }
            }

            return(cmApps);
        }