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))); } }