public ActionResult Delete(string data) { using (var dbConn = Helpers.OrmliteConnection.openConn()) using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted)) if (asset.Delete) { try { string[] separators = { "@@" }; var listRowID = data.Split(separators, StringSplitOptions.RemoveEmptyEntries); var delete = new CRM_PageProduct(); foreach (var item in listRowID) { delete.ProductID = Int32.Parse(item); dbConn.Delete(delete); } dbTrans.Commit(); } catch (Exception ex) { return(Json(new { success = false, alert = ex.Message })); } return(Json(new { success = true })); } else { return(Json(new { success = false, alert = "You don't have permission to delete record" })); } }
public ActionResult UpdateDetail([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <CRM_PageProduct> list) { var dbConn = Helpers.OrmliteConnection.openConn(); if (asset.Create || asset.Update) { if (list != null) { try { foreach (var item in list) { var exits = dbConn.SingleOrDefault <CRM_PageProduct>("PositionID= {0}", item.PositionID); if (exits == null) { var row = new CRM_PageProduct(); row.ProductName = !string.IsNullOrEmpty(item.ProductName) ? item.ProductName.Trim() : ""; row.ProductType = !string.IsNullOrEmpty(item.ProductType) ? item.ProductType.Trim() : ""; row.PositionID = !(item.PositionID == 0) ? item.PositionID : 0; row.CategoryID = !(item.CategoryID == 0) ? item.CategoryID : 0; row.Price = !(item.Price == 0) ? item.Price : 0; row.PriceType = !string.IsNullOrEmpty(item.PriceType) ? item.PriceType.Trim() : ""; row.Status = !(item.Status == 0) ? item.Status : 0; row.CreatedBy = currentUser.UserName; row.UpdatedBy = ""; row.CreatedAt = DateTime.Now; row.UpdatedAt = DateTime.Parse("1900-01-01"); dbConn.Insert(row); } else { exits.ProductName = !string.IsNullOrEmpty(item.ProductName) ? item.ProductName.Trim() : ""; exits.ProductType = !string.IsNullOrEmpty(item.ProductType) ? item.ProductType.Trim() : ""; exits.PositionID = !(item.PositionID == 0) ? item.PositionID : 0; exits.CategoryID = !(item.CategoryID == 0) ? item.CategoryID : 0; exits.Price = !(item.Price == 0) ? item.Price : 0; exits.PriceType = !string.IsNullOrEmpty(item.PriceType) ? item.PriceType.Trim() : ""; exits.Status = !(item.Status == 0) ? item.Status : 0; exits.UpdatedBy = currentUser.UserName; exits.UpdatedAt = DateTime.Now; dbConn.Update(exits); } } ModelState.AddModelError("Thành công!", "Lưu thành công."); return(Json(new { sussess = true })); } catch (Exception ex) { ModelState.AddModelError("error", ex.Message); return(Json(list.ToDataSourceResult(request, ModelState))); } } return(Json(new { sussess = true })); } else { ModelState.AddModelError("error", "Bạn không có quyền cập nhật."); return(Json(list.ToDataSourceResult(request, ModelState))); } }