public ProcesView(int _CURENT_USER_ID, string conStr, string predefinedFilter) { NomenclatoareRepository tpr = new NomenclatoareRepository(_CURENT_USER_ID, conStr); this.TipuriProcese = (Nomenclator[])tpr.GetAll("tip_procese").Result; this.Instante = (Nomenclator[])tpr.GetAll("instante").Result; this.Complete = (Nomenclator[])tpr.GetAll("complete").Result; //ContracteRepository cr = new ContracteRepository(_CURENT_USER_ID, conStr); //this.Contracte = (Contract[])cr.GetAll().Result; ProceseRepository pr = new ProceseRepository(_CURENT_USER_ID, conStr); this.TipDocumenteScanateProcese = (string[])pr.GetTipDocumenteScanatePocese().Result; //PartiRepository par = new PartiRepository(_CURENT_USER_ID, conStr); //this.Parti = (Parte[])par.GetAll().Result; this.Calitati = (Nomenclator[])tpr.GetAll("calitati").Result; //Utilizator u = new Utilizator(_CURENT_USER_ID, conStr, _CURENT_USER_ID); //this.Societate = (SocietateAsigurare)u.GetSocietatiAsigurare().Result; this.Societate = new SocietateAsigurare(_CURENT_USER_ID, conStr, Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"])); //this.CurProces = new ProcesExtended(new Proces()); //this.procesJson = new ProcesJson(); StadiiRepository sr = new StadiiRepository(_CURENT_USER_ID, conStr); this.Stadii = (StadiuCombo[])sr.GetCombo().Result; this.Procese = null; this.CurProces = new ProcesExtended(new Proces()); this.FilteredRowsCount = 0; this.procesJson = new ProcesJson(); if (predefinedFilter != "empty") { try { //daca vrem sa aducem din start inregistrari !!! string initFilter = String.Format(" ((PROCESE.ID_DOSAR IS NULL AND (PROCESE.ID_RECLAMANT={0} OR PROCESE.ID_PARAT={0} OR PROCESE.ID_TERT={0})) OR (PROCESE.ID_DOSAR IS NOT NULL AND (DOSARE.ID_SOCIETATE_CASCO={0} OR DOSARE.ID_SOCIETATE_RCA={0}))) ", Convert.ToInt32(HttpContext.Current.Session["ID_SOCIETATE"])); ProceseRepository prep = new ProceseRepository(_CURENT_USER_ID, conStr); string filter = String.IsNullOrWhiteSpace(predefinedFilter) ? initFilter : predefinedFilter; string limit = String.Format(" LIMIT 0, {0} ", (CommonFunctions.ROWS_BLOCK_SIZE).ToString()); /* * this.Procese = (ProcesExtended[])prep.GetFilteredExtended(null, null, filter, limit).Result; * this.CurProces = this.Procese[0]; */ this.Procese = (Proces[])prep.GetFiltered(null, null, filter, limit).Result; this.CurProces = new ProcesExtended(this.Procese[0]); this.FilteredRowsCount = Convert.ToInt32(prep.CountFiltered(null, null, filter, null).Result); this.procesJson = new ProcesJson(); } catch { this.Procese = null; this.CurProces = new ProcesExtended(new Proces()); this.FilteredRowsCount = 0; this.procesJson = new ProcesJson(); } } }
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 response GetFiltered(JToken jProces, JToken jprocesJson) { string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); ProceseRepository pr = new ProceseRepository(_CURENT_USER_ID, conStr); string limit = null; if (jprocesJson != null) { if (jprocesJson["LimitStart"] != null && !String.IsNullOrEmpty(jprocesJson["LimitStart"].ToString()) && jprocesJson["LimitEnd"] != null && !String.IsNullOrEmpty(jprocesJson["LimitEnd"].ToString())) { limit = String.Format(" LIMIT {0},{1} ", jprocesJson["LimitStart"].ToString(), jprocesJson["LimitEnd"].ToString()); } } //response r = dr.GetFiltered(null, null, String.Format("{'jProces':{0},'jprocesJson':{1}}", JsonConvert.SerializeObject(jProces), JsonConvert.SerializeObject(jprocesJson)), null); string jsonParam = CreateFilterString(jProces, jprocesJson); //response r = pr.GetFilteredExtended(null, null, jsonParam, limit); response r = pr.GetFiltered(null, null, jsonParam, limit); r.InsertedId = Convert.ToInt32(pr.CountFiltered(null, null, jsonParam, null).Result); // folosim campul InsertedId pt. counter return(r); }
public void ExportProceseToExcel(string _sort, string _order, string _filter, string _limit) { try { JObject jObj = (JObject)JsonConvert.DeserializeObject(_filter); string filterName = jObj["filterName"].ToString(); string filterKey = jObj["filterKey"].ToString(); object[] args = JsonConvert.DeserializeObject <object[]>(jObj["args"].ToString()); _filter = PredefinedFilters.CreateFilter(filterName, filterKey, args); } catch { } string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); ProceseRepository pr = new ProceseRepository(_CURENT_USER_ID, conStr); Proces[] procese = (Proces[])pr.GetFiltered(_sort, _order, _filter, _limit).Result; DataTable table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(procese, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter() { DateTimeFormat = SOCISA.CommonFunctions.DATE_FORMAT }), (typeof(DataTable))); List <string> columns_to_remove = new List <string>(); foreach (DataColumn dc in table.Columns) { if (dc.ColumnName.ToLower().IndexOf("id") > -1) { columns_to_remove.Add(dc.ColumnName); } } foreach (string col_name in columns_to_remove) { table.Columns.Remove(col_name); } // TO DO: add external fields !!! /* * DataColumn newdc = new DataColumn("ASIGURAT_CASCO", Type.GetType("System.String")); * table.Columns.Add(newdc); * newdc = new DataColumn("ASIGURATOR_RCA", Type.GetType("System.String")); * table.Columns.Add(newdc); * table.AcceptChanges(); * * foreach (DataRow drow in table.Rows) * { * try * { * Dosar dosar = new Dosar(_CURENT_USER_ID, conStr, Convert.ToInt32(drow["ID"])); * Asigurat aCasco = (Asigurat)dosar.GetAsiguratCasco().Result; * drow["ASIGURAT_CASCO"] = aCasco.DENUMIRE; * SocietateAsigurare sRca = (SocietateAsigurare)dosar.GetSocietateRca().Result; * drow["ASIGURATOR_RCA"] = sRca.DENUMIRE; * } * catch (Exception exp) { LogWriter.Log(exp); } * } */ table.AcceptChanges(); using (ExcelPackage pack = new ExcelPackage()) { ExcelWorksheet ws = pack.Workbook.Worksheets.Add("Procese"); ws.Cells["A1"].LoadFromDataTable(table, true); var ms = new System.IO.MemoryStream(); pack.SaveAs(ms); Response.BinaryWrite(ms.GetBuffer()); } }