private static void SincronizareTermenePortal()
{
string conStr = CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString(), CommonFunctions.StringCipher.RetrieveKey());
int id = 1;
ProceseRepository pr = new ProceseRepository(id, conStr);
Proces[] procese = (Proces[])pr.GetFiltered(null, null, " PROCESE.NR_DOSAR_INSTANTA LIKE '%/%' ", null).Result;
List <SOCISA.Models.SedintaPortal> lst = new List <SedintaPortal>();
QuerySoapClient ws = new QuerySoapClient();
for (int i = 0; i < procese.Length; i++)
{
try
{
int id_dosar = Convert.ToInt32(procese[i].ID_DOSAR);
Dosar d = new Dosar(id, conStr, id_dosar);
int id_proces = Convert.ToInt32(procese[i].ID);
string nr_dosar = procese[i].NR_DOSAR_INSTANTA;
socisaV2.PortalWS.Dosar dosar = ws.CautareDosare2(nr_dosar, null, null, null, null, null, null, null)[0];
for (int j = 0; j < dosar.sedinte.Length; j++)
{
bool gasit = false;
for (int k = 0; k <= 7; k++)
{
if (dosar.sedinte[j].data.Date == DateTime.Now.Date.AddDays(k).Date)
{
SedintaPortal dsp = new SedintaPortal(id, conStr);
dsp.ID_DOSAR = id_dosar;
try
{
dsp.NR_DOSAR_CASCO = d.NR_DOSAR_CASCO;
}
catch { }
dsp.ID_PROCES = id_proces;
dsp.NR_DOSAR_INSTANTA = procese[i].NR_DOSAR_INSTANTA;
dsp.DATA = DateTime.Now.Date;
dsp.DATA_SEDINTA = dosar.sedinte[j].data;
dsp.INSTANTA = dosar.institutie.ToString();
dsp.COMPLET = dosar.sedinte[j].complet;
dsp.ORA = dosar.sedinte[j].ora;
dsp.MONITORIZARE = true;
dsp.Insert();
gasit = true;
break;
}
}
if (gasit)
{
break;
}
}
}
catch (Exception exp) { exp.ToString(); }
}
}
public ImportSedintaPortalView(int _CURENT_USER_ID, string conStr, int id)
{
this.SedintaPortal = new SedintaPortal(_CURENT_USER_ID, conStr, id);
this.Stadii = (Stadiu[])(new StadiiRepository(_CURENT_USER_ID, conStr).GetAll().Result);
QuerySoapClient ws = new QuerySoapClient();
socisaV2.PortalWS.Dosar[] ds = ws.CautareDosare2(SedintaPortal.NR_DOSAR_INSTANTA, null, null, null, null, null, null, null);
this.Dosar = ds[0];
DosarSedinta[] dos = this.Dosar.sedinte;
foreach (DosarSedinta d in dos)
{
if (d.data.Date == Convert.ToDateTime(SedintaPortal.DATA_SEDINTA).Date)
{
this.DosarSedinta = d;
break;
}
}
this.TermenAdministrativPortal = this.TermenAdministrativ = this.DosarSedinta.complet.ToLower().IndexOf("administrativ") > -1;
this.Sentinta = this.DosarSedinta.documentSedinta != null;
this.ProcesStadiuExtended = new ProcesStadiuExtended(new ProcesStadiu(_CURENT_USER_ID, conStr));
this.ProcesStadiuExtended.ProcesStadiu.ID_DOSAR = this.SedintaPortal.ID_DOSAR;
this.ProcesStadiuExtended.ProcesStadiu.ID_PROCES = this.SedintaPortal.ID_PROCES;
this.ProcesStadiuExtended.ProcesStadiu.DATA = this.SedintaPortal.DATA;
this.ProcesStadiuExtended.ProcesStadiu.TERMEN = this.DosarSedinta.data;
this.ProcesStadiuExtended.ProcesStadiu.ORA = this.DosarSedinta.ora;
this.ProcesStadiuExtended.ProcesStadiu.OBSERVATII = String.Format("{0} - {1}", this.DosarSedinta.solutie, this.DosarSedinta.solutieSumar);
foreach (Stadiu s in this.Stadii)
{
if (s.DENUMIRE.ToLower().IndexOf(this.Dosar.stadiuProcesualNume.ToLower()) > -1 && s.PARENT_ID != null)
{
this.ProcesStadiuExtended.ProcesStadiu.ID_STADIU = s.ID;
break;
}
}
if (this.Sentinta)
{
this.ProcesStadiuExtended.Sentinta.NR_SENTINTA = this.DosarSedinta.numarDocument.ToString();
this.ProcesStadiuExtended.Sentinta.DATA_SENTINTA = this.DosarSedinta.dataDocument;
this.ProcesStadiuExtended.Sentinta.DATA_COMUNICARE = this.DosarSedinta.dataPronuntare;
this.ProcesStadiuExtended.Sentinta.SOLUTIE = String.Format("{0} - {1}", this.DosarSedinta.solutie, this.DosarSedinta.solutieSumar);
}
}
public DosarPortalView(string nr_dosar_instanta)
{
QuerySoapClient ws = new QuerySoapClient();
this.Dosare = ws.CautareDosare2(nr_dosar_instanta, null, null, null, null, null, null, null);
}
public JustClient()
{
_soapClient = new QuerySoapClient();
}
