public T ObterPor(Guid itbc_compdoprogid, Guid unidNeg, Guid itbc_canalid)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_compdoprogid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_compdoprogid);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_businessunitid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, unidNeg);
query.Criteria.Conditions.Add(cond2);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_canalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_canalid);
query.Criteria.Conditions.Add(cond3);
//Status
query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.CompromissoCanal.Status.Ativo);
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(Guid itbc_solicitacaodebeneficioid, int?stateCode)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_solicitacaodebeneficioid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_solicitacaodebeneficioid);
query.Criteria.Conditions.Add(cond1);
if (stateCode.HasValue)
{
//Status Ativo
query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, stateCode.Value);
}
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 List <T> ListarKaRepresentantes(Guid?unidadenegocioId, List <Guid> lstIdContatos, int?pagina, int?contagem)
{
var query = GetQueryExpression <T>(true);
#region Condições
query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0);
query.Criteria.AddCondition("customertypecode", ConditionOperator.Equal, "993520007");
if (lstIdContatos != null && lstIdContatos.Count > 0)
{
query.Criteria.AddCondition(new ConditionExpression("contactid", ConditionOperator.NotIn, lstIdContatos));
}
if (unidadenegocioId.HasValue)
{
query.Criteria.AddCondition("itbc_unidadedenegocioid", ConditionOperator.Equal, unidadenegocioId);
}
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("firstname", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
if (pagina.HasValue && contagem.HasValue)
{
PagingInfo paging = new PagingInfo();
paging.Count = contagem.Value;
paging.PageNumber = pagina.Value;
query.PageInfo = paging;
}
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(string codigoFamiliaInicial, string codigoFamiliaFinal)
{
var query = GetQueryExpression <T>(true);
#region Condições
if (codigoFamiliaFinal != string.Empty)
{
query.Criteria.AddCondition("itbc_codigo_familia_comercial", Microsoft.Xrm.Sdk.Query.ConditionOperator.GreaterEqual, codigoFamiliaInicial);
query.Criteria.AddCondition("itbc_codigo_familia_comercial", Microsoft.Xrm.Sdk.Query.ConditionOperator.LessEqual, codigoFamiliaFinal);
}
else
{
query.Criteria.AddCondition("itbc_codigo_familia_comercial", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, codigoFamiliaInicial);
}
#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 ObterParaCalculo(Guid canalId, Guid familiaProdId)
{
var query = GetQueryExpression <T>(true);
#region Condições
query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_canalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, canalId);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_familia_produto_id", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, familiaProdId);
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 colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public T ObterPorChaveIntegracao(String chaveIntegracao, params string[] columns)
{
var query = GetQueryExpression <T>(true);
if (columns != null && columns.Length > 0)
{
query.ColumnSet.AddColumns(columns);
}
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_chave_integracao", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, chaveIntegracao);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("invoicenumber", 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> ListarPoliticasComClassificacao()
{
var query = GetQueryExpression <T>(true);
#region Condições
query.Criteria.AddCondition("itbc_classificacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.NotNull);
//Status Ativo
query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.PoliticaComercial.Status.Ativo);
//Razão do Status Ativo
query.Criteria.AddCondition("statuscode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 1);
//Data de vigencia (hoje)
query.Criteria.AddCondition("itbc_data_inicio", ConditionOperator.LessEqual, DateTime.Today);
query.Criteria.AddCondition("itbc_data_fim", ConditionOperator.GreaterEqual, DateTime.Today);
//PoliticaCoemrcialEspecifica
//query.Criteria.AddCondition("itbc_polticaespecificacanal", ConditionOperator.Equal, (int)Domain.Enum.PoliticaComercial.PoliticaEspecifica.Nao);
#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 itbc_linhadecorteid)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_linhadecorteid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_linhadecorteid);
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);
#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 T ObterPor(Guid itbc_beneficioid, Guid itbc_businessunitid, Guid itbc_canalid)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_beneficioid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_beneficioid);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_businessunitid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_businessunitid);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_canalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_canalid);
query.Criteria.Conditions.Add(cond1);
query.Criteria.Conditions.Add(cond2);
query.Criteria.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);
var colecao = this.RetrieveMultiple(query);
if (colecao.List.Count == 0)
{
return(default(T));
}
return(colecao.List[0]);
}
public T ObterPor(int CodTransportadora)
{
//formata codigo transportadora com pontos de milhar, para replicar o JS
string codigoFormatado = Intelbras.CRM2013.Domain.Servicos.Helper.formatarCasasMilhar(CodTransportadora.ToString());
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_codigodatransportadora", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, codigoFormatado);
query.Criteria.Conditions.Add(cond1);
#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 T ObterPorPoliticaEspecifica(Guid estabelecimentoId, Guid?politicaComercialId, Guid?canalId, Guid?unidadeNegocioId, Guid?classificacaoId, Guid?categoriaId)
{
var query = GetQueryExpression <T>(true);
#region Condições
query.Criteria.AddCondition("itbc_estabelecimentoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, estabelecimentoId);
if (politicaComercialId.HasValue)
{
query.Criteria.AddCondition("itbc_politicacomercialid", Microsoft.Xrm.Sdk.Query.ConditionOperator.NotEqual, politicaComercialId);
}
if (canalId.HasValue)
{
query.Criteria.AddCondition("itbc_accountid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, canalId);
}
if (unidadeNegocioId.HasValue)
{
query.Criteria.AddCondition("itbc_businessunitid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, unidadeNegocioId);
}
if (classificacaoId.HasValue)
{
query.Criteria.AddCondition("itbc_classificacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, classificacaoId);
}
if (categoriaId.HasValue)
{
query.Criteria.AddCondition("itbc_categoriaid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, categoriaId);
}
//Data de vigencia (hoje)
query.Criteria.AddCondition("itbc_data_inicio", ConditionOperator.LessEqual, DateTime.Today);
query.Criteria.AddCondition("itbc_data_fim", ConditionOperator.GreaterEqual, DateTime.Today);
//Status
query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.PoliticaComercial.Status.Ativo);
//PoliticaCoemrcialEspecifica
query.Criteria.AddCondition("itbc_polticaespecificacanal", ConditionOperator.Equal, (int)Domain.Enum.PoliticaComercial.PoliticaEspecifica.Sim);
#endregion
#region Ordenação
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_fator", Microsoft.Xrm.Sdk.Query.OrderType.Descending);
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> ListarPorReferenteA(Guid referenteA)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("regardingobjectid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, referenteA);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_ordem", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid BeneficioDoCanalID)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_benefdocanalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, BeneficioDoCanalID);
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> ListarPorBeneficioProg(Guid beneficioprogId)
{
var query = GetQueryExpression <T>(true);
query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0);
query.Criteria.AddCondition("itbc_beneficioid", ConditionOperator.Equal, beneficioprogId);
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?canalId, Guid?unidadenegocioId, Guid?classificacaoId, Guid?subclassificacaoId, Guid?CategoriaId)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_canalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, canalId);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_businessunit", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, unidadenegocioId);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_classificacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, classificacaoId);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_subclassificacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, subclassificacaoId);
// Microsoft.Xrm.Sdk.Query.ConditionExpression cond5 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_categoriasdocanalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.NotEqual, CategoriaId);
#endregion
#region Validações
if (canalId.HasValue)
{
query.Criteria.Conditions.Add(cond1);
}
if (unidadenegocioId.HasValue)
{
query.Criteria.Conditions.Add(cond2);
}
if (classificacaoId.HasValue)
{
query.Criteria.Conditions.Add(cond3);
}
if (subclassificacaoId.HasValue)
{
query.Criteria.Conditions.Add(cond4);
}
ConditionExpression condAtivo = new ConditionExpression("statecode", (int)Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 0);
query.Criteria.Conditions.Add(condAtivo);
//if (CategoriaId.HasValue)
// query.Criteria.Conditions.Add(cond5);
#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(int statecode)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, statecode);
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 TarefaId)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("activityid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, TarefaId);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("itbc_ordem", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarAcessosAtivosPorContato(Guid contatoId)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_contactid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, contatoId);
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.AddCondition(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> ListarPorCanalCompromisso(Guid itbc_canalid, Guid itbc_compdoprogid)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_compdoprogid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_compdoprogid);
query.Criteria.Conditions.Add(cond1);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_canalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_canalid);
query.Criteria.Conditions.Add(cond2);
//Status
query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.CompromissoCanal.Status.Ativo);
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> ListarAssociadosA(string codigoConta)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("parentcustomerid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, codigoConta);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("firstname", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPorCodigoRepresentante(string codigoRepresentante)
{
var query = GetQueryExpression <T>(true);
#region Condições
ConditionExpression cond1 = new ConditionExpression("itbc_codigodorepresentante", ConditionOperator.Equal, codigoRepresentante);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("firstname", Microsoft.Xrm.Sdk.Query.OrderType.Ascending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPor(Guid discounttypeid)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("discounttypeid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, discounttypeid);
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(String codigoFamiliaProduto)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_codigo_subfamilia", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, codigoFamiliaProduto);
query.Criteria.Conditions.Add(cond1);
#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.RetrieveMultiple(query).List);
}
public List <T> ListarPor(string ChaveIntegracao)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_chavedeintegracao", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, ChaveIntegracao);
query.Criteria.Conditions.Add(cond1);
#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.RetrieveMultiple(query).List);
}
public List <T> ListarPorSigla(String siglaUF)
{
var query = GetQueryExpression <T>(true);
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_siglauf", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, siglaUF);
query.Criteria.Conditions.Add(cond1);
#endregion
#region Ordenações
Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("modifiedon", Microsoft.Xrm.Sdk.Query.OrderType.Descending);
query.Orders.Add(ord1);
#endregion
return((List <T>) this.RetrieveMultiple(query).List);
}
public List <T> ListarPorFamilia(Guid familiaGuid)
{
var query = GetQueryExpression <T>(true);
#region Condições
query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_familia_produto_id", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, familiaGuid);
query.Criteria.Conditions.Add(cond1);
#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.RetrieveMultiple(query).List);
}
public T ObterPorBenCanalId(Guid beneficioCanalId)
{
var query = GetQueryExpression <T>(true);
query.Criteria.AddCondition("itbc_benefdocanalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, beneficioCanalId.ToString());
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 List <T> ObterPorChaveIntegracao(string[] conjChavesIntegracao)
{
var query = GetQueryExpression <T>(true);
query.ColumnSet.Columns.Add("itbc_chave_integracao");
#region Condições
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_chave_integracao", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, conjChavesIntegracao);
query.Criteria.Conditions.Add(cond1);
#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 T ObterPor(Guid activityid)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("activityid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, activityid);
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 T ObterPor(Guid ParticipantesDoProcessoId)
{
var query = GetQueryExpression <T>(true);
Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_participantedoprocessoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, ParticipantesDoProcessoId);
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]);
}
