public JsonResult SubmitProductReview(Review review)
{
/*
* When submit the review,
* update NumberOfReviewCollect propety of Products & ReviewerTaskAsigns table's
*/
var getProduct = db.Products.Where(x => x.ProductId == review.ProductId).FirstOrDefault();
var getCollectReview = db.ReviewerTaskAsigns.Where(x => x.ReviewerId == review.ReviewerId && x.ProductId == review.ProductId).FirstOrDefault();
db.Reviews.Add(review);
if (getProduct.NumberOfReviewCollect == null)
{
getProduct.NumberOfReviewCollect = 0;
}
if (getCollectReview.NumberOfReviewCollect == null)
{
getCollectReview.NumberOfReviewCollect = 0;
}
getProduct.NumberOfReviewCollect = 1 + getProduct.NumberOfReviewCollect;
getCollectReview.NumberOfReviewCollect = 1 + getCollectReview.NumberOfReviewCollect;
db.Entry(getProduct).CurrentValues.SetValues(getProduct);
db.Entry(getCollectReview).CurrentValues.SetValues(getCollectReview);
db.SaveChanges();
return(new JsonResult
{
Data = new
{
Result = "IsOk"
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Edit([Bind(Include = "ID,CategoryName,ParentID,Status,Image,Sort,Note,Appendix")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit(Review review)
{
if (ModelState.IsValid)
{
_db.Entry(review).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
public Product Update(Product updatedProduct)
{
using (var context = new ReviewDbContext())
{
var existingProduct = GetById(updatedProduct.Id);
context.Entry(existingProduct).CurrentValues.SetValues(updatedProduct);
context.SaveChanges();
return(existingProduct);
}
}
public Comment Update(Comment updatedComment)
{
using (var context = new ReviewDbContext())
{
var existingComment = GetById(updatedComment.Id);
context.Entry(existingComment).CurrentValues.SetValues(updatedComment);
context.SaveChanges();
return(existingComment);
}
}
public JsonResult AcceptReviewerRequest(int Id)
{
var reviewer = db.Reviewers.Where(x => x.ReviewerId == Id).SingleOrDefault();
if (reviewer != null)
{
reviewer.AdminApprove = true;
db.Entry(reviewer).CurrentValues.SetValues(reviewer);
db.SaveChanges();
return(new JsonResult
{
Data = "IsOk",
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult
{
Data = "NotOk",
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
