/// <summary>
/// Create a new <see cref="Category"/> from an existing database model.
/// </summary>
public Category(StoreCategoryModel model)
{
Id = model.Id;
Name = model.Name;
Description = model.Description;
ParentCategoryId = model.ParentId;
Index = model.Index;
Visible = Convert.ToBoolean(model.Visible);
}
public IHttpActionResult Update(int id, StoreCategoryModel categoryModel)
{
var category = _storeCategoryService.GetStoreCategoryById(id);
if (category == null || category.Deleted)
{
return(NotFound());
}
category = categoryModel.ToEntity(category);
_storeCategoryService.UpdateStoreCategory(category);
_customerActivityService.InsertActivity("UpdateStoreCategory", "更新名为 {0} 的商家类别", category.Name);
return(Ok(category.ToModel()));
}
public IHttpActionResult Create(StoreCategoryModel categoryModel)
{
var category = categoryModel.ToEntity();
if (ModelState.IsValid)
{
_storeCategoryService.InsertStoreCategory(category);
//activity log
_customerActivityService.InsertActivity("AddNewStoreCategory", "新增名为 {0} 的商家类别", category.Name);
//SuccessNotification(_localizationService.GetResource("Admin.Catalog.Categories.Added"));
return(Ok(category.ToModel()));
}
else
{
return(BadRequest("类别模型数据错误"));
}
}
public bool AddStoreCategory(StoreCategoryModel objStore)
{
try
{
if (objStore.StoreCategory1.Count > 0)
{
using (SqlCommand cmd = new SqlCommand())
{
SqlConnection con = new SqlConnection(Context.Database.Connection.ConnectionString);
con.Open();
cmd.Connection = con;
cmd.CommandText = "TRUNCATE TABLE [EbayStoreCategory1]";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
con.Close();
}
foreach (var item in objStore.StoreCategory1)
{
EbayStoreCategory1 cat1 = new EbayStoreCategory1();
cat1.CategoryID = item.CategoryID;
cat1.EbayMarketplaceID = item.EbayMarketplaceID;
cat1.CategoryName = item.CategoryName;
cat1.CreatedByUser = item.CreatedByUser;
cat1.CreatedByUserId = item.CreatedByUserId;
cat1.UpdatedByUser = item.UpdatedByUser;
cat1.UpdatedByUserId = item.UpdatedByUserId;
Context.EbayStoreCategory1.Add(cat1);
Context.SaveChanges();
}
}
if (objStore.StoreCategory2.Count > 0)
{
using (SqlCommand cmd = new SqlCommand())
{
SqlConnection con = new SqlConnection(Context.Database.Connection.ConnectionString);
con.Open();
cmd.Connection = con;
cmd.CommandText = "TRUNCATE TABLE [EbayStoreCategory2]";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
con.Close();
}
foreach (var item in objStore.StoreCategory2)
{
EbayStoreCategory2 cat2 = new EbayStoreCategory2
{
CategoryID = item.CategoryID,
EbayMarketplaceID = item.EbayMarketplaceID,
CategoryName = item.CategoryName,
CreatedByUser = item.CreatedByUser,
CreatedByUserId = item.CreatedByUserId,
UpdatedByUser = item.UpdatedByUser,
UpdatedByUserId = item.UpdatedByUserId
};
Context.EbayStoreCategory2.Add(cat2);
Context.SaveChanges();
}
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static StoreCategory ToEntity(this StoreCategoryModel model, StoreCategory destination)
{
return(model.MapTo(destination));
}
public static StoreCategory ToEntity(this StoreCategoryModel model)
{
return(model.MapTo <StoreCategoryModel, StoreCategory>());
}
