protected override Task Handle(AddRatingToArticleCommand request, CancellationToken cancellationToken)
{
var articleRating = new ArticleRating {
ArticleIDfk = request.ArticleId, ArticleRatingScore = request.ArticleRating, UserIDfk = _userManager.GetUserId(request.User)
};
_context.ArticleRatings.Add(articleRating);
return(_context.SaveChangesAsync(cancellationToken));
}
public Task <int> AddRatingForArticle(int id, double rating, string userIDfk)
{
var articleRating = new ArticleRating {
ArticleIDfk = id, ArticleRatingScore = rating, UserIDfk = userIDfk
};
_context.ArticleRatings.Add(articleRating);
return(_context.SaveChangesAsync());
}
protected void LoadUserDataData()
{
var _user = new ApplicationUser {
Id = "userId"
};
var article = new ArticleRating {
ArticleRatingId = 1, ArticleIDfk = 1, UserIDfk = "userId", ApplicationUser = _user
};
Context.ArticleRatings.Add(article);
UserManager.CreateAsync(_user).Wait();
Context.SaveChanges();
}
public async Task <ActionResult> CreateRating([FromRoute] string articleId, [FromBody] CreateRatingDto dto)
{
var article = await _appDbContext.Articles.FirstOrDefaultAsync(i => i.Id == Guid.Parse(articleId));
var newRating = new ArticleRating()
{
Article = article,
Title = dto.Title,
Content = dto.Content,
Rating = dto.Rating,
Submitter = await GetCurrentUser()
};
article.Ratings.Add(newRating);
await _appDbContext.SaveChangesAsync();
return(Ok());
}
public ActionResult Feedback(ArticleRating Articlerating)
{
JsonResponse jsonResponse = new JsonResponse();
var context = new SitecoreContext();
bool success = false;
try
{
Articlerating.FeedbackSaved = false;
Sitecore.Data.Items.Item FAQItem = context.Database.GetItem((new ID(new Guid(Articlerating.FeedbackReference))));
BlueGreenContext bgContext = new BlueGreenContext();
if (bgContext != null && bgContext.bxgOwner != null)
{
Articlerating.UserReference = bgContext.bxgOwner.Email;
Articlerating.UserName = bgContext.bxgOwner.fullName;
Articlerating.UserType = bgContext.GetOwnerType();
}
Articlerating.ArticleTitle = FAQItem["Title"];
Articlerating.ArticlePath = FAQItem.Paths.GetPath(Sitecore.Data.Items.ItemPathType.DisplayName);
success = DBManager.InsertArticleFeedback(Articlerating);
if (success)
{
jsonResponse.RetCode = "0";
}
}
catch (Exception Ex)
{
jsonResponse.RetCode = "1";
jsonResponse.errors.Add("Error while saving the data, please Try later");
return(Json(jsonResponse, JsonRequestBehavior.AllowGet));
}
return(Json(jsonResponse, JsonRequestBehavior.AllowGet));
}