internal static queryContainer transformFetch(CrmServiceClient service, SchemaEntities listOfEntities_DS, string fetch, bool excludeFromResults)
{
QueryExpression mainQuery = CrmHelper.fetchToQuery(service, fetch);
queryContainer root = new queryContainer
{
isRoot = true,
expression = mainQuery,
entityLogicalName = mainQuery.EntityName,
ExcludeFromResults = excludeFromResults
};
return(root);
}
public static SchemaField getFieldFromSchema(SchemaEntities entities, string entityName, string fieldName)
{
SchemaEntity entity = entities.entities.FirstOrDefault(e => e.name == entityName);
if (ReferenceEquals(entity, null))
{
return(null);
}
SchemaField field = entity.fields.FirstOrDefault(f => f.name == fieldName);
if (ReferenceEquals(field, null))
{
return(null);
}
return(field);
}
/// <summary>
/// Depricated
/// </summary>
/// <param name="service"></param>
/// <param name="listOfEntities_DS"></param>
/// <param name="fetch"></param>
/// <param name="exequteAsSeparateLinkedQueries"></param>
/// <param name="collectAllReferences"></param>
/// <param name="excludeFromResults"></param>
/// <returns></returns>
internal static queryContainer transformFetch(CrmServiceClient service, SchemaEntities listOfEntities_DS, string fetch, bool exequteAsSeparateLinkedQueries, bool collectAllReferences, bool excludeFromResults)
{
QueryExpression mainQuery = CrmHelper.fetchToQuery(service, fetch);
queryContainer root = new queryContainer
{
isRoot = true,
expression = mainQuery,
entityLogicalName = mainQuery.EntityName,
ExequteAsSeparateLinkedQueries = exequteAsSeparateLinkedQueries,
CollectAllReferences = collectAllReferences,
ExcludeFromResults = excludeFromResults
};
//return whole query
if (!exequteAsSeparateLinkedQueries)
{
return(root);
}
return(transformToSeparateQueries(service, listOfEntities_DS, root));
}
private static queryContainer transformToSeparateQueries(CrmServiceClient service, SchemaEntities listOfEntities_DS, queryContainer mainQuery)
{
QueryExpression exp = mainQuery.expression;
DataCollection <LinkEntity> linkEntities = exp.LinkEntities;
//created modified query
QueryExpression _1stLevel = new QueryExpression(exp.EntityName);
_1stLevel.ColumnSet = exp.ColumnSet;
_1stLevel.Criteria = exp.Criteria;
_1stLevel.NoLock = true;
_1stLevel.ExtensionData = exp.ExtensionData;
queryContainer _1stleveQuery = new queryContainer
{
expression = _1stLevel,
entityLogicalName = exp.EntityName,
linkedExpressions = new List <queryContainer>(),
ExequteAsSeparateLinkedQueries = mainQuery.ExequteAsSeparateLinkedQueries,
CollectAllReferences = mainQuery.CollectAllReferences,
ExcludeFromResults = mainQuery.ExcludeFromResults,
masterEntityLogicalName = mainQuery.masterEntityLogicalName,
masterEntityLookUpName = mainQuery.masterEntityLookUpName,
RelationShipType = mainQuery.RelationShipType,
references = mainQuery.references,
primaryKeyName = mainQuery.primaryKeyName
};
//check link entities presence
if (ReferenceEquals(linkEntities, null) || linkEntities.Count == 0)
{
return(_1stleveQuery);
}
//transform link entities to queries
List <queryContainer> linkedExpressions = transformLinkEntitiesToQueries(service, listOfEntities_DS, linkEntities, _1stleveQuery);
if (!ReferenceEquals(linkedExpressions, null) && linkedExpressions.Count > 0)
{
_1stleveQuery.linkedExpressions.AddRange(linkedExpressions);
}
return(_1stleveQuery);
}
private static List <queryContainer> transformLinkEntitiesToQueries(CrmServiceClient service, SchemaEntities listOfEntities_DS, DataCollection <LinkEntity> linkEntities, queryContainer upper)
{
List <queryContainer> result = new List <queryContainer>();
foreach (LinkEntity le in linkEntities)
{
queryContainer current = new queryContainer
{
isRoot = false,
masterEntityLogicalName = upper.entityLogicalName,
entityLogicalName = le.LinkToEntityName,
ExequteAsSeparateLinkedQueries = upper.ExequteAsSeparateLinkedQueries,
CollectAllReferences = upper.CollectAllReferences
};
SchemaField attr = GlobalHelper.getFieldFromSchema(listOfEntities_DS, le.LinkToEntityName, le.LinkToAttributeName);
if (ReferenceEquals(attr, null))
{
throw new Exception("Entity '" + le.LinkToEntityName + "' and its attribute '" + le.LinkToEntityName + "' are absent in source schema file");
}
string attrType = attr.primaryKey ? "pk" : attr.type;
//n:1 entity : linkedEntity
if (attrType == "pk")
{
current.RelationShipType = relationShipType.Lookup;
//recurse to first level
FilterExpression filter = new FilterExpression(LogicalOperator.And);
filter.AddFilter(le.LinkCriteria);
////move to crm helprer to query
//ConditionExpression cond = new ConditionExpression(attr.name, ConditionOperator.Equal, upper.references[le.LinkToAttributeName] - is null);
current.expression = transformLinkToQueryExpression(le);
//update filter
current.expression.Criteria = filter;
//add a column to get lookup in resultset
upper.expression.ColumnSet.AddColumn(le.LinkFromAttributeName);
current.masterEntityLogicalName = le.LinkFromEntityName;
current.entityLogicalName = le.LinkToEntityName;
current.masterEntityLookUpName = le.LinkFromAttributeName;
current.primaryKeyName = le.LinkToAttributeName;
result.Add(transformToSeparateQueries(service, listOfEntities_DS, current));
}
//1:n entity : linkedEntity
else
{
current.RelationShipType = relationShipType.Child;
current.masterEntityLookUpName = attr.name;
QueryExpression linkEntityQuiery = new QueryExpression(le.LinkToEntityName);
////move to crm helprer to query
//ConditionExpression cond = new ConditionExpression(attr.name, ConditionOperator.Equal, current.masterEntityLookUpID);
FilterExpression filter = new FilterExpression(LogicalOperator.And);
//filter.AddCondition(cond);
linkEntityQuiery.ColumnSet = le.Columns;
filter.AddFilter(le.LinkCriteria);
linkEntityQuiery.Criteria = filter;
linkEntityQuiery.NoLock = true;
linkEntityQuiery.ExtensionData = le.ExtensionData;
current.expression = linkEntityQuiery;
if (!ReferenceEquals(le.LinkEntities, null) && le.LinkEntities.Count > 0)
{
//recurse to itself
List <queryContainer> subQueries = transformLinkEntitiesToQueries(service, listOfEntities_DS, le.LinkEntities, current);
if (!ReferenceEquals(subQueries, null) && subQueries.Count > 0)
{
result.AddRange(subQueries);
}
}
result.Add(current);
}
}
return(result);
}
public bool SchemaExists(string schemaName)
{
return(SchemaEntities.Any(q => q.SchemaName == schemaName));
}