public ActionResult Create(ProductManageCreateViewModel model)
{
if (ModelState.IsValid)
{
//find properties in db
var productPropertis = db.ProductProperties.Where(p => model.ProductPropertyForProduct.Contains(p.Id)).ToList();
var product = new Product
{
Name = model.Name,
ShortDescription = model.ShortDescription,
Remark = model.Remark,
Price = model.Price,
CurrentDiscount = model.CurrentDiscount,
DiscountStartTime = model.DiscountStartTime,
DiscountEndTime = model.DiscountEndTime,
PublishTime = model.PublishTime,
IsSeasonalProduct = model.IsSeasonalProduct,
SaleStartTime = model.SaleStartTime,
SaleEndTime = model.SaleEndTime,
CategoryId = model.ProductCategoryForProduct,
Properties = productPropertis
};
//store in db and get the id
db.Products.Add(product);
db.SaveChanges();
if (model.CoverImg != null)
{
var uploadedFile = new UploadedFile(model.CoverImg);
var coverImgName=uploadedFile.SaveAsWithGuid(Server.MapPath("~/ImgRepository/ProductImgs/" + product.Id));
var pathRel = Url.Content("~/ImgRepository/ProductImgs/" + product.Id + "/" + coverImgName);
product.CoverImgUrl = pathRel;
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
}
//update ProductId for each uploaded ProductImg
if (!string.IsNullOrEmpty(model.UploadImgsIdString))
{
var uploadedImgsIdArray = model.UploadImgsIdString.Split(',');
foreach (var item in uploadedImgsIdArray)
{
if (!string.IsNullOrEmpty(item))
{
var productImg = db.ProductImages.Where(pImage => pImage.Id.ToString() == item).Single();
//move to product's folder
var imgName = UploadedFile.UploadedFileMoveTo(productImg.Url, Path.Combine(Server.MapPath("~/ImgRepository/ProductImgs/" + product.Id), (new FileInfo(productImg.Url)).Name));
var newPathRel= Url.Content("~/ImgRepository/ProductImgs/" + product.Id + "/" + imgName);
productImg.Url = newPathRel;
productImg.ProductId = product.Id;
db.SaveChanges();
}
}
}
return RedirectToAction("Index");
}
model.ProductCategories = db.ProductCategories.ToList();
model.ProductProperties = db.ProductProperties.ToList();
return View(model);
}
public ActionResult Create(ArticleManageCreateViewModel model)
{
if (ModelState.IsValid)
{
for (int i = 0; i < model.ArticleDialogs.Count; i++)
{
model.ArticleDialogs[i].SequenceNumber = i + 1;
}
var article = new Article
{
Title = model.Title,
CoverImgUrl = model.CoverImgUrl,
ShortDescription = model.ShortDescription,
Description = model.Description,
Content = model.Content,
Meta = model.Meta,
UrlSlug = model.UrlSlug,
IsPublished = model.IsPublished,
PostTime = model.PostTime,
ModifyTime = model.ModifyTime,
CategoryId=db.ArticleCategories.Find(model.ArticleCategoryForArticle).Id,
Category= db.ArticleCategories.Find(model.ArticleCategoryForArticle),
Dialogs= model.ArticleDialogs
};
db.Articles.Add(article);
db.SaveChanges();
if (model.CoverImg != null)
{
var uploadedFile = new UploadedFile(model.CoverImg);
var coverImgName = uploadedFile.SaveAsWithGuid(Server.MapPath("~/ImgRepository/ArticleImgs/" + article.Id));
var pathRel = Url.Content("~/ImgRepository/ArticleImgs/" + article.Id + "/" + coverImgName);
article.CoverImgUrl = pathRel;
db.Entry(article).State = EntityState.Modified;
db.SaveChanges();
}
var tagsList = ArticleHandler.ConvertTagsStringToList(model.ArticleTagsForArticle);
//check tags and save
foreach (var tagName in tagsList)
{
if (!db.ArticleTags.Any(t => t.Name == tagName))
{
var articleTag = new ArticleTag
{
Name = tagName
};
db.ArticleTags.Add(articleTag);
db.SaveChanges();
}
}
article.Tags = db.ArticleTags.Where(t => tagsList.Contains(t.Name)).ToList();
db.Entry(article).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(model);
}
public ActionResult Edit(ProductManageEditViewModel model)
{
if (ModelState.IsValid)
{
//save cover img
string newCoverImgUrl;
if(model.CoverImg!=null)
{
var uploadedFile = new UploadedFile(model.CoverImg);
var coverImgName = uploadedFile.SaveAsWithGuid(Server.MapPath("~/ImgRepository/ProductImgs/" + model.Id));
var pathRel = Url.Content("~/ImgRepository/ProductImgs/" + model.Id+"/"+coverImgName);
newCoverImgUrl = pathRel;
}
else
{
newCoverImgUrl = db.Products.Find(model.Id).CoverImgUrl;
}
//update ProductId for each uploaded ProductImg
if(!string.IsNullOrEmpty(model.UploadImgsIdString))
{
var uploadedImgsIdArray = model.UploadImgsIdString.Split(',');
foreach (var item in uploadedImgsIdArray)
{
if (!string.IsNullOrEmpty(item))
{
var productImg = db.ProductImages.Where(pImage => pImage.Id.ToString() == item).Single();
//move to product's folder
var imgName = UploadedFile.UploadedFileMoveTo(productImg.Url, Path.Combine(Server.MapPath("~/ImgRepository/ProductImgs/" + model.Id), (new FileInfo(productImg.Url)).Name));
var newPathRel = Url.Content("~/ImgRepository/ProductImgs/" + model.Id + "/" + imgName);
productImg.Url = newPathRel;
productImg.ProductId = model.Id;
db.SaveChanges();
}
}
}
if(!string.IsNullOrEmpty(model.DeletedImgsFileNameString))
{
var deletedImgsFileNameArray = model.DeletedImgsFileNameString.Split(',');
foreach(var item in deletedImgsFileNameArray)
{
if(!string.IsNullOrEmpty(item))
{
var deletedImgList=db.ProductImages.Where(pImage => pImage.Name == item && pImage.ProductId == model.Id).ToList();
foreach(var deletedImg in deletedImgList)
{
db.ProductImages.Remove(deletedImg);
db.SaveChanges();
}
}
}
}
//find properties in db
var productPropertis = db.ProductProperties.Where(p => model.ProductPropertyForProduct.Contains(p.Id)).ToList();
var product = db.Products.Find(model.Id);
product.Name = model.Name;
product.ShortDescription = model.ShortDescription;
product.Description = model.Description;
product.Remark = model.Remark;
product.CoverImgUrl = newCoverImgUrl;
product.Price = model.Price;
product.CurrentDiscount = model.CurrentDiscount;
product.DiscountStartTime = model.DiscountStartTime;
product.DiscountEndTime = model.DiscountEndTime;
product.PublishTime = product.PublishTime;
product.IsSeasonalProduct = model.IsSeasonalProduct;
product.SaleStartTime = model.SaleStartTime;
product.SaleEndTime = product.SaleEndTime;
product.CategoryId = model.ProductCategoryForProduct;
//many to many relationship solution
product.Properties.Clear();
product.Properties = productPropertis;
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
model.ProductCategories = db.ProductCategories.ToList();
model.ProductProperties = db.ProductProperties.ToList();
return View(model);
}
public ActionResult Edit(ArticleManageEditViewModel model)
{
if (ModelState.IsValid)
{
var tagsList = ArticleHandler.ConvertTagsStringToList(model.ArticleTagsForArticle);
//check tags and save
foreach(var tagName in tagsList)
{
if (!db.ArticleTags.Any(t => t.Name ==tagName))
{
var articleTag = new ArticleTag
{
Name = tagName
};
db.ArticleTags.Add(articleTag);
db.SaveChanges();
}
}
string newCoverImgUrl;
if (model.CoverImg != null)
{
var uploadedFile = new UploadedFile(model.CoverImg);
var coverImgName = uploadedFile.SaveAsWithGuid(Server.MapPath("~/ImgRepository/ArticleImgs/" + model.Id));
var pathRel = Url.Content("~/ImgRepository/ArticleImgs/" + model.Id + "/" + coverImgName);
newCoverImgUrl = pathRel;
}
else
{
newCoverImgUrl = db.Articles.Find(model.Id).CoverImgUrl;
}
var article = db.Articles.Find(model.Id);
article.Id = model.Id;
article.Title = model.Title;
article.CoverImgUrl = newCoverImgUrl;
article.ShortDescription = model.ShortDescription;
article.Description = model.Description;
article.Content = model.Content;
article.Meta = model.Meta;
article.UrlSlug = model.UrlSlug;
article.IsPublished = model.IsPublished;
article.PostTime = model.PostTime;
article.ModifyTime = model.ModifyTime;
article.CategoryId = db.ArticleCategories.Find(model.ArticleCategoryForArticle).Id;
article.Category = db.ArticleCategories.Find(model.ArticleCategoryForArticle);
article.Tags.Clear();
article.Tags = db.ArticleTags.Where(t => tagsList.Contains(t.Name)).ToList();
article.Dialogs.Clear();
db.ArticleDialogs.Where(a => a.ArticleId == article.Id).ToList().ForEach(ad => db.ArticleDialogs.Remove(ad));
for (int i = 0; i < model.ArticleDialogs.Count; i++)
{
model.ArticleDialogs[i].SequenceNumber = i + 1;
}
article.Dialogs = model.ArticleDialogs;
db.Entry(article).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(model);
}