public void EndsWithTest() { object value = "endswithtest"; var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.EndsWith, "TeST"); Assert.IsTrue(value.EndsWith(filter.Values)); }
public void ContainsTest() { object value = "startswithtest"; var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.Contains, "wItH"); Assert.IsTrue(value.Contains(filter.Values)); }
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 void BeginsWithTest() { // does start with test object value = "startswithtest"; var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.BeginsWith, "StarTs"); Assert.IsTrue(value.BeginsWith(filter.Values)); // null values never match BeginsWith value = null; Assert.IsFalse(value.BeginsWith(filter.Values)); // non string never in value is an argument exception value = 4536M; Assert.ThrowsException <ArgumentException>(() => value.BeginsWith(filter.Values)); // null in values is an argument exception value = "start"; Assert.ThrowsException <ArgumentException>(() => value.BeginsWith(null)); // empty values is an argument exception filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.BeginsWith); Assert.ThrowsException <ArgumentException>(() => value.BeginsWith(filter.Values)); // filter value not a string is an argument exception filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.BeginsWith, 567M); Assert.ThrowsException <ArgumentException>(() => value.BeginsWith(filter.Values)); // filter value not a string is an argument exception filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.BeginsWith, new string[] { "", "" }); Assert.ThrowsException <ArgumentException>(() => value.BeginsWith(filter.Values)); }
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]); }
//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 T ObterPorAssistente(Guid Canal, Guid Assistente) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_assistenteid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, Assistente); query.Criteria.Conditions.Add(cond2); Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_accountid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, Canal); query.Criteria.Conditions.Add(cond3); Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_datainicial", Microsoft.Xrm.Sdk.Query.ConditionOperator.LessEqual, DateTime.Today); query.Criteria.Conditions.Add(cond4); Microsoft.Xrm.Sdk.Query.ConditionExpression cond5 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_datafinal", Microsoft.Xrm.Sdk.Query.ConditionOperator.GreaterEqual, DateTime.Today); query.Criteria.Conditions.Add(cond5); #endregion var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public T ObterPor(Guid classificacaoid, Guid categoriaid, string Cargo) { //- Nome = contenha a palavra "Gestor" //- Classificao = Classificação da Conta //- Categoria = Categoria da Conta //- Status = Ativo var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_classificacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, classificacaoid); query.Criteria.Conditions.Add(cond1); Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_categoriaid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, categoriaid); query.Criteria.Conditions.Add(cond2); Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 0); query.Criteria.Conditions.Add(cond3); Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_name", Microsoft.Xrm.Sdk.Query.ConditionOperator.Like, "%" + Cargo + "%"); query.Criteria.Conditions.Add(cond4); var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
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(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); }
public List <T> ListarPorNome(String nomeEquipe) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("name", Microsoft.Xrm.Sdk.Query.ConditionOperator.BeginsWith, nomeEquipe); query.Criteria.Conditions.Add(cond1); return((List <T>) this.RetrieveMultiple(query).List); }
public List <T> ListarPor(Guid PerfilId) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_perfilid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, PerfilId); query.Criteria.Conditions.Add(cond1); return((List <T>) this.RetrieveMultiple(query).List); }
public List <T> Listar() { var query = GetQueryExpression <T>(true); //Status Ativo Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression( "statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.TipoDeDenuncia.status.Ativo); query.Criteria.Conditions.Add(cond1); 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("accountid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, accountid); query.Criteria.Conditions.Add(cond1); #endregion return((List <T>) this.RetrieveMultiple(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 void ContainValuesTest() { var value = new Microsoft.Xrm.Sdk.OptionSetValueCollection(); value.Add(new Microsoft.Xrm.Sdk.OptionSetValue(1)); value.Add(new Microsoft.Xrm.Sdk.OptionSetValue(2)); var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.ContainValues, new int[] { 1, 2 }); Assert.IsTrue(value.ContainValues(filter.Values)); filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.ContainValues, new int[] { 1, 2, 3 }); Assert.IsFalse(value.ContainValues(filter.Values)); }
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 T ObterPor(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); var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
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 T ObterPor(Guid TeamMembershipId) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("teamid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, TeamMembershipId); query.Criteria.Conditions.Add(cond1); var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
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(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 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 T ObterPor(string codigo_tabela) { var query = GetQueryExpression <T>(true); query.TopCount = 1; #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_tabelaprecoems", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, codigo_tabela); query.Criteria.Conditions.Add(cond1); #endregion var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public void EqualTest() { { var ent1 = new Microsoft.Xrm.Sdk.EntityReference(Entities.Account.EntityLogicalName, Guid.NewGuid()); var ent2 = new Microsoft.Xrm.Sdk.EntityReference(Entities.Account.EntityLogicalName, ent1.Id); Assert.IsTrue(ent1.Equals(ent2)); } { object value = "equaltest"; var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, "equalTEST"); Assert.IsTrue(value.Equal(filter.Values)); } { object value = 10; var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 10); Assert.IsTrue(value.Equal(filter.Values)); } { object value = new Microsoft.Xrm.Sdk.Money(10M); var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 10M); Assert.IsTrue(value.Equal(filter.Values)); } { var value = new Microsoft.Xrm.Sdk.EntityReference(Entities.Contact.EntityLogicalName, Guid.NewGuid()); var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, value.Id); Assert.IsTrue(value.Equal(filter.Values)); } { var value = new Microsoft.Xrm.Sdk.EntityReference(Entities.Contact.EntityLogicalName, Guid.NewGuid()); var v2 = new Microsoft.Xrm.Sdk.EntityReference(Entities.Contact.EntityLogicalName, value.Id); var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, v2); Assert.IsTrue(value.Equal(filter.Values)); } { var value = new Microsoft.Xrm.Sdk.EntityReference(Entities.Contact.EntityLogicalName, Guid.NewGuid()); var v2 = new Microsoft.Xrm.Sdk.EntityReference(Entities.Account.EntityLogicalName, value.Id); var filter = new Microsoft.Xrm.Sdk.Query.ConditionExpression("value", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, v2); Assert.IsFalse(value.Equal(filter.Values)); } }
public List <T> ListarPorConfigurado(Guid?classificacaoId, Guid?unidadenegocioId, Guid?categoriaId, Boolean?Exclusividade) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_classificacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, classificacaoId); Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_businessunitid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, unidadenegocioId); Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_categoriaid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, categoriaId); Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_exclusividade", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, Exclusividade); Microsoft.Xrm.Sdk.Query.ConditionExpression cond5 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_status", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.Pefil.Status.Configurado); #endregion #region Validações if (classificacaoId.HasValue) { query.Criteria.Conditions.Add(cond1); } if (unidadenegocioId.HasValue) { query.Criteria.Conditions.Add(cond2); } if (categoriaId.HasValue) { query.Criteria.Conditions.Add(cond3); } if (Exclusividade.HasValue) { query.Criteria.Conditions.Add(cond4); } query.Criteria.Conditions.Add(cond5); #endregion return((List <T>) this.RetrieveMultiple(query).List); }