public JsonResult Search(Proces Proces, ProcesJson procesJson)
{
response r = GetFiltered(JToken.FromObject(Proces), JToken.FromObject(procesJson));
return(Json(JsonConvert.SerializeObject(r, Formatting.None, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = CommonFunctions.DATE_FORMAT
}), JsonRequestBehavior.AllowGet));
}
//public void ExportProceseToExcel(ProcesView ProcesView)
public void ExportProceseToExcel(Proces Proces, ProcesJson procesJson)
{
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 _f = CreateFilterString(JToken.FromObject(Proces), JToken.FromObject(procesJson));
response r = pr.ExportExcel(null, null, _f, null);
DataTable proceseDt = (DataTable)r.Result;
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 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));
}
