public IActionResult CreateOrUpdate([FromBody] CmsContent data)
{
if (string.IsNullOrEmpty(data.Title))
{
return(Json(new JsonResponse <string> {
code = 1, message = "Title can not be empty"
}));
}
if (data.Id == null || data.Id == Guid.Empty)
{
data.Id = Guid.NewGuid();
}
data = data.CalculateThumbnail();
using (var db = new MoneyNoteDbContext())
{
var exited = db.CmsContents.FirstOrDefault(i => i.Id == data.Id);
if (exited == null)
{
data.CountView = 0;
db.CmsContents.Add(data);
}
else
{
exited.ParentId = data.ParentId;
exited.Title = data.Title;
exited.Thumbnail = data.Thumbnail;
exited.UrlRef = data.UrlRef;
exited.Description = data.Description;
exited.IsDeleted = data.IsDeleted;
exited.ThumbnailWidth = data.ThumbnailWidth;
exited.ThumbnailHeight = data.ThumbnailHeight;
exited.VideoWidth = data.VideoWidth;
exited.VideoHeight = data.VideoHeight;
exited.IsPublished = data.IsPublished;
}
db.SaveChanges();
var existed = db.CmsRelations.Where(i => i.ContentId == data.Id).ToList();
db.RemoveRange(existed);
db.SaveChanges();
db.AddRange(data.CategoryIds.Select(c => new CmsRelation
{
ContentId = data.Id,
CategoryId = c
}).ToList());
db.SaveChanges();
}
return(Json(new JsonResponse <CmsContent> {
data = data
}));
}
public IActionResult Delete([FromBody] CmsCategory data)
{
using (var db = new MoneyNoteDbContext())
{
data = db.CmsCategories.FirstOrDefault(i => i.Id == data.Id);
if (data != null)
{
db.RemoveRange(db.CmsRelations.Where(i => i.CategoryId == data.Id));
db.CmsCategories.Remove(data);
db.SaveChanges();
}
}
return(Json(new JsonResponse <CmsCategory> {
data = data
}));
}
public IActionResult UpdateRelation([FromBody] ContentRelationModel data)
{
using (var db = new MoneyNoteDbContext())
{
var existed = db.CmsRelations.Where(i => i.ContentId == data.ContentId).ToList();
db.RemoveRange(existed);
db.SaveChanges();
db.AddRange(data.CategoryIds.Select(c => new CmsRelation
{
ContentId = data.ContentId,
CategoryId = c
}).ToList());
db.SaveChanges();
}
return(Json(new JsonResponse <ContentRelationModel> {
data = data
}));
}