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