public ActionResult AddComment(int id, string Content, int rating) { //取得使用者Id var UserId = HttpContext.User.Identity.Name; var currentDateTime = DateTime.Now; using (UserEntities Userdb = new UserEntities()) { var NickName = (from s in Userdb.AspNetUsers where s.UserName == UserId select s.Name).FirstOrDefault(); var ImgUrl = (from s in Userdb.AspNetUsers where s.UserName == UserId select s.ImgUrl).FirstOrDefault(); rating = (rating <= 0) ? 1 :(rating >= 5) ? 5 : rating; var comment = new ProductCommet() { ProductId = id, UserId = NickName, Content = Content, CreateDate = currentDateTime, ImgUrl = ImgUrl, Stars = rating }; using (CartsEntities db = new CartsEntities()) { db.ProductCommets.Add(comment); db.SaveChanges(); } } return(RedirectToAction("Detail", new { id = id })); }
private void InitProductAndProductComment() { var product = new Product() { Id = 1, Name = "Book", Description = "This is a book" }; var productComment1 = new ProductCommet() { Id = 1, ProductId = 1, Content = "This is good.", CreateDate = DateTime.Now }; var productComment2 = new ProductCommet() { Id = 2, ProductId = 1, Content = "This is bad.", CreateDate = DateTime.Now }; _context.Products.Add(product); _context.ProductCommets.Add(productComment1); _context.ProductCommets.Add(productComment2); _context.SaveChanges(); }
private void InitProductAndComment() { var productManager = _IOC.GetService <IProductManager>(); var product = new Product() { Id = 1, Name = "Book", Description = "This is a book" }; var productComment1 = new ProductCommet() { Id = 1, ProductId = 1, Content = "This is good.", CreateDate = DateTime.Now }; var productComment2 = new ProductCommet() { Id = 2, ProductId = 1, Content = "This is bad.", CreateDate = DateTime.Now }; productManager.ProductRepo.Create(product); productManager.ProductCommentRepo.Create(productComment1); productManager.ProductCommentRepo.Create(productComment2); }
public void ProductManagerInsertTest() { var productManager = _IOC.GetService <IProductManager>(); var product = new Product() { Id = 2, Name = "Book", Description = "This is a book" }; var productComment1 = new ProductCommet() { Id = 998, ProductId = 2, Content = "This is good.", CreateDate = DateTime.Now }; var productComment2 = new ProductCommet() { Id = 999, ProductId = 2, Content = "This is bad.", CreateDate = DateTime.Now }; productManager.ProductRepo.Create(product); productManager.ProductCommentRepo.Create(productComment1); productManager.ProductCommentRepo.Create(productComment2); var result1 = productManager.ProductRepo.FindByCondition(p => p.Id == 2).FirstOrDefault(); var result2 = productManager.ProductCommentRepo.FindByCondition(p => p.ProductId == 2).FirstOrDefault(); Assert.NotNull(result1); Assert.NotNull(result2); }
[Authorize] // must login to add comment public ActionResult AddReview(int id, string pContent) { var userName = User.FindFirst(ClaimTypes.Name).Value; // will give the user's userName var currentDateTime = DateTime.Now; var comment = new ProductCommet { ProductId = id, Content = pContent, UserId = userName, CreateDate = currentDateTime }; _productManager.ProductCommentRepo.Create(comment); return(RedirectToAction("Details", new { pId = id })); }