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