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 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);
}