private object RecordItemLog( string table_name, string where, string error, int duration, string path, string fileName) { var user = User.Identity.Name; var date = DateTime.Today; var info = where; var durationSec = duration; var errors = error; var imp = new ImpManager(); try { if (!imp.GetItems().Any(i => i.name == "ExportIn" + table_name)) { var item = new imp_items { code = "exportIn" + table_name, datatable = table_name, name = "ExportIn" + table_name }; imp.SaveItem(item); } var itemID = imp.GetItems().FirstOrDefault(i => i.name == "ExportIn" + table_name).id; var itemLog = new imp_itemLog { itemID = itemID, created = date, createdBy = user, durationSec = durationSec, errors = errors, info = info, isImport = false, withBackup = false }; imp.SaveItemLog(itemLog); return(new { result = true, msg = error, path = path, fileName = fileName + ".xlsx" }); } catch (Exception exc) { return(new { result = false, msg = exc.Message }); } }
public ActionResult Items_save() { var parameters = AjaxModel.GetAjaxParameters(HttpContext); var mng = new ImpManager(); var res = false; int savedID = 0; try { var fields = (parameters["fields"] as ArrayList).ToArray().ToList().Select(x => x as Dictionary <string, object>).ToList(); var id = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("id", fields), 0); var name = AjaxModel.GetValueFromSaveField("name", fields); var code = AjaxModel.GetValueFromSaveField("code", fields); var datatable = AjaxModel.GetValueFromSaveField("datatable", fields); var sqlInsert = AjaxModel.GetValueFromSaveField("sqlInsert", fields); var sqlUpdate = AjaxModel.GetValueFromSaveField("sqlUpdate", fields); var sqlDelete = AjaxModel.GetValueFromSaveField("sqlDelete", fields); var item = new imp_items { id = id, name = name, code = code, datatable = datatable, sqlInsert = sqlInsert, sqlUpdate = sqlUpdate, sqlDelete = sqlDelete }; mng.SaveItem(item); savedID = item.id; res = true; } catch (Exception ex) { res = false; } return(Json(new { result = res, savedID = savedID, msg = "" }, JsonRequestBehavior.AllowGet)); }