/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <DisplayString> GetList() { QueryExpression query = new QueryExpression() { EntityName = DisplayString.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), Criteria = { Conditions = { new ConditionExpression(DisplayString.Schema.Attributes.componentstate, ConditionOperator.In , (int)Entities.GlobalOptionSets.componentstate.Published_0 , (int)Entities.GlobalOptionSets.componentstate.Unpublished_1 ), }, }, Orders = { new OrderExpression(DisplayString.Schema.Attributes.displaystringkey, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <DisplayString>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <SavedQuery> GetList(string filterEntity, ColumnSet columnSet) { QueryExpression query = new QueryExpression() { EntityName = SavedQuery.EntityLogicalName, NoLock = true, ColumnSet = columnSet ?? new ColumnSet(true), Criteria = { Conditions = { new ConditionExpression(SavedQuery.Schema.Attributes.componentstate, ConditionOperator.In , (int)Entities.GlobalOptionSets.componentstate.Published_0 , (int)Entities.GlobalOptionSets.componentstate.Unpublished_1 ), }, }, Orders = { new OrderExpression(SavedQuery.Schema.Attributes.returnedtypecode, OrderType.Ascending), new OrderExpression(SavedQuery.Schema.Attributes.name, OrderType.Ascending), }, }; if (!string.IsNullOrEmpty(filterEntity)) { query.Criteria.Conditions.Add(new ConditionExpression(SavedQuery.Schema.Attributes.returnedtypecode, ConditionOperator.Equal, filterEntity)); } return(_service.RetrieveMultipleAll <SavedQuery>(query)); }
private List <TeamTemplate> GetList(string filter, ColumnSet columnSet) { var query = new QueryExpression() { NoLock = true, EntityName = TeamTemplate.EntityLogicalName, ColumnSet = columnSet ?? ColumnSetInstances.None, Orders = { new OrderExpression(TeamTemplate.Schema.Attributes.objecttypecode, OrderType.Ascending), new OrderExpression(TeamTemplate.Schema.Attributes.teamtemplatename, OrderType.Ascending), }, }; if (!string.IsNullOrEmpty(filter)) { if (Guid.TryParse(filter, out Guid id)) { query.Criteria.Conditions.Add(new ConditionExpression(TeamTemplate.Schema.Attributes.teamtemplateid, ConditionOperator.Equal, id)); } else { query.Criteria.Conditions.Add(new ConditionExpression(TeamTemplate.Schema.Attributes.teamtemplatename, ConditionOperator.Like, "%" + filter + "%")); } } return(_service.RetrieveMultipleAll <TeamTemplate>(query)); }
private List <PluginAssembly> GetPluginAssemblies(string name, ColumnSet columnSet) { QueryExpression query = new QueryExpression() { ColumnSet = columnSet ?? new ColumnSet(GetAttributes(_service)), EntityName = PluginAssembly.EntityLogicalName, Criteria = { Conditions = { new ConditionExpression(PluginAssembly.Schema.Attributes.ishidden, ConditionOperator.Equal, false), }, }, Orders = { new OrderExpression(PluginAssembly.Schema.Attributes.name, OrderType.Ascending), new OrderExpression(PluginAssembly.Schema.Attributes.createdon, OrderType.Ascending), }, }; if (!string.IsNullOrEmpty(name)) { query.Criteria.AddCondition(PluginAssembly.Schema.Attributes.name, ConditionOperator.Like, "%" + name + "%"); } return(_service.RetrieveMultipleAll <PluginAssembly>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <Team> GetList(string filter, bool?isDefault, Team.Schema.OptionSets.teamtype?teamType, bool?isTeamTemplate, ColumnSet columnSet) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = Team.EntityLogicalName, ColumnSet = columnSet ?? ColumnSetInstances.AllColumns, LinkEntities = { new LinkEntity() { JoinOperator = JoinOperator.LeftOuter, LinkFromEntityName = Team.Schema.EntityLogicalName, LinkFromAttributeName = Team.Schema.Attributes.teamtemplateid, LinkToEntityName = TeamTemplate.Schema.EntityLogicalName, LinkToAttributeName = TeamTemplate.Schema.Attributes.teamtemplateid, EntityAlias = Team.Schema.Attributes.teamtemplateid, Columns = new ColumnSet(TeamTemplate.Schema.Attributes.teamtemplatename), }, }, }; if (!string.IsNullOrEmpty(filter)) { if (Guid.TryParse(filter, out Guid id)) { query.Criteria.Conditions.Add(new ConditionExpression(Team.Schema.Attributes.teamid, ConditionOperator.Equal, id)); } else { query.Criteria.Conditions.Add(new ConditionExpression(Team.Schema.Attributes.name, ConditionOperator.Like, "%" + filter + "%")); } } if (isDefault.HasValue) { query.Criteria.Conditions.Add(new ConditionExpression(Team.Schema.Attributes.isdefault, ConditionOperator.Equal, isDefault.Value)); } if (isTeamTemplate.HasValue) { query.Criteria.Conditions.Add(new ConditionExpression(Team.Schema.Attributes.teamtemplateid, isTeamTemplate.Value ? ConditionOperator.NotNull : ConditionOperator.Null)); } if (teamType.HasValue) { query.Criteria.Conditions.Add(new ConditionExpression(Team.Schema.Attributes.teamtype, ConditionOperator.Equal, (int)teamType.Value)); } return(_service.RetrieveMultipleAll <Team>(query)); }
private List <Solution> FindSolutionsVisibleUnmanaged(string name) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = Solution.EntityLogicalName, ColumnSet = ColumnSetInstances.AllColumns, Criteria = { Conditions = { new ConditionExpression(Solution.Schema.Attributes.ismanaged, ConditionOperator.Equal, false), new ConditionExpression(Solution.Schema.Attributes.isvisible, ConditionOperator.Equal, true) } }, LinkEntities = { new LinkEntity() { EntityAlias = Solution.Schema.Attributes.publisherid, LinkFromEntityName = Solution.EntityLogicalName, LinkFromAttributeName = Solution.Schema.Attributes.publisherid, LinkToEntityName = Publisher.EntityLogicalName, LinkToAttributeName = Publisher.EntityPrimaryIdAttribute, Columns = new ColumnSet(Publisher.Schema.Attributes.customizationprefix) } }, Orders = { new OrderExpression(Solution.Schema.Attributes.installedon, OrderType.Descending), }, }; if (!string.IsNullOrEmpty(name)) { query.Criteria.Filters.Add(new FilterExpression(LogicalOperator.Or) { Conditions = { new ConditionExpression(Solution.Schema.Attributes.uniquename, ConditionOperator.Like, "%" + name + "%"), new ConditionExpression(Solution.Schema.Attributes.friendlyname, ConditionOperator.Like, "%" + name + "%"), }, }); } return(_service.RetrieveMultipleAll <Solution>(query)); }
private List <InvalidDependency> GetList(ColumnSet columnSet) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = InvalidDependency.EntityLogicalName, ColumnSet = columnSet ?? ColumnSetInstances.AllColumns, }; return(_service.RetrieveMultipleAll <InvalidDependency>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <SdkMessageRequestField> GetList(ColumnSet columnSet) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = SdkMessageRequestField.EntityLogicalName, ColumnSet = columnSet ?? ColumnSetInstances.AllColumns, }; return(_service.RetrieveMultipleAll <SdkMessageRequestField>(query)); }
private List <DependencyNode> GetList(ColumnSet columnSet) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = DependencyNode.EntityLogicalName, ColumnSet = columnSet ?? new ColumnSet(true), }; return(_service.RetrieveMultipleAll <DependencyNode>(query)); }
private List <SdkMessagePair> GetList(ColumnSet columnSet) { QueryExpression query = new QueryExpression() { EntityName = SdkMessagePair.EntityLogicalName, NoLock = true, ColumnSet = columnSet ?? new ColumnSet(true), }; return(_service.RetrieveMultipleAll <SdkMessagePair>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <SystemForm> GetList( string filterEntity , SystemForm.Schema.OptionSets.type?formType , SystemForm.Schema.OptionSets.formactivationstate?state , ColumnSet columnSet ) { QueryExpression query = new QueryExpression() { EntityName = SystemForm.EntityLogicalName, NoLock = true, ColumnSet = columnSet ?? ColumnSetInstances.AllColumns, Criteria = { Conditions = { new ConditionExpression(SystemForm.Schema.Attributes.componentstate, ConditionOperator.In , (int)Entities.GlobalOptionSets.componentstate.Published_0 , (int)Entities.GlobalOptionSets.componentstate.Unpublished_1 ), }, }, Orders = { new OrderExpression(SystemForm.Schema.Attributes.objecttypecode, OrderType.Ascending), new OrderExpression(SystemForm.Schema.Attributes.type, OrderType.Ascending), new OrderExpression(SystemForm.Schema.Attributes.name, OrderType.Ascending), }, }; if (!string.IsNullOrEmpty(filterEntity)) { query.Criteria.Conditions.Add(new ConditionExpression(SystemForm.Schema.Attributes.objecttypecode, ConditionOperator.Equal, filterEntity)); } if (state.HasValue) { query.Criteria.Conditions.Add(new ConditionExpression(SystemForm.Schema.Attributes.formactivationstate, ConditionOperator.Equal, (int)state.Value)); } if (formType.HasValue) { query.Criteria.Conditions.Add(new ConditionExpression(SystemForm.Schema.Attributes.type, ConditionOperator.Equal, (int)formType.Value)); } return(_service.RetrieveMultipleAll <SystemForm>(query)); }
private List <SdkMessage> GetAllSdkMessageWithSteps() { QueryExpression query = new QueryExpression() { NoLock = true, Distinct = true, EntityName = SdkMessage.EntityLogicalName, ColumnSet = ColumnSetInstances.AllColumns, Criteria = { Conditions = { new ConditionExpression(SdkMessage.Schema.Attributes.isprivate, ConditionOperator.Equal, false), }, }, LinkEntities = { new LinkEntity() { LinkFromEntityName = SdkMessage.EntityLogicalName, LinkFromAttributeName = SdkMessage.EntityPrimaryIdAttribute, LinkToEntityName = SdkMessageProcessingStep.EntityLogicalName, LinkToAttributeName = SdkMessageProcessingStep.Schema.Attributes.sdkmessageid, LinkCriteria = { Conditions = { new ConditionExpression(SdkMessageProcessingStep.Schema.Attributes.stage, ConditionOperator.In , (int)SdkMessageProcessingStep.Schema.OptionSets.stage.Pre_validation_10 , (int)SdkMessageProcessingStep.Schema.OptionSets.stage.Pre_operation_20 , (int)SdkMessageProcessingStep.Schema.OptionSets.stage.Post_operation_40 ), new ConditionExpression(SdkMessageProcessingStep.Schema.Attributes.ishidden, ConditionOperator.Equal, false), }, }, }, }, }; return(_service.RetrieveMultipleAll <SdkMessage>(query)); }
private List <ConnectionRoleAssociation> GetList() { QueryExpression query = new QueryExpression() { EntityName = ConnectionRoleAssociation.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), LinkEntities = { new LinkEntity() { LinkFromEntityName = ConnectionRoleAssociation.EntityLogicalName, LinkFromAttributeName = ConnectionRoleAssociation.Schema.Attributes.associatedconnectionroleid, LinkToEntityName = ConnectionRole.EntityLogicalName, LinkToAttributeName = ConnectionRole.EntityPrimaryIdAttribute, EntityAlias = ConnectionRole.EntityLogicalName, Columns = new ColumnSet(ConnectionRole.Schema.Attributes.name), }, }, }; return(_service.RetrieveMultipleAll <ConnectionRoleAssociation>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <StringMap> GetList(string entityName) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = StringMap.EntityLogicalName, ColumnSet = ColumnSetInstances.AllColumns, Criteria = { Conditions = { new ConditionExpression(StringMap.Schema.Attributes.displayorder, ConditionOperator.NotNull), }, }, }; if (!string.IsNullOrEmpty(entityName)) { query.Criteria.Conditions.Add(new ConditionExpression(StringMap.Schema.Attributes.objecttypecode, ConditionOperator.Equal, entityName)); } return(_service.RetrieveMultipleAll <StringMap>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <LanguageLocale> GetList(params int[] types) { if (types == null) { return(new List <LanguageLocale>()); } if (types.Length == 0) { return(new List <LanguageLocale>()); } QueryExpression query = new QueryExpression() { EntityName = LanguageLocale.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), Criteria = { Conditions = { new ConditionExpression(LanguageLocale.Schema.Attributes.localeid, ConditionOperator.In, types), }, }, }; return(_service.RetrieveMultipleAll <LanguageLocale>(query)); }
private List <Publisher> GetSolutionPublisher(Guid solutionId) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = Publisher.EntityLogicalName, ColumnSet = new ColumnSet(Publisher.Schema.Attributes.customizationprefix), LinkEntities = { new LinkEntity() { LinkFromEntityName = Publisher.EntityLogicalName, LinkFromAttributeName = Publisher.EntityPrimaryIdAttribute, LinkToEntityName = Solution.EntityLogicalName, LinkToAttributeName = Solution.Schema.Attributes.publisherid, LinkCriteria = { Conditions = { new ConditionExpression(Solution.EntityPrimaryIdAttribute, ConditionOperator.Equal, solutionId) } } } }, }; return(_service.RetrieveMultipleAll <Publisher>(query)); }
private IEnumerable <Workflow> GetList(string filterEntity, int?category, int?mode, ColumnSet columnSet) { QueryExpression query = new QueryExpression() { EntityName = Workflow.EntityLogicalName, NoLock = true, ColumnSet = columnSet ?? new ColumnSet(true), Criteria = { Conditions = { new ConditionExpression(Workflow.Schema.Attributes.componentstate, ConditionOperator.In , (int)Entities.GlobalOptionSets.componentstate.Published_0 , (int)Entities.GlobalOptionSets.componentstate.Unpublished_1 ), new ConditionExpression(Workflow.Schema.Attributes.parentworkflowid, ConditionOperator.Null), }, }, Orders = { new OrderExpression(Workflow.Schema.Attributes.primaryentity, OrderType.Ascending), new OrderExpression(Workflow.Schema.Attributes.name, OrderType.Ascending), }, }; if (!string.IsNullOrEmpty(filterEntity)) { query.Criteria.Conditions.Add(new ConditionExpression(Workflow.Schema.Attributes.primaryentity, ConditionOperator.Equal, filterEntity)); } if (category.HasValue) { query.Criteria.Conditions.Add(new ConditionExpression(Workflow.Schema.Attributes.category, ConditionOperator.Equal, category.Value)); } if (mode.HasValue) { query.Criteria.Conditions.Add(new ConditionExpression(Workflow.Schema.Attributes.mode, ConditionOperator.Equal, mode.Value)); } return(_service.RetrieveMultipleAll <Workflow>(query)); }
private List <KbArticleTemplate> GetList() { QueryExpression query = new QueryExpression() { EntityName = KbArticleTemplate.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), Orders = { new OrderExpression(KbArticleTemplate.Schema.Attributes.title, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <KbArticleTemplate>(query)); }
private List <FieldSecurityProfile> GetList() { QueryExpression query = new QueryExpression() { EntityName = FieldSecurityProfile.EntityLogicalName, NoLock = true, ColumnSet = ColumnSetInstances.AllColumns, Orders = { new OrderExpression(FieldSecurityProfile.Schema.Attributes.name, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <FieldSecurityProfile>(query)); }
private List <EntityMap> GetList() { QueryExpression query = new QueryExpression() { EntityName = EntityMap.EntityLogicalName, NoLock = true, ColumnSet = ColumnSetInstances.AllColumns, Orders = { new OrderExpression(EntityMap.Schema.Attributes.sourceentityname, OrderType.Ascending), new OrderExpression(EntityMap.Schema.Attributes.targetentityname, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <EntityMap>(query)); }
private List <Template> GetList() { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = Template.EntityLogicalName, ColumnSet = ColumnSetInstances.AllColumns, Orders = { new OrderExpression(Template.Schema.Attributes.templatetypecode, OrderType.Ascending), new OrderExpression(Template.Schema.Attributes.title, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <Template>(query)); }
private List <AttributeMap> GetList() { QueryExpression query = new QueryExpression() { EntityName = AttributeMap.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), Orders = { new OrderExpression(AttributeMap.Schema.Attributes.sourceattributename, OrderType.Ascending), new OrderExpression(AttributeMap.Schema.Attributes.targetattributename, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <AttributeMap>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <Team> GetList(string filter, ColumnSet columnSet) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = Team.EntityLogicalName, ColumnSet = columnSet ?? new ColumnSet(true), LinkEntities = { new LinkEntity() { JoinOperator = JoinOperator.LeftOuter, LinkFromEntityName = Team.Schema.EntityLogicalName, LinkFromAttributeName = Team.Schema.Attributes.teamtemplateid, LinkToEntityName = TeamTemplate.Schema.EntityLogicalName, LinkToAttributeName = TeamTemplate.Schema.Attributes.teamtemplateid, EntityAlias = Team.Schema.Attributes.teamtemplateid, Columns = new ColumnSet(TeamTemplate.Schema.Attributes.teamtemplatename), }, }, }; if (!string.IsNullOrEmpty(filter)) { if (Guid.TryParse(filter, out Guid id)) { query.Criteria.Conditions.Add(new ConditionExpression(Team.Schema.Attributes.teamid, ConditionOperator.Equal, id)); } else { query.Criteria.Conditions.Add(new ConditionExpression(Team.Schema.Attributes.name, ConditionOperator.Like, "%" + filter + "%")); } } return(_service.RetrieveMultipleAll <Team>(query)); }
private List <ConnectionRole> GetList() { QueryExpression query = new QueryExpression() { EntityName = ConnectionRole.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), Orders = { new OrderExpression(ConnectionRole.Schema.Attributes.category, OrderType.Ascending), new OrderExpression(ConnectionRole.Schema.Attributes.name, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <ConnectionRole>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <Organization> GetList() { QueryExpression query = new QueryExpression() { EntityName = Organization.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), }; return(_service.RetrieveMultipleAll <Organization>(query)); }
/// <summary> /// Получить все представления /// </summary> private List <SiteMap> GetList(ColumnSet columnSet) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = SiteMap.EntityLogicalName, ColumnSet = columnSet ?? new ColumnSet(true), Criteria = { Conditions = { new ConditionExpression(SiteMap.EntityPrimaryIdAttribute, ConditionOperator.NotNull), }, }, }; return(_service.RetrieveMultipleAll <SiteMap>(query)); }
private List <SdkMessageProcessingStepImage> GetAllSdkMessageProcessingStepImage() { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = SdkMessageProcessingStepImage.EntityLogicalName, ColumnSet = new ColumnSet(true), Orders = { new OrderExpression(SdkMessageProcessingStepImage.Schema.Attributes.imagetype, OrderType.Ascending), new OrderExpression(SdkMessageProcessingStepImage.Schema.Attributes.name, OrderType.Ascending), new OrderExpression(SdkMessageProcessingStepImage.Schema.Attributes.entityalias, OrderType.Ascending), new OrderExpression(SdkMessageProcessingStepImage.Schema.Attributes.createdon, OrderType.Ascending), }, }; return(_service.RetrieveMultipleAll <SdkMessageProcessingStepImage>(query)); }
/// <summary> /// Получить все представления /// </summary> /// <param name="name"></param> /// <returns></returns> private List <AppModule> GetList(ColumnSet columnSet) { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = AppModule.EntityLogicalName, ColumnSet = columnSet ?? ColumnSetInstances.AllColumns, }; return(_service.RetrieveMultipleAll <AppModule>(query)); }
private List <SdkMessageProcessingStepSecureConfig> GetAllSdkMessageProcessingStepSecureConfig() { QueryExpression query = new QueryExpression() { NoLock = true, EntityName = SdkMessageProcessingStepSecureConfig.EntityLogicalName, ColumnSet = ColumnSetInstances.AllColumns, }; return(_service.RetrieveMultipleAll <SdkMessageProcessingStepSecureConfig>(query)); }
private List <ConnectionRoleObjectTypeCode> GetList() { QueryExpression query = new QueryExpression() { EntityName = ConnectionRoleObjectTypeCode.EntityLogicalName, NoLock = true, ColumnSet = new ColumnSet(true), }; return(_service.RetrieveMultipleAll <ConnectionRoleObjectTypeCode>(query)); }