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