public int SaveItemLog(imp_itemLog element)
{
try
{
if (element.id == 0)
{
db.imp_itemLog.Add(element);
db.SaveChanges();
}
else
{
try
{
db.Entry(element).State = EntityState.Modified;
db.SaveChanges();
}
catch (OptimisticConcurrencyException ex)
{
RDL.Debug.LogError(ex);
}
}
}
catch (Exception ex)
{
RDL.Debug.LogError(ex);
}
return(element.id);
}
public imp_itemLog GetItemLog(int id)
{
var res = new imp_itemLog();
res = db.imp_itemLog.FirstOrDefault(x => x.id == id);
return(res);
}
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));
}
public void DeleteItemLog(imp_itemLog item)
{
try
{
db.DeleteItemLog(item.id);
RDL.CacheManager.PurgeCacheItems("imp_itemLog");
}
catch (Exception ex)
{
RDL.Debug.LogError(ex);
}
}
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 });
}
}
