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();
}
private void InserirSequencial(Processo p)
{
DALSequencial sq = new DALSequencial();
SequencialGed sequencial = new SequencialGed();
sequencial.Ano = p.AnoProcesso;
sequencial.DV = Int32.Parse(p.DigProcesso);
sequencial.Numero = Int32.Parse(p.NProcesso);
sequencial.Sequencial = 1;
List <SequencialGed> dSeq = new List <SequencialGed>();
dSeq.Add(sequencial);
}
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;
}
}
public int ObterSequencial(Processo p)
{
TCEREDXEntities db = new TCEREDXEntities();
int proResult = (from g in db.SequencialGeds where g.Numero.ToString() == p.NProcesso && g.Ano == p.AnoProcesso select g.Sequencial).Max();
if (proResult == 0)
{
InserirSequencial(p);
}
else
{
AtualizarSequencial(p, proResult);
}
proResult = proResult + 1;
return(proResult);
}