//public void ExportProceseToExcel(ProcesView ProcesView) public void ExportProceseToExcelOld(Proces Proces, ProcesJson procesJson) { string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); //string jsonFilter = JsonConvert.SerializeObject(DosarView); /* * JObject f = (JObject)JsonConvert.DeserializeObject(Request.Form[0]); * response r = GetFiltered(f); */ response r = GetFiltered(JToken.FromObject(Proces), JToken.FromObject(procesJson)); ProcesExtended[] procese = (ProcesExtended[])r.Result; //DataTable table = (DataTable)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(procese, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter() { DateTimeFormat = CommonFunctions.DATE_FORMAT }), (typeof(DataTable))); Proces p = new Proces(); PropertyInfo[] pis = p.GetType().GetProperties(); DataTable proceseDt = new DataTable("Procese"); foreach (PropertyInfo pi in pis) { DataColumn dc = new DataColumn(pi.Name, Type.GetType("System.String")); proceseDt.Columns.Add(dc); } proceseDt.AcceptChanges(); foreach (ProcesExtended pe in procese) { DataRow dr = proceseDt.NewRow(); pis = pe.Proces.GetType().GetProperties(); foreach (PropertyInfo pi in pis) { try { dr[pi.Name] = pi.GetValue(pe.Proces) == null ? null : pi.GetValue(pe.Proces).ToString(); } catch { dr[pi.Name] = null; } } proceseDt.Rows.Add(dr); } proceseDt.AcceptChanges(); /* * List<string> columns_to_remove = new List<string>(); * foreach (DataColumn dc in proceseDt.Columns) * { * if ( * !dc.ColumnName.ToLower().Equals("id") && * !dc.ColumnName.ToLower().Contains("nr_dosar_casco") && * !dc.ColumnName.ToLower().Contains("nr_sca") && * !dc.ColumnName.ToLower().Contains("data_sca") && * !dc.ColumnName.ToLower().Contains("nr_polita_casco") && * !dc.ColumnName.ToLower().Contains("nr_auto_casco") && * !dc.ColumnName.ToLower().Contains("nr_polita_rca") && * !dc.ColumnName.ToLower().Contains("nr_auto_rca") && * !dc.ColumnName.ToLower().Contains("data_eveniment") && * !dc.ColumnName.ToLower().Contains("valoare_regres") && * !dc.ColumnName.ToLower().Contains("data_avizare") * ) * { * columns_to_remove.Add(dc.ColumnName); * } * } * foreach (string col_name in columns_to_remove) * { * proceseDt.Columns.Remove(col_name); * } */ /* * 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); } * } */ proceseDt.AcceptChanges(); using (ExcelPackage pack = new ExcelPackage()) { ExcelWorksheet ws = pack.Workbook.Worksheets.Add("Procese"); ws.Cells["A1"].LoadFromDataTable(proceseDt, true); var ms = new System.IO.MemoryStream(); pack.SaveAs(ms); Response.BinaryWrite(ms.GetBuffer()); } }
public JsonResult Edit(Proces Proces, ProcesJson procesJson) { response toReturn = new response(true, "", null, null, new List <Error>()); string conStr = Session["conStr"].ToString(); //ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString; int _CURENT_USER_ID = Convert.ToInt32(Session["CURENT_USER_ID"]); int _ID_SOCIETATE = Convert.ToInt32(Session["ID_SOCIETATE"]); Dosar d = Proces.ID_DOSAR == null ? new Dosar() : new Dosar(_CURENT_USER_ID, conStr, Convert.ToInt32(Proces.ID_DOSAR)); if (Proces.ID == null) // insert { Proces p = new Proces(_CURENT_USER_ID, conStr); PropertyInfo[] pis = Proces.GetType().GetProperties(); foreach (PropertyInfo pi in pis) { pi.SetValue(p, pi.GetValue(Proces)); } string calitate = ((Nomenclator)p.GetCalitate(_ID_SOCIETATE).Result).DENUMIRE; if (!String.IsNullOrWhiteSpace(procesJson.Reclamant) || !String.IsNullOrWhiteSpace(procesJson.Parat) || !String.IsNullOrWhiteSpace(procesJson.Tert)) { if ((calitate == "PARAT" || calitate == "TERT") && !String.IsNullOrWhiteSpace(procesJson.Reclamant)) { Parte reclamant = new Parte(_CURENT_USER_ID, conStr); reclamant.DENUMIRE = procesJson.Reclamant; toReturn = reclamant.Insert(); if (toReturn.Status) { if (p.ID_DOSAR == null || (p.ID_DOSAR != null && d.ID_SOCIETATE_CASCO == null)) { p.ID_RECLAMANT = toReturn.InsertedId; } } } if ((calitate == "RECLAMANT" || calitate == "TERT") && !String.IsNullOrWhiteSpace(procesJson.Parat)) { Parte parat = new Parte(_CURENT_USER_ID, conStr); parat.DENUMIRE = procesJson.Parat; toReturn = parat.Insert(); if (toReturn.Status) { if (p.ID_DOSAR == null || (p.ID_DOSAR != null && d.ID_SOCIETATE_RCA == null)) { p.ID_PARAT = toReturn.InsertedId; } } } if (calitate != "TERT" && !String.IsNullOrWhiteSpace(procesJson.Tert)) { Parte tert = new Parte(_CURENT_USER_ID, conStr); tert.DENUMIRE = procesJson.Parat; toReturn = tert.Insert(); if (toReturn.Status) { p.ID_TERT = toReturn.InsertedId; } } } if (toReturn.Status) { toReturn = p.Insert(); } } else // update { Proces p = new Proces(_CURENT_USER_ID, conStr, Convert.ToInt32(Proces.ID)); string calitate = ((Nomenclator)p.GetCalitate(_ID_SOCIETATE).Result).DENUMIRE; if (!String.IsNullOrWhiteSpace(procesJson.Reclamant) || !String.IsNullOrWhiteSpace(procesJson.Parat) || !String.IsNullOrWhiteSpace(procesJson.Tert)) { if (calitate == "PARAT" || calitate == "TERT") { if (p.ID_DOSAR == null || (p.ID_DOSAR != null && d.ID_SOCIETATE_CASCO == null)) { if (Proces.ID_RECLAMANT == null) { if (!String.IsNullOrWhiteSpace(procesJson.Reclamant)) { Parte reclamant = new Parte(_CURENT_USER_ID, conStr); reclamant.DENUMIRE = procesJson.Reclamant; toReturn = reclamant.Insert(); if (toReturn.Status) { //p.ID_RECLAMANT = toReturn.InsertedId; Proces.ID_RECLAMANT = toReturn.InsertedId; } } } else { dynamic initReclamant = p.GetReclamant(_ID_SOCIETATE).Result; if (!String.IsNullOrWhiteSpace(procesJson.Reclamant)) { if (!String.IsNullOrWhiteSpace(procesJson.Reclamant) && initReclamant.DENUMIRE != procesJson.Reclamant) { initReclamant.DENUMIRE = procesJson.Reclamant; toReturn = initReclamant.Update(); } } else { toReturn = initReclamant.Delete(); if (toReturn.Status) { //p.ID_RECLAMANT = null; Proces.ID_RECLAMANT = null; } } } } } if (calitate == "RECLAMANT" || calitate == "TERT") { if (p.ID_DOSAR == null || (p.ID_DOSAR != null && d.ID_SOCIETATE_RCA == null)) { if (Proces.ID_PARAT == null) { if (!String.IsNullOrWhiteSpace(procesJson.Parat)) { Parte parat = new Parte(_CURENT_USER_ID, conStr); parat.DENUMIRE = procesJson.Reclamant; toReturn = parat.Insert(); if (toReturn.Status) { //p.ID_PARAT = toReturn.InsertedId; Proces.ID_PARAT = toReturn.InsertedId; } } } else { dynamic initParat = p.GetParat(_ID_SOCIETATE).Result; if (!String.IsNullOrWhiteSpace(procesJson.Parat)) { if (!String.IsNullOrWhiteSpace(procesJson.Parat) && initParat.DENUMIRE != procesJson.Parat) { initParat.DENUMIRE = procesJson.Parat; toReturn = initParat.Update(); } } else { toReturn = initParat.Delete(); if (toReturn.Status) { //p.ID_PARAT = null; Proces.ID_PARAT = null; } } } } } if (calitate != "TERT") { if (Proces.ID_TERT == null) { if (!String.IsNullOrWhiteSpace(procesJson.Tert)) { Parte tert = new Parte(_CURENT_USER_ID, conStr); tert.DENUMIRE = procesJson.Tert; toReturn = tert.Insert(); if (toReturn.Status) { //p.ID_TERT = toReturn.InsertedId; Proces.ID_TERT = toReturn.InsertedId; } } } else { dynamic initTert = p.GetTert(_ID_SOCIETATE).Result; if (!String.IsNullOrWhiteSpace(procesJson.Tert)) { if (!String.IsNullOrWhiteSpace(procesJson.Tert) && initTert.DENUMIRE != procesJson.Tert) { initTert.DENUMIRE = procesJson.Tert; toReturn = initTert.Update(); } } else { toReturn = initTert.Delete(); if (toReturn.Status) { //p.ID_TERT = null; Proces.ID_TERT = null; } } } } } if (toReturn.Status) { string s = JsonConvert.SerializeObject(Proces, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter() { DateTimeFormat = CommonFunctions.DATE_FORMAT }); toReturn = p.Update(s); } } return(Json(toReturn, JsonRequestBehavior.AllowGet)); }