public ActionResult ItemLogsCreate(imp_itemLog item) { var mng = new ImpManager(); mng.SaveItemLog(item); return(Json(new { result = true })); }
public ActionResult ItemLogs_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 created = id > 0 ? RDL.Convert.StrToDateTime(AjaxModel.GetValueFromSaveField("created", fields), DateTime.Now) : DateTime.Now; var createdBy = AjaxModel.GetValueFromSaveField("createdBy", fields); var errors = AjaxModel.GetValueFromSaveField("errors", fields); var info = AjaxModel.GetValueFromSaveField("info", fields); var durationSec = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("info", fields), 0); var withBackup = (AjaxModel.GetValueFromSaveField("withBackup", fields) == "") ? false : true; var isImport = (AjaxModel.GetValueFromSaveField("isImport", fields) == "") ? false : true; int?itemID = RDL.Convert.StrToInt(AjaxModel.GetValueFromSaveField("itemName", fields), 0); if (itemID == 0) { itemID = null; } var item = new imp_itemLog { id = id, created = created, createdBy = createdBy, errors = errors, durationSec = durationSec, info = info, isImport = isImport, withBackup = withBackup, itemID = itemID }; mng.SaveItemLog(item); savedID = item.id; res = true; } catch (Exception ex) { res = false; } return(Json(new { result = res, savedID = savedID, msg = "" }, JsonRequestBehavior.AllowGet)); }
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 }); } }