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