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