public T ObterPor(Guid itbc_paisid) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_paisid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_paisid); query.Criteria.Conditions.Add(cond1); #endregion var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public List <T> ListarPorUsuarioDesabilitado(Guid userId) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("systemuserid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, userId); query.Criteria.AddCondition(cond1); //apenas users não habilitados query.Criteria.AddCondition("isdisabled", ConditionOperator.Equal, true); #endregion #region Ordenação 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 Processo, int Ordem) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_processoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, Processo); query.Criteria.Conditions.Add(cond1); Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_ordem", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, Ordem); query.Criteria.Conditions.Add(cond2); Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statuscode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 1); query.Criteria.Conditions.Add(cond3); 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 T ObterPor(Guid CompromissosDoCanalId) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_compdocanalid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, CompromissosDoCanalId); query.Criteria.Conditions.Add(cond1); //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 ObterPorNome(String nome) { var query = GetQueryExpression <T>(true); #region Condições ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_name", ConditionOperator.Equal, nome); query.Criteria.Conditions.Add(cond1); query.Criteria.AddCondition("statecode", ConditionOperator.Equal, (int)Domain.Enum.AcessoKonviva.StateCode.Ativo); #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); query.ColumnSet.AddColumn("createdby"); query.ColumnSet.AddColumn("createdon"); query.ColumnSet.AddColumn("text"); 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.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("source", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, 2); query.Criteria.Conditions.Add(cond2); Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("createdon", Microsoft.Xrm.Sdk.Query.OrderType.Descending); query.Orders.Add(ord1); return((List <T>) this.RetrieveMultiple(query).List); }
public T ObterAtivoInativoPor(Guid produtoSolicitacaoId) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_produtosdasolicitacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, produtoSolicitacaoId); 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 List <T> ListarPor(List <Guid> BeneficiosProg, Guid Canal, Guid UnidadeNegocios, Guid?Categoria) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_beneficioid", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, BeneficiosProg); 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, Canal); query.Criteria.Conditions.Add(cond2); Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_businessunitid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, UnidadeNegocios); query.Criteria.Conditions.Add(cond3); if (Categoria.HasValue) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_categoriaid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, Categoria); query.Criteria.Conditions.Add(cond4); } return((List <T>) this.RetrieveMultiple(query).List); }
public T ObterPor(Guid idUnidadeKonviva) { var query = GetQueryExpression <T>(true); #region Condições ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_unidadedokonvivaid", ConditionOperator.Equal, idUnidadeKonviva); query.Criteria.Conditions.Add(cond1); query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0); #endregion var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public T ObterPorTipoDeSolicitacao(Guid TipoDeSolicitacaoId, Guid?BeneficioPrograma) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_tipodesolicitacaoid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, TipoDeSolicitacaoId); query.Criteria.Conditions.Add(cond1); if (BeneficioPrograma.HasValue) { ConditionExpression cond2 = new ConditionExpression("itbc_beneficiodoprogramaid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, BeneficioPrograma.Value); query.Criteria.Conditions.Add(cond2); } var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public List <T> ObterRespostasConta(string contaId, bool status) { var query = GetQueryExpression <T>(true); #region Condições if (status) { 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 (contaId != null) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_questionario_resposta_conta_id", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, contaId); query.Criteria.Conditions.Add(cond3); } #endregion return((List <T>) this.RetrieveMultiple(query).List); }
public List <T> ListarQuestionarioPerguntaPorQuestionario(string questionarioId) { var query = GetQueryExpression <T>(true); #region Condições #region Status query.Criteria.Conditions.Add(new ConditionExpression("statecode", ConditionOperator.Equal, (int)Domain.Enum.StateCode.Ativo)); #endregion Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_questionario_id", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, questionarioId); query.Criteria.Conditions.Add(cond1); #endregion #region Ordenações OrderExpression ord1 = new OrderExpression("itbc_ordem", OrderType.Ascending); query.Orders.Add(ord1); #endregion return((List <T>) this.RetrieveMultiple(query).List); }
public T ObterPor(Guid categoriaId) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_categoria", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, categoriaId); query.Criteria.Conditions.Add(cond1); #endregion ConditionExpression condAtivo = new ConditionExpression("statuscode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.Status.Ativo); query.Criteria.Conditions.Add(condAtivo); var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public T ObterPor(string CodTransportadora) { 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, CodTransportadora); 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 ObterPor(Guid itbc_configuracaodebeneficioid) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_configuracaodebeneficioid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_configuracaodebeneficioid); 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 List <T> ListarPor(Guid referenteA, Guid tipoAtividade, DateTime?dtInicial, DateTime?dtFim, int?situacao) { var query = GetQueryExpression <T>(true); #region CRiteria Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("regardingobjectid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, referenteA); query.Criteria.Conditions.Add(cond2); if (!tipoAtividade.Equals(Guid.Empty)) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_tipoatividadeid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, tipoAtividade); query.Criteria.Conditions.Add(cond1); } if (dtInicial.HasValue) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond3 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("createdon", Microsoft.Xrm.Sdk.Query.ConditionOperator.GreaterEqual, dtInicial); query.Criteria.Conditions.Add(cond3); } if (dtFim.HasValue) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond4 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("createdon", Microsoft.Xrm.Sdk.Query.ConditionOperator.LessEqual, dtFim); query.Criteria.Conditions.Add(cond4); } if (situacao.HasValue) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond5 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, situacao.Value); query.Criteria.Conditions.Add(cond5); } #endregion Microsoft.Xrm.Sdk.Query.OrderExpression ord1 = new Microsoft.Xrm.Sdk.Query.OrderExpression("overriddencreatedon", Microsoft.Xrm.Sdk.Query.OrderType.Ascending); query.Orders.Add(ord1); return((List <T>) this.RetrieveMultiple(query).List); }
public T ObterPor(Guid beneficioId) { 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, beneficioId); query.Criteria.Conditions.Add(cond1); query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0); 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 pedidoEMS, 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_pedido_ems", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, pedidoEMS); query.Criteria.Conditions.Add(cond1); #endregion var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public T ObterPorChaveIntegracao(string itbc_chave_integracao) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_chave_integracao", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, itbc_chave_integracao); 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 var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public T ObterPorNumeroNF(String numeroNF) { var query = GetQueryExpression <T>(true); #region Condições Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("invoicenumber", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, numeroNF); 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 T ObterPorContato(Guid contatoId, Domain.Enum.StateCode status) { var query = GetQueryExpression <T>(true); #region Condições #region Status query.Criteria.Conditions.Add(new ConditionExpression("statecode", ConditionOperator.Equal, (int)status)); #endregion ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_contatoid", ConditionOperator.Equal, contatoId); query.Criteria.Conditions.Add(cond1); #endregion var colecao = this.RetrieveMultiple(query); if (colecao.List.Count == 0) { return(default(T)); } return(colecao.List[0]); }
public List <T> ListarDenuncias(DateTime dtInicio, DateTime dtFim, List <Guid> lstDenunciantes, List <Guid> lstDenunciados, Guid?representanteId, int?situacaoDenuncia) { var query = GetQueryExpression <T>(true); if (lstDenunciantes.Count > 0) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_canaldenuncianteid", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, lstDenunciantes); query.Criteria.Conditions.Add(cond1); } if (lstDenunciados.Count > 0) { Microsoft.Xrm.Sdk.Query.ConditionExpression cond2 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_account", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, lstDenunciados); query.Criteria.Conditions.Add(cond2); } if (situacaoDenuncia.HasValue) { query.Criteria.AddCondition("itbc_status", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, situacaoDenuncia); } if (representanteId.HasValue) { query.Criteria.AddCondition("itbc_keyaccountourepresentanteid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, representanteId); } //Data query.Criteria.AddCondition("createdon", ConditionOperator.GreaterEqual, dtInicio); query.Criteria.AddCondition("createdon", ConditionOperator.LessThan, dtFim.AddDays(1)); //Status query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.Denuncia.Status.Ativo); return((List <T>) this.RetrieveMultiple(query).List); }
public T ObterPorIdTurma(String identificadorTurma) { var query = GetQueryExpression <T>(true); #region Condições ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_idturma", ConditionOperator.Equal, identificadorTurma); query.Criteria.Conditions.Add(cond1); #endregion #region Ordenação OrderExpression ord1 = new 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 colaboradorTreinId) { var query = GetQueryExpression <T>(true); Microsoft.Xrm.Sdk.Query.ConditionExpression cond1 = new Microsoft.Xrm.Sdk.Query.ConditionExpression("itbc_colaboradorestreincertid", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, colaboradorTreinId); query.Criteria.Conditions.Add(cond1); query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0); 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]); throw new NotImplementedException(); }