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