public ActionResult Create([Bind(Exclude = "Category.Name")] ArticleViewModel model)
{
try
{
ModelState.Remove("Category.Name");
if (ModelState.IsValid)
{
var article = ArticleFactory.CreateArticleFromViewModel(model, KBVaultHelperFunctions.UserAsKbUser(User).Id);
var id = ArticleRepository.Add(article, model.Tags);
if (article.IsDraft == 0)
{
KbVaultLuceneHelper.AddArticleToIndex(article);
}
ShowOperationMessage(UIResources.ArticleCreatePageCreateSuccessMessage);
return(RedirectToAction("Edit", "Article", new { id = article.Id }));
}
return(View(model));
}
catch (Exception ex)
{
Log.Error(ex);
ModelState.AddModelError("Exception", ex.Message);
return(View(model));
}
}
public void RebuildIndexes()
{
var categories = CategoryRepository.GetAllCategories();
var totalCategories = categories.Count();
var indexingCategory = 1;
foreach (var cat in categories)
{
Clients.All.updateProgress(indexingCategory, totalCategories, cat.Name, "-");
var articles = CategoryRepository.GetArticles(cat.Id);
foreach (var article in articles)
{
Clients.All.updateProgress(indexingCategory, totalCategories, cat.Name, article.Title);
foreach (var attachment in article.Attachments)
{
try
{
KbVaultLuceneHelper.RemoveAttachmentFromIndex(attachment);
KbVaultLuceneHelper.AddAttachmentToIndex(attachment);
}
#pragma warning disable CC0004 // Catch block cannot be empty
catch (Exception)
{
}
#pragma warning restore CC0004 // Catch block cannot be empty
}
KbVaultLuceneHelper.AddArticleToIndex(article);
}
indexingCategory++;
}
Clients.All.updateProgress(string.Empty, string.Empty, string.Empty, "Finished indexing");
}
public FileController(IWebHostEnvironment env, IHttpContextAccessor httpContextAccessor, KnowledgeBaseContext context, KbVaultLuceneHelper lucene)
{
_env = env;
_httpContextAccessor = httpContextAccessor;
_context = context;
_lucene = lucene;
}
public void RebuildIndexes()
{
var categories = CategoryRepository.GetAllCategories();
int totalCategories = categories.Count();
int indexingCategory = 1;
foreach (var cat in categories)
{
Clients.All.updateProgress(indexingCategory, totalCategories, cat.Name, "-");
var articles = CategoryRepository.GetArticles(cat.Id);
foreach (var article in articles)
{
Clients.All.updateProgress(indexingCategory, totalCategories, cat.Name, article.Title);
foreach (var attachment in article.Attachments)
{
try
{
KbVaultLuceneHelper.RemoveAttachmentFromIndex(attachment);
KbVaultLuceneHelper.AddAttachmentToIndex(attachment);
}
catch (Exception ex)
{
//Eat it :d
}
}
KbVaultLuceneHelper.AddArticleToIndex(article);
}
indexingCategory++;
}
Clients.All.updateProgress("", "", "", "Finished indexing");
}
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 SearchController(KnowledgeBaseContext context, ISettingsService settingService, IHttpContextAccessor httpContextAccessor, IWebHostEnvironment env, KbVaultLuceneHelper lucene)
{
_context = context;
_settingService = settingService;
_httpContextAccessor = httpContextAccessor;
_env = env;
_lucene = lucene;
}
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));
}
}
public ActionResult Do(SearchFormViewModel model)
{
try
{
if (string.IsNullOrEmpty(model.SearchKeyword))
{
return(RedirectToAction("Index", "Home"));
}
var articlePrefix = SettingsService.GetSettings().ArticlePrefix;
if (!string.IsNullOrEmpty(articlePrefix))
{
if (model.SearchKeyword.Length > articlePrefix.Length + 1 &&
model.SearchKeyword.Substring(0, articlePrefix.Length + 1) == articlePrefix + "-")
{
var articleId = model.SearchKeyword.Substring(articlePrefix.Length + 1);
model.ArticleId = Convert.ToInt32(articleId);
}
if (model.ArticleId > 0)
{
Article article = null;
using (var db = new KbVaultContext())
{
article = db.PublishedArticles().FirstOrDefault(a => a.Id == model.ArticleId);
}
if (article != null)
{
return(RedirectToRoute("Default", new { controller = "Home", action = "Detail", id = article.SefName }));
}
}
}
if (model.CurrentPage == 0)
{
model.CurrentPage++;
}
model.Results = KbVaultLuceneHelper.DoSearch(model.SearchKeyword, model.CurrentPage, 10);
return(View(model));
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
public ActionResult Edit([Bind(Exclude = "Category.Name,Category.SefName")] ArticleViewModel model)
{
try
{
ModelState.Remove("Category.Name");
ModelState.Remove("Category.SefName");
if (ModelState.IsValid)
{
if (model.PublishEndDate < model.PublishStartDate)
{
ModelState.AddModelError("PublishDate", ErrorMessages.PublishEndDateMustBeGreater);
}
else
{
var article = ArticleRepository.Get(model.Id);
article.CategoryId = model.Category.Id;
article.IsDraft = model.IsDraft ? 1 : 0;
article.PublishEndDate = model.PublishEndDate;
article.PublishStartDate = model.PublishStartDate;
article.Edited = DateTime.Now;
article.Title = model.Title;
article.Content = model.Content;
article.Author = KBVaultHelperFunctions.UserAsKbUser(User).Id;
article.SefName = model.SefName;
ArticleRepository.Update(article, model.Tags);
if (article.IsDraft == 0)
{
KbVaultLuceneHelper.AddArticleToIndex(article);
}
else
{
KbVaultLuceneHelper.RemoveArticleFromIndex(article);
}
ShowOperationMessage(UIResources.ArticleCreatePageEditSuccessMessage);
}
}
}
catch (Exception ex)
{
Log.Error(ex);
ModelState.AddModelError("Exception", ex.Message);
}
return(View("Create", model));
}
public JsonResult More(SearchFormViewModel model)
{
JsonOperationResponse result = new JsonOperationResponse();
try
{
model.CurrentPage++;
model.Results = KbVaultLuceneHelper.DoSearch(model.SearchKeyword, model.CurrentPage, 1);
result.Successful = true;
result.Data = model;
}
catch (Exception ex)
{
Log.Error(ex);
result.ErrorMessage = ex.Message;
}
return(Json(result));
}
public JsonResult Ajax(string id)
{
JsonOperationResponse result = new JsonOperationResponse();
try
{
if (Request.IsAjaxRequest())
{
List <KbSearchResultItemViewModel> items = KbVaultLuceneHelper.DoSearch(id, 1, 10); //Request.Form["txtSearch"]);
result.Data = items;
result.Successful = true;
}
}
catch (Exception ex)
{
Log.Error(ex);
result.ErrorMessage = ex.Message;
}
return(Json(result));
}
public JsonResult Ajax(string id)
{
var result = new JsonOperationResponse();
try
{
if (Request.IsAjaxRequest())
{
var items = KbVaultLuceneHelper.DoSearch(id, 1, 10);
result.Data = items;
result.Successful = true;
}
}
catch (Exception ex)
{
Log.Error(ex);
result.ErrorMessage = ex.Message;
}
return(Json(result));
}
