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