public T ObterPor(String itbc_codigo_natureza_operacao)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_codigo_natureza_operacao", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_codigo_natureza_operacao);
query.Criteria.Conditions.Add(cond1);
query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 0);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public List <T> ListarPorConta(Guid itbc_solicitacaodecadastroid, DateTime?dtInicio, DateTime?dtFim, int?status)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_keyaccountourepresentanteid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_solicitacaodecadastroid.ToString());
query.Criteria.Conditions.Add(cond1);
if (status.HasValue)
{
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statuscode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, status.Value);
query.Criteria.Conditions.Add(cond2);
}
if (dtInicio.HasValue && dtFim.HasValue)
{
Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("createdon", Microsoft.Xrm.Sdk.Query.ConditionOperator.GreaterEqual, dtInicio.Value);
query.Criteria.Conditions.Add(cond3);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("createdon", Microsoft.Xrm.Sdk.Query.ConditionOperator.LessEqual, dtFim.Value);
query.Criteria.Conditions.Add(cond4);
}
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid itbc_indiceid, Guid?itbc_tabeladefinanciamento)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_indiceid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_indiceid);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Validações
if (itbc_tabeladefinanciamento.HasValue)
{
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_tabeladefinanciamento", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_tabeladefinanciamento);
query.Criteria.Conditions.Add(cond2);
}
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
var lista = (List <T>) this.RetrieveMultiple(query).List;
return(lista);
}
//List<T> ListarPor(Guid portfolioId);
public List <T> ListarPor(Guid portfolioId, List <Guid> lstSegmentoId)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_portfolioid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, portfolioId);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 0);
query.Criteria.Conditions.Add(cond2);
if (lstSegmentoId != null)
{
if (lstSegmentoId.Count > 0)
{
var link = query.AddLink("product", "itbc_productid", "productid");
Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_segmentoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, lstSegmentoId);
link.LinkCriteria.Conditions.Add(cond3);
}
}
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(int?stateCode, bool?participaPrograma)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, stateCode);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_participadoprogramadecanais", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, participaPrograma);
#endregion
#region Validações
if (stateCode.HasValue)
{
query.Criteria.Conditions.Add(cond1);
}
if (participaPrograma.HasValue)
{
query.Criteria.Conditions.Add(cond2);
}
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(String name)
{
var query = GetQueryExpression <T>(true);
query.Criteria.AddCondition("name", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, name);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiplePaged(query).List);
}
public List <T> ListarPor(String SolicitacaoCadastroNome)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_name", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, SolicitacaoCadastroNome);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid TipoDeAtividade)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_tipoatividade", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, TipoDeAtividade);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid sharepointsiteid)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("sharepointsiteid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, sharepointsiteid);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(string[] codigo)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_codigo_grupo_estoque", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, codigo);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid guid)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_tabelaprecob2bid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, guid);
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(string nome)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("name", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, nome);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid accountid)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_fornecedordocanalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, accountid);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid?funcaoAte, Guid?conectadoA, Guid?funcaoDe, Guid?conectadoDe)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("record2roleid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, funcaoAte);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("record2id", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, conectadoA);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("record1roleid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, funcaoDe);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("record1id", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, conectadoDe);
#endregion
#region Validações
if (funcaoAte.HasValue)
{
query.Criteria.Conditions.Add(cond1);
}
if (conectadoA.HasValue)
{
query.Criteria.Conditions.Add(cond2);
}
if (funcaoDe.HasValue)
{
query.Criteria.Conditions.Add(cond3);
}
if (conectadoDe.HasValue)
{
query.Criteria.Conditions.Add(cond4);
}
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Int32 codigoportador)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_codigo_portador", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, codigoportador);
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(List <Guid> listId)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_portfolioid", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, listId);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 0);
query.Criteria.Conditions.Add(cond2);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public T ObterPor(Guid tipoAcessoExtranet)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_tipoacessoextranetid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, tipoAcessoExtranet);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public T ObterPor(String relativeUrl)
{
var query = GetQueryExpression <T>(true);
//Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("relativeurl", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, relativeUrl);
//query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public T ObterPor()
{
var query = GetQueryExpression <T>(true);
//Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("sharepointsiteid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, sharepointsiteid);
query.Criteria.Conditions.Add(new Microsoft.Xrm.Sdk.Query.ConditionExpression("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.StateCode.Ativo));
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public T ObterPor(Guid queueitemid)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("queueitemid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, queueitemid);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("subject", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public List <T> ListarPor(String[] conjNomes)
{
var query = GetQueryExpression <T>(true);
query.ColumnSet.Columns.Add("name");
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("name", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, conjNomes);
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiplePaged(query).List);
}
public List <T> ObterPor(String[] conjCodigosNatureza)
{
var query = GetQueryExpression <T>(true);
query.ColumnSet.Columns.Add("itbc_codigo_natureza_operacao");
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_codigo_natureza_operacao", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, conjCodigosNatureza);
query.Criteria.Conditions.Add(cond1);
query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 0);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiplePaged(query).List);
}
public T ObterPor(int codigoCategoriaB2B)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_codigocategoriab2b", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, codigoCategoriaB2B);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public T ObterPor(Guid itbc_regiaogeoId)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_regiaogeoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_regiaogeoId);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_regiaogeoid", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public List <T> ListarPor(Guid?itbc_relacionamentodob2bid)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_relacionamentodob2bid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_relacionamentodob2bid);
#endregion
#region Validações
if (itbc_relacionamentodob2bid.HasValue)
{
query.Criteria.Conditions.Add(cond1);
}
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid?itbc_accountid, DateTime?itbc_datacriacao, string itbc_url, bool?itbc_somentearquivosnovos, DateTime?itbc_datainicial, DateTime?itbc_datafinal)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_accountid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_accountid);
query.Criteria.Conditions.Add(cond1);
if (itbc_datacriacao.HasValue)
{
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_datadeenvio", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_datacriacao.Value);
query.Criteria.Conditions.Add(cond2);
}
Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_url", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_url);
query.Criteria.Conditions.Add(cond3);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_somentearquivosnovos", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_somentearquivosnovos);
query.Criteria.Conditions.Add(cond4);
if (itbc_datainicial.HasValue)
{
Microsoft.Xrm.Sdk.Query.ConditionExpression cond5 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_datainicial", Microsoft.Xrm.Sdk.Query.ConditionOperator.GreaterEqual, itbc_datainicial.Value);
query.Criteria.Conditions.Add(cond5);
}
if (itbc_datafinal.HasValue)
{
Microsoft.Xrm.Sdk.Query.ConditionExpression cond6 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_datafinal", Microsoft.Xrm.Sdk.Query.ConditionOperator.LessEqual, itbc_datafinal.Value);
query.Criteria.Conditions.Add(cond6);
}
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_name", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
// public static Dictionary<string, Microsoft.Xrm.Sdk.EntityCollection> EntityCollectionCached = new Dictionary<string, Microsoft.Xrm.Sdk.EntityCollection>();
//https://msdn.microsoft.com/en-us/library/mt269606.aspx
public static Microsoft.Xrm.Sdk.EntityCollection RetrieveAll(Microsoft.Xrm.Sdk.IOrganizationService serviceOrgnization, string entityName
, string columnSet = "", string filter = "", int retrievedNumberOfRecords = 50, string orderBy = "", int pageNumber = 1, string pagingCookie = null)
{
Microsoft.Xrm.Sdk.EntityCollection retVal = null;
string uniqueRecordString = $"{entityName} '{columnSet}' '{filter}' {retrievedNumberOfRecords} '{orderBy}' {pageNumber} ";
/*
* if (EntityCollectionCached.ContainsKey(uniqueRecordString))
* {
* return EntityCollectionCached[uniqueRecordString];
* }*/
// Query using the paging cookie.
// Define the paging attributes.
// The number of records per page to retrieve.
int queryCount = retrievedNumberOfRecords;
// Create the query expression and add condition.
Microsoft.Xrm.Sdk.Query.QueryExpression pagequery = new Microsoft.Xrm.Sdk.Query.QueryExpression();
pagequery.EntityName = entityName;
filter = filter.ToLower();
if (!string.IsNullOrEmpty(filter) && !string.IsNullOrWhiteSpace(filter) && filter != "null")
{
string[] conditionsStr = filter.Split(new string[] { "&" }, StringSplitOptions.None);
foreach (string conditionStr in conditionsStr)
{
string[] conditionStrs = conditionStr.Split('=');
string conditionAttributeName = conditionStrs[0];
bool isNot = false;
if (conditionAttributeName.EndsWith("!"))
{
isNot = true;
conditionAttributeName = conditionAttributeName.Replace("!", "");
}
string conditionAttributeValue = conditionStrs[1];
// Define the condition expression for retrieving records.
Microsoft.Xrm.Sdk.Query.ConditionExpression pagecondition = new Microsoft.Xrm.Sdk.Query.ConditionExpression();
pagecondition.AttributeName = conditionAttributeName;
if (conditionAttributeValue.StartsWith("(") && conditionAttributeValue.EndsWith(")"))
{
conditionAttributeValue = conditionAttributeValue.Replace("(", "").Replace(")", "");
pagecondition.Operator = isNot ? Microsoft.Xrm.Sdk.Query.ConditionOperator.NotIn : Microsoft.Xrm.Sdk.Query.ConditionOperator.In;
foreach (var val in conditionAttributeValue.Split(','))
{
pagecondition.Values.Add(val);
}
}
else if (conditionAttributeValue.StartsWith("%") && conditionAttributeValue.EndsWith("%"))
{
pagecondition.Operator = isNot ? Microsoft.Xrm.Sdk.Query.ConditionOperator.NotLike : Microsoft.Xrm.Sdk.Query.ConditionOperator.Like;
pagecondition.Values.Add(conditionAttributeValue);
}
else if (conditionAttributeValue.StartsWith(">"))
{
object objConditionAttributeValue = AttributeManager.GetAttributeValueFromString(serviceOrgnization, entityName, conditionAttributeName, conditionAttributeValue.Replace("<", "").Replace(">", ""));
pagecondition.Operator = Microsoft.Xrm.Sdk.Query.ConditionOperator.GreaterEqual;
pagecondition.Values.Add(objConditionAttributeValue);
}
else if (conditionAttributeValue.StartsWith("<"))
{
object objConditionAttributeValue = AttributeManager.GetAttributeValueFromString(serviceOrgnization, entityName, conditionAttributeName, conditionAttributeValue.Replace("<", "").Replace(">", ""));
pagecondition.Operator = Microsoft.Xrm.Sdk.Query.ConditionOperator.LessEqual;
pagecondition.Values.Add(objConditionAttributeValue);
}
else
{
object objConditionAttributeValue = AttributeManager.GetAttributeValueFromString(serviceOrgnization, entityName, conditionAttributeName, conditionAttributeValue);
pagecondition.Operator = isNot ? Microsoft.Xrm.Sdk.Query.ConditionOperator.NotEqual : Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal;
pagecondition.Values.Add(objConditionAttributeValue);
}
pagequery.Criteria.AddCondition(pagecondition);
}
}
// Define the order expression to retrieve the records.
if (!string.IsNullOrEmpty(orderBy))
{
orderBy = orderBy.ToLower();
string[] orderByStrs = orderBy.Split(' ');
string orderAttributeName = orderByStrs[0];
string orderType = "desc";
if (orderByStrs.Length > 1)
{
orderType = (string.IsNullOrEmpty(orderByStrs[1]) || orderByStrs[1] != "asc") ? "desc" : "asc";
}
Microsoft.Xrm.Sdk.Query.OrderExpression order = new Microsoft.Xrm.Sdk.Query.OrderExpression();
order.AttributeName = orderAttributeName;
order.OrderType = (orderType == "desc") ? Microsoft.Xrm.Sdk.Query.OrderType.Ascending : Microsoft.Xrm.Sdk.Query.OrderType.Descending;
pagequery.Orders.Add(order);
}
// pagequery.ColumnSet.AddColumns("name", "emailaddress1");
//By Rasheed
string[] columns = GetColumnSet(entityName, columnSet);
pagequery.ColumnSet = new Microsoft.Xrm.Sdk.Query.ColumnSet(columns);
// end by rasheed
// Assign the pageinfo properties to the query expression.
pagequery.PageInfo = new Microsoft.Xrm.Sdk.Query.PagingInfo();
pagequery.PageInfo.Count = queryCount;
pagequery.PageInfo.PageNumber = pageNumber;
// The current paging cookie. When retrieving the first page,
// pagingCookie should be null.
pagequery.PageInfo.PagingCookie = pagingCookie;
// Retrieve the page.
retVal = serviceOrgnization.RetrieveMultiple(pagequery);
//EntityCollectionCached.Add(uniqueRecordString, retVal);
return(retVal);
}
