private ProductClassAttribute DataRowToProductClassAttribute(DataRow data) { if (data == null) { return(null); } var contact = new ProductClassAttribute(); contact.Id = new Guid(data["Id"].ToString()); contact.ProductAttributeId = new Guid(data["ProductAttributeId"].ToString()); contact.ProductClassId = new Guid(data["ProductClassId"].ToString()); contact.IsShow = (bool)data["IsShow"]; return(contact); }
public void Add(ProductClassAttribute cat) { var Cmd = _context.CreateCommand(); Cmd.CommandText = "INSERT INTO [dbo].[ProductClassAttribute]([Id],[ProductClassId],[ProductAttributeId],[IsShow])" + " VALUES(@Id,@ProductClassId,@ProductAttributeId,@IsShow)"; Cmd.Parameters.Add("Id", SqlDbType.UniqueIdentifier).Value = cat.Id; Cmd.AddParameters("ProductClassId", cat.ProductClassId); Cmd.AddParameters("ProductAttributeId", cat.ProductAttributeId); Cmd.AddParameters("IsShow", cat.IsShow); bool rt = Cmd.command.ExecuteNonQuery() > 0; Cmd.cacheStartsWithToClear(string.Concat(CacheKeys.Product.ProductClassAttribute, "ProductClassId-", cat.ProductClassId)); Cmd.Close(); if (!rt) { throw new Exception("Add ProductAttribute false"); } }
public ActionResult Edit(AdminEditProductClassViewModel model) { if (ModelState.IsValid) { using (var unitOfWork = UnitOfWorkManager.NewUnitOfWork()) { try { var productClass = _productSevice.GetProductClass(model.Id); if (productClass == null) { return(RedirectToAction("index")); } model.Image = productClass.Image; productClass.Name = model.Name; productClass.Image = model.Image; productClass.Description = model.Description; productClass.Colour = model.Colour; productClass.IsLocked = model.IsLocked; _productSevice.Update(productClass); _productSevice.DelAllAttributeForProductClass(productClass.Id); if (model.AllAttribute != null) { foreach (var it in model.AllAttribute) { if (it.IsCheck) { var a = new ProductClassAttribute { ProductAttributeId = it.Id, ProductClassId = productClass.Id, IsShow = it.IsShow, }; _productSevice.Add(a); } } } unitOfWork.Commit(); TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = "Thành công cập nhật nhóm sản phẩm", MessageType = GenericMessages.success }; } catch (Exception ex) { unitOfWork.Rollback(); LoggingService.Error(ex.Message); ModelState.AddModelError("", "Lỗi khi thêm nhóm sản phẩm"); } } } if (model.AllAttribute != null) { foreach (var it in model.AllAttribute) { it.Name = _productSevice.GetAttribute(it.Id).LangName; } } return(View(model)); }
public ActionResult Create(AdminEditProductClassViewModel model) { if (ModelState.IsValid) { using (var unitOfWork = UnitOfWorkManager.NewUnitOfWork()) { try { var productClass = new ProductClass { Name = model.Name, Image = model.Image, Description = model.Description, Colour = model.Colour, IsLocked = model.IsLocked }; _productSevice.Add(productClass); if (model.AllAttribute != null) { foreach (var it in model.AllAttribute) { if (it.IsCheck) { var a = new ProductClassAttribute { ProductAttributeId = it.Id, ProductClassId = productClass.Id, IsShow = it.IsShow, }; _productSevice.Add(a); } } } unitOfWork.Commit(); TempData[AppConstants.MessageViewBagName] = new GenericMessageViewModel { Message = "Thành công thêm nhóm sản phẩm", MessageType = GenericMessages.success }; return(RedirectToAction("Index")); } catch { unitOfWork.Rollback(); ModelState.AddModelError("", "Lỗi khi thêm nhóm sản phẩm"); } } } foreach (var it in model.AllAttribute) { it.Name = _productSevice.GetAttribute(it.Id).LangName; } return(View(model)); }