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