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