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