public void DeleteArticleTest()
{
ar.InsertCaffeArticle(a);
CaffeArticle c = ar.GetCaffeArticles().Where(x => x.Name == a.Name).ToList()[0];
Assert.IsTrue(ar.DeleteArticle(c.Article_ID) > 0);
ar.InsertCaffeArticle(a);
}
public HttpResponseMessage DeleteArticle(string Id)
{
ApiResultViewModel result = new ApiResultViewModel();
//取得使用者ID
string UserID = JWTShared.GetUserID(Request.Headers.Authorization.Parameter);
ArticleViewModel ArticleViewModel = articleRepository.GetArticle(Id, UserID);
if (ArticleViewModel == null)
{
result.Result = false;
result.Status = ResponseCode.Fail.ToString();
result.Message = "查無此文章資料!!!";
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
bool IsSuccess = articleRepository.DeleteArticle(Id, UserID);
if (IsSuccess)
{
result.Result = true;
result.Status = ResponseCode.Success.ToString();
result.Message = "刪除成功!!!";
}
else
{
result.Result = false;
result.Status = ResponseCode.Fail.ToString();
result.Message = "刪除文章資料發生錯誤!!!";
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public JsonResult Delete(int id)
{
using (var aRepository = new ArticleRepository())
{
bool bSuccess = aRepository.DeleteArticle(id);
return(Json(new
{
success = bSuccess
},
JsonRequestBehavior.AllowGet));
}
}
public async Task <IResponse> DeleteArticle(long id)
{
IResponse response = new Response()
{
IsSuccess = false
};
using (var dbTransaction = await _dbContext.Database.BeginTransactionAsync())
{
try
{
var deleteArticelTagResponse = await _articleTagRepository.DeleteByArticleId(id);
if (deleteArticelTagResponse.IsSuccess)
{
response = await _articleRepository.DeleteArticle(id);
if (response.IsSuccess)
{
await dbTransaction.CommitAsync();
}
else
{
await dbTransaction.RollbackAsync();
}
}
else
{
await dbTransaction.RollbackAsync();
return(deleteArticelTagResponse);
}
}
catch (Exception e)
{
await dbTransaction.RollbackAsync();
response.IsSuccess = false;
response.Message = e.Message;
}
}
return(response);
}
public IActionResult ArticleDelete(int articleId)
{
articleRepository.DeleteArticle(articleRepository.getArticleById(articleId));
return(RedirectToAction("Index", "Home"));
}
public ActionResult Delete(Models.Article e)
{
repo.DeleteArticle(e);
return(RedirectToAction("Index"));
}
public async Task <ManipulateArticlesCommandResponse> Handle(ManipulateArticlesCommand request, CancellationToken cancellationToken)
{
ManipulateArticlesCommandResponse response = new ManipulateArticlesCommandResponse()
{
IsSuccessful = false
};
Disclaimers DisclaimersDetails = new Disclaimers();
ResourceGroups ResourceGroupsDetails = new ResourceGroups();
Provinces ProvincesDetails = new Provinces();
List <TaxTags> taxTagsDetails = new List <TaxTags>();
List <Articles> articlesDetails = new List <Articles>();
List <Articles> articles = _ArticleRepository.getArticleCompleteDataById(request.ArticlesIds);
if (request.ArticlesIds.Count != articles.Count)
{
throw new RulesException("Invalid", @"Country not found");
}
using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
if (request.Operation == "Publish")
{
foreach (var article in articles)
{
article.IsPublished = true;
_ArticleRepository.Update <Articles>(article);
}
}
else if (request.Operation == "UnPublish")
{
foreach (var article in articles)
{
article.IsPublished = false;
_ArticleRepository.Update <Articles>(article);
}
}
else if (request.Operation == "Delete")
{
foreach (Articles article in articles)
{
foreach (var content in article.ArticleContents.ToList())
{
article.ArticleContents.Remove(content);
_ArticleRepository.Delete <ArticleContents>(content);
}
foreach (var country in article.ArticleRelatedCountries.ToList())
{
article.ArticleRelatedCountries.Remove(country);
}
foreach (var countryGroup in article.ArticleRelatedCountryGroups.ToList())
{
article.ArticleRelatedCountryGroups.Remove(countryGroup);
}
foreach (var taxTag in article.ArticleRelatedTaxTags.ToList())
{
article.ArticleRelatedTaxTags.Remove(taxTag);
}
foreach (var relatedArticle in article.RelatedArticlesArticle.ToList())
{
article.RelatedArticlesArticle.Remove(relatedArticle);
//Remove reverse relation
// relatedArticle.RelatedArticles.Remove(article);
}
foreach (var relatedResource in article.RelatedResourcesArticle.ToList())
{
article.RelatedResourcesArticle.Remove(relatedResource);
}
foreach (var readArticle in article.UserReadArticles.ToList())
{
article.UserReadArticles.Remove(readArticle);
_ArticleRepository.Delete <UserReadArticles>(readArticle);
}
foreach (var savedArticle in article.UserSavedArticles.ToList())
{
article.UserSavedArticles.Remove(savedArticle);
_ArticleRepository.Delete <UserSavedArticles>(savedArticle);
}
foreach (var contact in article.ArticleRelatedContacts.ToList())
{
article.ArticleRelatedContacts.Remove(contact);
}
_ArticleRepository.DeleteArticle(article);
}
}
else
{
throw new RulesException("Operation", @"The Operation " + request.Operation + " is not valied");
}
await _ArticleRepository.UnitOfWork
.SaveEntitiesAsync();
response.IsSuccessful = true;
scope.Complete();
}
var articleDocs = _context.GetAll(Constants.ArticlesDiscriminator);
if (request.Operation == "Publish" || request.Operation == "UnPublish")
{
foreach (var article in articles)
{
taxTagsDetails = _ArticleRepository.getTaxTagsDetailsByIds(article.ArticleRelatedTaxTags.Select(s => s.TaxTagId).ToList());
articlesDetails = _ArticleRepository.getArticleCompleteDataById(article.RelatedArticlesArticle.Select(s => s.RelatedArticleId).ToList());
ResourceGroupsDetails = article.ResourceGroupId == null ? null : _ArticleRepository.getResourceGroupById(int.Parse(article.ResourceGroupId.ToString()));
ProvincesDetails = article.ProvinceId == null ? null : _ArticleRepository.getProvisionsById(int.Parse(article.ProvinceId.ToString()));
DisclaimersDetails = article.DisclaimerId == null ? null : _ArticleRepository.getDisclaimerById(int.Parse(article.DisclaimerId.ToString()));
using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
foreach (var doc in articleDocs.Where(d => d.GetPropertyValue <int>("ArticleId") == article.ArticleId))
{
var DisclaimerLanguageId = DisclaimersDetails.DisclaimerContents.Where(d => d.LanguageId == doc.GetPropertyValue <int>("LanguageId")).Count() > 0 ? doc.GetPropertyValue <int>("LanguageId") : 37;
var ResourceGroupLanguageId = ResourceGroupsDetails.ResourceGroupContents.Where(d => d.LanguageId == doc.GetPropertyValue <int>("LanguageId")).Count() > 0 ? doc.GetPropertyValue <int>("LanguageId") : 37;
var ProvisionsLanguageId = ProvincesDetails.ProvinceContents.Where(d => d.LanguageId == doc.GetPropertyValue <int>("LanguageId")).Count() > 0 ? doc.GetPropertyValue <int>("LanguageId") : 37;
var eventSourcing = new ArticleCommandEvent()
{
id = doc != null?doc.GetPropertyValue <Guid>("id") : Guid.NewGuid(),
EventType = doc != null ? ServiceBusEventType.Update : ServiceBusEventType.Create,
ArticleId = article.ArticleId,
PublishedDate = article.PublishedDate == null ? "" : article.PublishedDate.ToString(),
Author = article.Author == null ? "" : article.Author,
ImageId = article.ImageId == null ? -1 : article.ImageId,
State = article.State == null ? "" : article.State,
Type = article.Type == null ? -1 : article.Type,
SubType = article.SubType == null ? -1 : article.SubType,
ResourcePosition = article.ResourcePosition == null ? -1 : article.ResourcePosition,
Disclaimer = new DisclamersSchema
{
DisclaimerId = int.Parse(article.DisclaimerId.ToString()), ProviderName = DisclaimersDetails.DisclaimerContents.Where(d => d.LanguageId == DisclaimerLanguageId).Select(ds => ds.ProviderName == null ? "" : ds.ProviderName).FirstOrDefault(), ProviderTerms = DisclaimersDetails.DisclaimerContents.Where(d => d.LanguageId == DisclaimerLanguageId).Select(ds => ds.ProviderTerms == null ? "" : ds.ProviderTerms).FirstOrDefault()
},
ResourceGroup = new ResourceGroupsSchema {
ResourceGroupId = int.Parse(article.ResourceGroupId.ToString()), GroupName = ResourceGroupsDetails.ResourceGroupContents.Where(d => d.LanguageId == ResourceGroupLanguageId).Select(ds => ds.GroupName == null ? "" : ds.GroupName).FirstOrDefault(), Position = ResourceGroupsDetails.Position == null ? -1 : ResourceGroupsDetails.Position
},
IsPublished = request.Operation == "Publish" ? true : false,
CreatedDate = article.CreatedDate == null ? "" : article.CreatedDate.ToString(),
CreatedBy = article.CreatedBy == null ? "" : article.CreatedBy,
UpdatedDate = article.UpdatedDate == null ? "" : article.UpdatedDate.ToString(),
UpdatedBy = article.UpdatedBy == null ? "" : article.UpdatedBy,
NotificationSentDate = article.NotificationSentDate == null ? "" : article.NotificationSentDate.ToString(),
Provinces = new ProvinceSchema {
ProvinceId = int.Parse(article.ProvinceId.ToString()), DisplayName = ProvincesDetails.ProvinceContents.Where(d => d.LanguageId == ProvisionsLanguageId).Select(ds => ds.DisplayName == null ? "" : ds.DisplayName).FirstOrDefault()
},
ArticleContentId = doc.GetPropertyValue <int>("ArticleContentId") == null ? -1 : doc.GetPropertyValue <int>("ArticleContentId"),
LanguageId = doc.GetPropertyValue <int>("LanguageId") == null ? -1 : doc.GetPropertyValue <int>("LanguageId"),
Title = doc.GetPropertyValue <string>("Title") == null ? "" : doc.GetPropertyValue <string>("Title"),
TitleInEnglishDefault = doc.GetPropertyValue <string>("TitleInEnglishDefault") == null ? "" : doc.GetPropertyValue <string>("TitleInEnglishDefault"),
TeaserText = doc.GetPropertyValue <string>("TeaserText") == null ? "" : doc.GetPropertyValue <string>("TeaserText"),
Content = doc.GetPropertyValue <string>("Content") == null ? "" : doc.GetPropertyValue <string>("Content"),
RelatedContacts = article.ArticleRelatedContacts.Select(s => new RelatedEntityId {
IdVal = s.ContactId
}).ToList(),
RelatedCountries = article.ArticleRelatedCountries.Select(s => new RelatedEntityId {
IdVal = s.CountryId
}).ToList(),
RelatedCountryGroups = article.ArticleRelatedCountryGroups.Select(s => new RelatedEntityId {
IdVal = s.CountryGroupId
}).ToList(),
RelatedTaxTags = article.ArticleRelatedTaxTags.Select(s => { var RelatedtaxTagLanguageId = taxTagsDetails.Where(td => td.TaxTagId == s.TaxTagId).FirstOrDefault().TaxTagContents.Where(ttc => ttc.LanguageId == doc.GetPropertyValue <int>("LanguageId")).Count() > 0 ? doc.GetPropertyValue <int>("LanguageId") : 37; return(new RelatedTaxTagsSchema {
TaxTagId = s.TaxTagId, DisplayName = taxTagsDetails.Where(td => td.TaxTagId == s.TaxTagId).FirstOrDefault().TaxTagContents.Where(ttc => ttc.LanguageId == RelatedtaxTagLanguageId).Select(ttcs => ttcs.DisplayName == null ? "" : ttcs.DisplayName).FirstOrDefault()
}); }).ToList(),
RelatedArticles = article.RelatedArticlesArticle.Select(s => { var RelatedArticleLanguageId = articlesDetails.Where(ra => ra.ArticleId.Equals(s.RelatedArticleId)).FirstOrDefault().ArticleContents.Where(ttc => ttc.LanguageId == doc.GetPropertyValue <int>("LanguageId")).Count() > 0 ? doc.GetPropertyValue <int>("LanguageId") : 37; return(new RelatedArticlesSchema {
ArticleId = s.RelatedArticleId, PublishedDate = articlesDetails.Where(ra => ra.ArticleId.Equals(s.RelatedArticleId)).Select(v => v.PublishedDate == null ? "" : v.PublishedDate.ToString()).FirstOrDefault().ToString(), Title = articlesDetails.Where(ra => ra.ArticleId.Equals(s.RelatedArticleId)).FirstOrDefault().ArticleContents.Where(ttc => ttc.LanguageId == RelatedArticleLanguageId).Select(v => v.Title == null ? "" : v.Title).FirstOrDefault().ToString(), CountryId = articlesDetails.Where(ad => ad.ArticleId.Equals(s.RelatedArticleId)).FirstOrDefault().ArticleRelatedCountries.Select(arc => new RelatedEntityId {
IdVal = arc.CountryId
}).ToList()
}); }).ToList(),
RelatedResources = article.RelatedResourcesArticle.Select(s => { var RelatedResourceLanguageId = articlesDetails.Where(ra => ra.ArticleId.Equals(s.RelatedArticleId)).FirstOrDefault().ArticleContents.Where(ttc => ttc.LanguageId == doc.GetPropertyValue <int>("LanguageId")).Count() > 0 ? doc.GetPropertyValue <int>("LanguageId") : 37; return(new RelatedArticlesSchema {
ArticleId = s.RelatedArticleId, PublishedDate = articlesDetails.Where(ra => ra.ArticleId.Equals(s.RelatedArticleId)).Select(v => v.PublishedDate == null ? "" : v.PublishedDate.ToString()).FirstOrDefault().ToString(), Title = articlesDetails.Where(ra => ra.ArticleId.Equals(s.RelatedArticleId)).FirstOrDefault().ArticleContents.Where(ttc => ttc.LanguageId == RelatedResourceLanguageId).Select(v => v.Title == null ? "" : v.Title).FirstOrDefault().ToString(), CountryId = articlesDetails.Where(ad => ad.ArticleId.Equals(s.RelatedArticleId)).FirstOrDefault().ArticleRelatedCountries.Select(arc => new RelatedEntityId {
IdVal = arc.CountryId
}).ToList()
}); }).ToList(),
Discriminator = Constants.ArticlesDiscriminator,
PartitionKey = ""
};
await _Eventcontext.PublishThroughEventBusAsync(eventSourcing);
}
scope.Complete();
}
}
}
else if (request.Operation == "Delete")
{
using (TransactionScope scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
foreach (var item in articles)
{
foreach (var content in item.ArticleContents)
{
foreach (var article in articleDocs.Where(ad => ad.GetPropertyValue <int>("LanguageId") == content.LanguageId))
{
foreach (var relatedArticles in article.GetPropertyValue <List <RelatedArticlesSchema> >("RelatedArticles"))
{
if (relatedArticles.ArticleId == item.ArticleId)
{
List <RelatedArticlesSchema> relatedArticleSchema = new List <RelatedArticlesSchema>();
relatedArticleSchema = article.GetPropertyValue <List <RelatedArticlesSchema> >("RelatedArticles");
var index = relatedArticleSchema.IndexOf(relatedArticleSchema.Where(i => i.ArticleId == item.ArticleId).First());
if (index != -1)
{
relatedArticleSchema.Remove(relatedArticleSchema.Where(i => i.ArticleId == item.ArticleId).First());
}
var eventSourcingRelated = new ArticleCommandEvent()
{
id = article != null?article.GetPropertyValue <Guid>("id") : Guid.NewGuid(),
EventType = ServiceBusEventType.Update,
ArticleId = article.GetPropertyValue <int>("ArticleId"),
PublishedDate = article.GetPropertyValue <string>("PublishedDate"),
Author = article.GetPropertyValue <string>("author"),
ImageId = article.GetPropertyValue <int>("ImageId"),
State = article.GetPropertyValue <string>("State"),
Type = article.GetPropertyValue <int>("Type"),
SubType = article.GetPropertyValue <int>("SubType"),
ResourcePosition = article.GetPropertyValue <int>("ResourcePosition"),
Disclaimer = article.GetPropertyValue <DisclamersSchema>("Disclaimer"),
ResourceGroup = article.GetPropertyValue <ResourceGroupsSchema>("ResourceGroup"),
IsPublished = article.GetPropertyValue <bool>("IsPublished"),
CreatedDate = article.GetPropertyValue <string>("CreatedDate"),
CreatedBy = article.GetPropertyValue <string>("CreatedBy"),
UpdatedDate = article.GetPropertyValue <string>("UpdatedDate"),
UpdatedBy = article.GetPropertyValue <string>("UpdatedBy"),
NotificationSentDate = article.GetPropertyValue <string>("NotificationSentDate"),
Provinces = article.GetPropertyValue <ProvinceSchema>("Provisions"),
ArticleContentId = article.GetPropertyValue <int>("ArticleContentId"),
LanguageId = article.GetPropertyValue <int>("LanguageId"),
Title = article.GetPropertyValue <string>("Title"),
TitleInEnglishDefault = article.GetPropertyValue <string>("TitleInEnglishDefault"),
TeaserText = article.GetPropertyValue <string>("TeaserText"),
Content = article.GetPropertyValue <string>("Content"),
RelatedContacts = article.GetPropertyValue <List <RelatedEntityId> >("RelatedContacts"),
RelatedCountries = article.GetPropertyValue <List <RelatedEntityId> >("RelatedCountries"),
RelatedCountryGroups = article.GetPropertyValue <List <RelatedEntityId> >("RelatedCountryGroups"),
RelatedTaxTags = article.GetPropertyValue <List <RelatedTaxTagsSchema> >("RelatedTaxTags"),
RelatedArticles = relatedArticleSchema,
RelatedResources = article.GetPropertyValue <List <RelatedArticlesSchema> >("RelatedResources"),
Discriminator = article.GetPropertyValue <string>("Discriminator"),
PartitionKey = ""
};
await _Eventcontext.PublishThroughEventBusAsync(eventSourcingRelated);
}
}
}
}
foreach (var doc in articleDocs.Where(d => d.GetPropertyValue <int>("ArticleId") == item.ArticleId))
{
var articleevent = new ArticleCommandEvent()
{
id = doc.GetPropertyValue <Guid>("id"),
EventType = ServiceBusEventType.Delete,
Discriminator = Constants.ArticlesDiscriminator,
PartitionKey = doc.GetPropertyValue <int>("LanguageId").ToString()
};
await _Eventcontext.PublishThroughEventBusAsync(articleevent);
}
}
scope.Complete();
}
}
return(response);
}
