public JsonResult Remove(string id) { JsonOperationResponse result = new JsonOperationResponse(); result.Successful = false; try { var parts = id.Split(new[] { "|" }, StringSplitOptions.RemoveEmptyEntries); if (parts.Length == 2) { var attachmentHash = parts[0]; var attachmentId = parts[1]; Attachment at = new Attachment() { Id = Convert.ToInt64(attachmentId) }; at.Author = KBVaultHelperFunctions.UserAsKbUser(User).Id; KbVaultAttachmentHelper.RemoveAttachment(attachmentHash, KBVaultHelperFunctions.UserAsKbUser(User).Id); KbVaultLuceneHelper.RemoveAttachmentFromIndex(at); result.Successful = true; return(Json(result)); } throw new ArgumentOutOfRangeException("Invalid file hash"); } catch (Exception ex) { Log.Error(ex); result.ErrorMessage = ex.Message; return(Json(result)); } }
public JsonResult Remove(int id) { var result = new JsonOperationResponse(); try { using (var db = new KbVaultContext()) { var currentUserId = KBVaultHelperFunctions.UserAsKbUser(User).Id; var queryParams = new SqlParameter[] { new SqlParameter("ArticleId", id) }; db.Database.ExecuteSqlCommand("Delete from ArticleTag Where ArticleId = @ArticleId", queryParams); var article = db.Articles.Single(a => a.Id == id); if (article == null) { throw new Exception(ErrorMessages.ArticleNotFound); } while (article.Attachments.Count > 0) { var a = article.Attachments.First(); KbVaultAttachmentHelper.RemoveLocalAttachmentFile(a); KbVaultLuceneHelper.RemoveAttachmentFromIndex(a); article.Attachments.Remove(a); /* * Also remove the attachment from db.attachments collection * * http://stackoverflow.com/questions/17723626/entity-framework-remove-vs-deleteobject * * If the relationship is required (the FK doesn't allow NULL values) and the relationship is not * identifying (which means that the foreign key is not part of the child's (composite) primary key) * you have to either add the child to another parent or you have to explicitly delete the child * (with DeleteObject then). If you don't do any of these a referential constraint is * violated and EF will throw an exception when you call SaveChanges - * the infamous "The relationship could not be changed because one or more of the foreign-key properties * is non-nullable" exception or similar. */ db.Attachments.Remove(a); } article.Author = currentUserId; KbVaultLuceneHelper.RemoveArticleFromIndex(article); db.Articles.Remove(article); db.SaveChanges(); result.Data = id; result.Successful = true; return(Json(result)); } } catch (Exception ex) { Log.Error(ex); result.Successful = false; result.ErrorMessage = ex.Message; return(Json(result)); } }
public ArticlesController(KnowledgeBaseContext context, IHttpContextAccessor httpContextAccessor, IArticleFactory articleFactory, IArticleRepository articleRepository, IUserRepository userRepository, IActivityRepository activityRepository, KbVaultLuceneHelper lucene, KbVaultAttachmentHelper attachmentHelper) { _context = context; _httpContextAccessor = httpContextAccessor; _articleFactory = articleFactory; _articleRepository = articleRepository; _userRepository = userRepository; _activityRepository = activityRepository; _lucene = lucene; this.attachmentHelper = attachmentHelper; }
public JsonResult Upload() { var result = new JsonOperationResponse { Successful = false }; try { if (Request.Params["ArticleId"] == null) { result.ErrorMessage = ErrorMessages.FileUploadArticleNotFound; } else if (Request.Files.Count == 1) { var articleId = Convert.ToInt64(Request.Params["ArticleId"]); var attachedFile = Request.Files[0]; var attachment = KbVaultAttachmentHelper.SaveAttachment(articleId, attachedFile, KBVaultHelperFunctions.UserAsKbUser(User).Id); attachment.Author = KBVaultHelperFunctions.UserAsKbUser(User).Id; result.Successful = true; result.Data = new AttachmentViewModel(attachment); using (var db = new KbVaultContext()) { var sets = db.Settings.FirstOrDefault(); if (sets != null) { var extensions = sets.IndexFileExtensions.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); if (extensions.FirstOrDefault(a => a.ToLowerInvariant() == attachment.Extension.ToLowerInvariant()) != null) { KbVaultLuceneHelper.AddAttachmentToIndex(attachment); } } } } else { result.ErrorMessage = ErrorMessages.FileUploadTooManyFiles; } return(Json(result)); } catch (Exception ex) { log.Error(ex); result.ErrorMessage = ex.Message; return(Json(result)); } }