public ActionResult Create([DataSourceRequest] DataSourceRequest request,
[Bind(Prefix = "models")] IEnumerable <CRM_CategoryHierarchy> list)
{
IEnumerable <CRM_CategoryHierarchy> u = new CRM_CategoryHierarchy[] { };
if (asset.Create)
{
if (list != null && ModelState.IsValid)
{
var dbConn = Helpers.OrmliteConnection.openConn();
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
{
foreach (var value in list)
{
var check = dbConn.SingleOrDefault <CRM_CategoryHierarchy>("HierarchyID={0}", value.HierarchyID);
if (check == null)
{
var item = new CRM_CategoryHierarchy();
item.HierarchyID = value.HierarchyID;
item.HierarchyType = value.HierarchyType;
item.Value = value.Value;
item.ParentID = value.ParentID;
item.Level = value.Level;
item.CreatedBy = currentUser.UserName;
item.CreatedAt = DateTime.Now;
item.UpdatedAt = DateTime.Parse("1900-01-01");
item.UpdatedBy = "";
dbConn.Insert(item);
}
else
{
ModelState.AddModelError("", "Đã tồn tại mã:" + value.HierarchyID);
return(Json(u.ToDataSourceResult(request, ModelState)));
}
}
dbTrans.Commit();
return(Json(new { success = true }));
}
}
ModelState.AddModelError("", "Model not valid");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
else
{
ModelState.AddModelError("", "You don't have permission to create record");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
}
public ActionResult Update([DataSourceRequest] DataSourceRequest request,
[Bind(Prefix = "models")] IEnumerable <CRM_CategoryHierarchy> list)
{
IEnumerable <CRM_CategoryHierarchy> u = new CRM_CategoryHierarchy[] { };
if (asset.Update)
{
if (list != null)
{
var dbConn = Helpers.OrmliteConnection.openConn();
using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted))
{
foreach (var value in list)
{
var itemExit = dbConn.SingleOrDefault <CRM_CategoryHierarchy>("ID={0}", value.ID);
if (itemExit != null)
{
if (itemExit.ID == 1)
{
itemExit.Value = value.Value.Trim();
}
else
{
itemExit.HierarchyID = value.HierarchyID.Trim();
itemExit.HierarchyType = value.HierarchyType.Trim();
itemExit.Value = value.Value.Trim();
itemExit.ParentID = value.ParentID.Trim();
itemExit.Level = value.Level;
}
itemExit.Status = value.Status;
itemExit.UpdatedAt = DateTime.Now;
itemExit.UpdatedBy = currentUser.UserName;
dbConn.Update(itemExit);
}
}
dbTrans.Commit();
return(Json(new { success = true }));
}
}
ModelState.AddModelError("", "Model not valid");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
else
{
ModelState.AddModelError("", "You don't have permission to create record");
return(Json(u.ToDataSourceResult(request, ModelState)));
}
}
