public void AlterarStatus(int id, ProcessoStatus status)
{
this.Session
.CreateQuery("update Processo set Status = :status where Id = :id")
.SetParameter("id", id)
.SetParameter("status", status)
.ExecuteUpdate();
}
public void GravarFinalizado(int processoId, ProcessoStatus status)
{
this.Session
.CreateQuery("update Processo set Status = :status where Id = :id")
.SetParameter("id", processoId)
.SetParameter("status", ProcessoStatus.Finalizado)
.ExecuteUpdate();
}
public void AlterarStatusPorLote(List <Lote> lotes, ProcessoStatus processoStatus)
{
this.Session
.CreateQuery("update Processo set Status = :processoStatus where Lote.Id in (:lotes)")
.SetParameter("processoStatus", processoStatus)
.SetParameterList("lotes", lotes.Select(x => x.Id).ToArray())
.ExecuteUpdate();
}
public void AlterarStatusPorLote(int loteId, ProcessoStatus processoStatus)
{
this.Session
.CreateQuery("update Processo set Status = :processoStatus where Lote.Id = :loteId")
.SetParameter("loteId", loteId)
.SetParameter("processoStatus", processoStatus)
.ExecuteUpdate();
}
public void LimparResponsavelEHoraInicio(int processoId, ProcessoStatus processoStatus)
{
this.Session
.CreateQuery("update Processo set UsuarioResponsavel = null, HoraInicio = null, HoraInicioAjuste = null where Id = :id and Status = :status")
.SetInt32("id", processoId)
.SetParameter("status", processoStatus)
.ExecuteUpdate();
}
public void AlterarStatus(int processoId, ProcessoStatus novoStatus, ProcessoStatus statusAtual)
{
this.Session
.CreateQuery("update Processo set Status = :novoStatus where Id = :id and Status = :statusAtual")
.SetParameter("id", processoId)
.SetParameter("novoStatus", novoStatus)
.SetParameter("statusAtual", statusAtual)
.ExecuteUpdate();
}
private void DefinirNovosStatus(Lote lote, ProcessoStatus processoStatus, DocumentoStatus documentoStatus)
{
foreach (var processo in lote.Processos)
{
processo.Status = processoStatus;
if (documentoStatus != null)
{
processo.AlterarStatusDosDocumentos(documentoStatus);
}
}
}
public IList <Processo> ObterParaControleQualidade(int usuarioResponsavelId, ProcessoStatus status)
{
return(this.Session.QueryOver <Processo>()
.Where(x => x.Status == status)
.Where(x => x.UsuarioResponsavel.Id == usuarioResponsavelId)
.Fetch(x => x.Lote).Eager
.Fetch(x => x.Lote.PacoteProcessado).Eager
.Fetch(x => x.TipoDeProcesso).Eager
.Fetch(x => x.Documentos.First()).Eager
.Fetch(x => x.Documentos.First().TipoDocumento).Eager
.TransformUsing(Transformers.DistinctRootEntity)
.List <Processo>());
}
private void DefinirNovosStatus(Lote lote, ProcessoStatus processoStatus, DocumentoStatus documentoStatus)
{
foreach (var processo in lote.Processos)
{
processo.Status = processoStatus;
foreach (var documento in processo.Documentos.Where(x => x.Status != DocumentoStatus.Excluido &&
x.Virtual &&
x.TipoDocumento.Id != TipoDocumento.CodigoFolhaDeRosto &&
x.TipoDocumento.Id != TipoDocumento.CodigoTermoAutuacaoDossie))
{
documento.Status = documentoStatus;
}
}
}
public string StatusDescricao()
{
var status = ProcessoStatus.FromValue(this.Status);
return(status.DisplayName);
}
public int AlterarStatusAposRetornoPorAgenciaConta(string agencia, string conta, ProcessoStatus processoStatus)
{
return(this.Session
.CreateQuery("update Processo set Status = :status where Agencia = :agencia and Conta = :conta and (Status = :statusRetorno or Status = :statusErroTerc)")
.SetParameter("agencia", agencia)
.SetParameter("conta", conta)
.SetParameter("status", processoStatus)
.SetParameter("statusRetorno", ProcessoStatus.AguardandoRetorno)
.SetParameter("statusErroTerc", ProcessoStatus.SetaErro)
.ExecuteUpdate());
}
