public void AdicionarSeq(List <SequencialGed> seq)
{
TCEREDXEntities db = new TCEREDXEntities();
db.SequencialGeds.AddRange(seq);
db.SaveChanges();
}
public void DevolverGuia(string text)
{
try
{
TCEREDXEntities db = new TCEREDXEntities();
List <Guia> guiaResult = (from g in db.Guias where g.NumeroGuia == text select g).ToList();
foreach (Guia g in guiaResult)
{
g.Devolvido = true;
}
List <Processo> proResult = (from g in db.Processoes where g.NumeroGuia == text select g).ToList();
foreach (Processo g in proResult)
{
g.Devolvido = true;
}
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void DigitalizarProcesso(Processo p)
{
try
{
TCEREDXEntities db = new TCEREDXEntities();
var proResult = (from g in db.Processoes where g.NumeroGuia == p.NumeroGuia && g.NProcesso == p.NProcesso && g.AnoProcesso == p.AnoProcesso select g).ToList().AsEnumerable();
foreach (Processo g in proResult)
{
g.Digitalizado = true;
g.PastaDestino = p.PastaDestino;
}
var pro2Result = (from g in db.Processoes where g.NumeroGuia == p.NumeroGuia && g.NProcesso == p.NProcesso && g.AnoProcesso == p.AnoProcesso select g).ToList().Count();
if (pro2Result == 0)
{
DALGuia guia = new DALGuia();
guia.DigitalizarGuia(p);
}
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void AdicionarRange(List <Guia> seq)
{
try
{
TCEREDXEntities db = new TCEREDXEntities();
db.Guias.AddRange(seq);
db.SaveChanges();
}
catch (Exception ex)
{ throw ex; }
}
private void AtualizarSequencial(Processo p, int Seq)
{
TCEREDXEntities db = new TCEREDXEntities();
var proResult = (from g in db.SequencialGeds where g.Numero.ToString() == p.NProcesso && g.Ano == p.AnoProcesso select g);
foreach (SequencialGed seq in proResult)
{
seq.Sequencial = seq.Sequencial + 1;
}
db.SaveChanges();
}
internal void DigitalizarGuia(Processo p)
{
try
{
TCEREDXEntities db = new TCEREDXEntities();
List <Guia> guiaResult = (from g in db.Guias where g.NumeroGuia == p.NumeroGuia && p.AnoGuia == g.AnoGuia select g).ToList();
foreach (Guia g in guiaResult)
{
g.Digitalizado = true;
}
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
