public int SaveItem(imp_items element)
{
try
{
if (element.id == 0)
{
db.imp_items.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_items GetItem(int id)
{
var res = new imp_items();
res = db.imp_items.FirstOrDefault(x => x.id == id);
return(res);
}
public void DeleteItem(imp_items item)
{
try
{
db.DeleteItem(item.id);
RDL.CacheManager.PurgeCacheItems("as_items");
}
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 });
}
}
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));
}
