public async Task <ProcessoBaseBD> ObterProcessoComDadosComplementares(int processoId) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { return(await dbContext.Processos.Include(x => x.CamposComplementares).AsNoTracking().FirstOrDefaultAsync(x => x.Id == processoId)); } }
public async Task <bool> ProcessoExiste(int processoId) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { return(await dbContext.Processos.AsNoTracking().AnyAsync(x => x.Id == processoId)); } }
public async Task <ProcessoBaseBD> ObterProcessoComEnvolvidos(int processoId) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { return(await dbContext.Processos.Include(x => x.Polos).ThenInclude(polo => polo.Parte).AsNoTracking().FirstOrDefaultAsync(x => x.Id == processoId)); } }
public async Task <ProcessoBaseBD> Obter(int processoId) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { return(await dbContext.Processos.AsNoTracking().FirstOrDefaultAsync(x => x.Id == processoId)); } }
public async Task <List <ProcessoBaseBD> > Listar(int?clienteId = null) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { return(await dbContext.Processos .Include(x => x.Audiencias) .ToListAsync()); } }
public async Task <int> ContarTotalItensBuscaFiltrada(string qry = "", int?areaId = null, int?responsavelId = null, int?clienteId = null) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { var qryObject = FiltrarProcessos(qry, areaId, responsavelId, clienteId, dbContext); return(await qryObject.AsNoTracking().CountAsync()); } }
public async Task <List <ProcessoBaseBD> > Listar(int pagina = 1, int itens = 50, string qry = "", int?areaId = null, int?responsavelId = null, int?clienteId = null) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { var qryObject = FiltrarProcessos(qry, areaId, responsavelId, clienteId, dbContext); qryObject = qryObject.OrderBy(x => x.DataEntrada).Skip(itens * (pagina - 1)).Take(itens); return(await qryObject.AsNoTracking().ToListAsync()); } }
public async Task <ProcessoBaseBD> CadastrarNovo(ProcessoBaseBD processo) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { await dbContext.Processos.AddAsync(processo); await dbContext.SaveChangesAsync(); return(dbContext.Processos.LastOrDefault()); } }
public async Task <ProcessoBaseBD> ListarCompleto(int id) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { return(await dbContext.Processos .Include(x => x.CamposComplementares) .Include("Polos.Parte.Advogados") .Include("Polos.Parte.Empregos") .Include("Polos.Parte.Enderecos") .AsNoTracking().FirstOrDefaultAsync(x => x.Id == id)); } }
private async Task DeletaSubTarefas(Audiencia compromissoAudiencia, CadastroExternoContext dbContext) { var idsSubtarefasNaoDeletadas = (from st in compromissoAudiencia.SubTarefas select st.Id).ToList(); IQueryable <AudienciaBD> idsQryObject = dbContext.CompromissosAudiencia.Where(x => x.IdPai == compromissoAudiencia.Id && !idsSubtarefasNaoDeletadas.Contains(x.Id)); List <AudienciaBD> audienciasADeletar = await idsQryObject.AsNoTracking().ToListAsync(); foreach (AudienciaBD audienciaADeletar in audienciasADeletar) { await Deletar(audienciaADeletar.Id); } }
public async Task <ProcessoBaseBD> Atualizar(ProcessoBaseBD processo) { using (var dbContext = new CadastroExternoContext(new DbContextOptions <CadastroExternoContext>())) { var processoDb = await dbContext.Processos.FindAsync(processo.Id); processoDb.Atualizar(processo); dbContext.Set <ProcessoBaseBD>().Update(processoDb); await dbContext.SaveChangesAsync(); return(processoDb); } }
private async Task DeletaSubTarefas(Prazo prazo, CadastroExternoContext dbContext) { var idsSubtarefasNaoDeletadas = (from st in prazo.SubTarefas select st.Id).ToList(); IQueryable <PrazoBD> idsQryObject = dbContext.Prazos.Where(x => x.IdPai == prazo.Id && !idsSubtarefasNaoDeletadas.Contains(x.Id)); List <PrazoBD> parzosADeletar = await idsQryObject.AsNoTracking().ToListAsync(); foreach (PrazoBD prazoADeletar in parzosADeletar) { await Deletar(prazoADeletar.Id); } }
public List <PrazoParticipanteBD> ListaParticipantes(int prazoId, CadastroExternoContext dbContext) { IQueryable <PrazoParticipanteBD> participantesQryObject = dbContext.PrazoParticipantes.Where(x => x.IdPrazo == prazoId); //List<PrazoParticipante> list = new List<PrazoParticipante>(); //foreach (var item in participantesQryObject) //{ // PrazoParticipante pra = item.ConverterParaModelo(); // list.Add(pra); //}; return(participantesQryObject.ToList()); }
public List <AudienciaParticipanteBD> ListaParticipantes(int compromissoAudienciaId, CadastroExternoContext dbContext) { IQueryable <AudienciaParticipanteBD> participantesQryObject = dbContext.AudienciaParticipantes.Where(x => x.IdAudiencia == compromissoAudienciaId); //List<AudienciaParticipante> list = new List<AudienciaParticipante>(); //foreach (var item in participantesQryObject) //{ // AudienciaParticipante pra = item.ConverterParaModelo(); // list.Add(pra); //}; return(participantesQryObject.ToList()); }
public Task <List <PrazoParticipante> > ListaParticipantesPorPrazos(List <int> prazoId, CadastroExternoContext dbContext) { IQueryable <PrazoParticipanteBD> participantesQryObject = dbContext.PrazoParticipantes.Where(x => prazoId.Contains(x.IdPrazo)); return(_mapper.Map <Task <List <PrazoParticipante> > >(participantesQryObject.AsNoTracking().ToListAsync())); }
private IQueryable <Prazo> FiltrarPrazos(string qry, int?casoId, int?responsavelId, int?executorId, int?categoriaId, CadastroExternoContext dbContext, out IQueryable <Prazo> qryFinalFilhos) { var all = dbContext.Prazos.Where(x => x.Id > 0); var qryObject = all; if (qryObject != null && casoId.HasValue) { qryObject = qryObject.Where(x => x.IdProcesso == casoId.Value); } //if (qryObject != null && !string.IsNullOrWhiteSpace(qry)) { qryObject = qryObject.Where(Prazo.FiltroBuscaAtomica(qry)); } if (qryObject != null && executorId.HasValue) { qryObject = qryObject.Where(x => x.IdExecutor == executorId.Value); } if (qryObject != null && responsavelId.HasValue) { qryObject = qryObject.Where(x => x.IdResponsavel == responsavelId.Value); } if (qryObject != null && categoriaId.HasValue) { qryObject = qryObject.Where(x => x.IdCategoria == categoriaId.Value); } var qryObjectPais = qryObject.Where(x => (!x.IdPai.HasValue || x.IdPai < 1)).ToList(); var qryObjectsFilhos = qryObject.Where(x => (x.IdPai.HasValue && x.IdPai > 0)).ToList(); List <int> finalFathers = new List <int>(); foreach (PrazoBD p in qryObjectsFilhos) { finalFathers.Add((from aud in dbContext.Prazos.Where(x => x.Id > 0) where aud.Id == p.IdPai select aud.Id).First()); } foreach (PrazoBD p in qryObjectPais) { if (!finalFathers.Contains(p.Id)) { finalFathers.Add(p.Id); } } var toReturnObject = all.Where(x => finalFathers.Contains(x.Id)); qryFinalFilhos = _mapper.Map <IQueryable <Prazo> >(all.Where(x => x.IdPai.HasValue && finalFathers.Contains(x.IdPai.Value))); return(_mapper.Map <IQueryable <Prazo> >(toReturnObject)); }
private static IQueryable <ProcessoBase> FiltrarProcessos(string qry, int IdEscritorio, int?areaId, int?responsavelId, int?clienteId, CadastroExternoContext dbContext) { //var qryObject = dbContext.Processos.Where(x => x.Id > 0 && x.IdEscritorio.Equals(IdEscritorio)); //if (!string.IsNullOrWhiteSpace(qry)) { qryObject = qryObject.Where(ProcessoBase.FiltroBuscaAtomica(qry)); } //if (areaId.HasValue) { qryObject = qryObject.Where(x => x.IdArea == areaId.Value); } //if (responsavelId.HasValue) { qryObject = qryObject.Where(x => x.IdResponsavel == responsavelId.Value); } //if (clienteId.HasValue) { qryObject = qryObject.Where(x => x.IdCliente == clienteId.Value); } //return qryObject; return(new List <ProcessoBase>().AsQueryable()); }
private static IQueryable <ProcessoBaseBD> FiltrarProcessos(string qry, int?areaId, int?responsavelId, int?clienteId, CadastroExternoContext dbContext) { var qryObject = dbContext.Processos.Where(x => x.Id > 0); //if (!string.IsNullOrWhiteSpace(qry)) { qryObject = qryObject.Where(ProcessoBaseBD.FiltroBuscaAtomica(qry)); } if (areaId.HasValue) { qryObject = qryObject.Where(x => x.IdArea == areaId.Value); } if (responsavelId.HasValue) { qryObject = qryObject.Where(x => x.IdResponsavel == responsavelId.Value); } if (clienteId.HasValue) { qryObject = qryObject.Where(x => x.IdCliente == clienteId.Value); } return(qryObject); }
public Task <List <AudienciaParticipante> > ListaParticipantesPorAudiencias(List <int> compromissoAudienciaId, CadastroExternoContext dbContext) { IQueryable <AudienciaParticipanteBD> participantesQryObject = dbContext.AudienciaParticipantes.Where(x => compromissoAudienciaId.Contains(x.IdAudiencia)); return(_mapper.Map <Task <List <AudienciaParticipante> > >(participantesQryObject.AsNoTracking().ToListAsync())); }