public Entity[] RetriveAllActiveEntity(string entityName, params string[] cols)
{
QueryExpression query = new QueryExpression
{
EntityName = entityName,
ColumnSet = new ColumnSet(cols),
};
//query.Criteria.AddCondition(new ConditionExpression("statuscode",ConditionOperator.Equal,0));
DataCollection <Entity> arr = CRMOrganizationService.RetrieveMultiple(query).Entities;
return(arr.ToArray());
}
public Entity[] RetrvieAllEntitiesIn(string entityName, string fieldName, string containValue, params string[] cols)
{
QueryExpression query = new QueryExpression
{
EntityName = entityName,
ColumnSet = new ColumnSet(cols)
};
query.Criteria.AddCondition(new ConditionExpression {
AttributeName = fieldName,
Operator = ConditionOperator.Like,
Values = { containValue + "%" }
});
DataCollection <Entity> arr = CRMOrganizationService.RetrieveMultiple(query).Entities;
Log("Result count: {0}", arr.Count);
return(arr.ToArray());
}
public Entity[] RetriveAllEntity(string entityName, Tuple <string, object>[] arrTuple, params string[] cols)
{
QueryExpression query = new QueryExpression
{
EntityName = entityName,
ColumnSet = new ColumnSet(cols),
};
foreach (Tuple <string, object> tuple in arrTuple)
{
query.Criteria.AddCondition(new ConditionExpression
{
AttributeName = tuple.Item1,
Operator = ConditionOperator.Equal,
Values = { tuple.Item2 }
});
Log("Retrieve from {0}: {1} == {2}", entityName, tuple.Item1, tuple.Item2);
}
DataCollection <Entity> arr = CRMOrganizationService.RetrieveMultiple(query).Entities;
Log("Result count: {0}", arr.Count);
return(arr.ToArray());
}