public List <T> ListarAtivosVencidosCumpridos(Intelbras.CRM2013.Domain.Enum.CompromissoPrograma.TipoMonitoramento tipoMonitoramento, Domain.Model.StatusCompromissos cumprido, Domain.Model.StatusCompromissos cumpridoForaPrazo) { var query = GetQueryExpression <T>(true); string strFetchXml = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='itbc_compdocanal'> <attribute name='itbc_compdocanalid' /> <attribute name='itbc_name' /> <attribute name='itbc_validade' /> <attribute name='itbc_statuscompromissosid' /> <attribute name='itbc_compdoprogid' /> <attribute name='itbc_canalid' /> <attribute name='itbc_businessunitid' /> <order attribute='itbc_name' descending='false' /> <filter type='and'> <condition attribute='statuscode' operator='eq' value='1' /> <filter type='or'> <condition attribute='itbc_validade' operator='on-or-before' value='{3}' /> <condition attribute='itbc_validade' operator='null' /> </filter> <filter type='or'> <condition attribute='itbc_statuscompromissosid' operator='null' /> <condition attribute='itbc_statuscompromissosid' operator='in'> <value uiname='Cumprido' uitype='itbc_statuscompromissos'>{1}</value> <value uiname='Cumprido Fora do Prazo' uitype='itbc_statuscompromissos'>{2}</value> </condition> </filter> </filter> <link-entity name='itbc_compromissos' from='itbc_compromissosid' to='itbc_compdoprogid' alias='aa'> <filter type='and'> <condition attribute='itbc_tipodemonitoramento' operator='eq' value='{0}' /> </filter> </link-entity> </entity> </fetch>"; strFetchXml = string.Format(strFetchXml, (int)tipoMonitoramento, cumprido.ID.Value, cumpridoForaPrazo.ID.Value, DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd")); RetrieveMultipleRequest retrieveMultiple = new RetrieveMultipleRequest() { Query = new FetchExpression(strFetchXml.ToString()) }; return((List <T>) this.RetrieveMultiple(retrieveMultiple.Query).List); }
public List <T> ListarAtivosCumpridos(Intelbras.CRM2013.Domain.Enum.CompromissoPrograma.TipoMonitoramento tipoMonitoramento, Domain.Model.StatusCompromissos cumprido, Domain.Model.StatusCompromissos cumpridoForaPrazo) { var query = GetQueryExpression <T>(true); var statusCompromisso = new string[] { cumprido.ID.Value.ToString(), cumpridoForaPrazo.ID.Value.ToString() }; query.Criteria.AddCondition("itbc_statuscompromissosid", Microsoft.Xrm.Sdk.Query.ConditionOperator.In, statusCompromisso); query.Criteria.AddCondition("statecode", Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, (int)Domain.Enum.CompromissoCanal.Status.Ativo); query.AddLink("itbc_compromissos", "itbc_compdoprogid", "itbc_compromissosid") .LinkCriteria.AddCondition("itbc_tipodemonitoramento", ConditionOperator.Equal, (int)tipoMonitoramento); return((List <T>) this.RetrieveMultiple(query).List); }
public List <CompromissosDoCanal> ListarAtivosCumpridos(Intelbras.CRM2013.Domain.Enum.CompromissoPrograma.TipoMonitoramento tipoMonitoramento) { return(RepositoryService.CompromissosDoCanal.ListarAtivosCumpridos(tipoMonitoramento, StatusCompromissoCumprido, StatusCompromissoCumpridoForaPrazo)); }