public async Task <ActionResult> RatingsProduct(long id, int rate) { var TaiKhoan = GetUser(); if (TaiKhoan == null) { return(Json(new RatingViewModel() { IsSuccess = false, Message = "Bạn chưa đăng nhập!" }, JsonRequestBehavior.AllowGet)); } var sanPham = db.SANPHAMs.Find(id); if (sanPham == null) { return(Json(new RatingViewModel() { IsSuccess = false, Message = "Sản phẩm không tồn tại!" }, JsonRequestBehavior.AllowGet)); } var check = db.DANHGIASANPHAMs.SingleOrDefault(x => x.SanPhamId == id && x.TaiKhoanId == TaiKhoan.ID); if (check != null) { check.DanhGia = rate; db.DANHGIASANPHAMs.AddOrUpdate(check); } else { var rating = new DANHGIASANPHAM() { DanhGia = rate, SanPhamId = id, TaiKhoanId = TaiKhoan.ID }; db.DANHGIASANPHAMs.Add(rating); } //var items = db.DANHGIASANPHAMs.Where(x => x.SanPhamId == id).Average(x => x.DanhGia); //sanPham.DanhGia = items; //db.SANPHAMs.AddOrUpdate(sanPham); await db.SaveChangesAsync(); return(Json(new RatingViewModel() { IsSuccess = true, Message = "/SanPham/ChiTiet/" + id }, JsonRequestBehavior.AllowGet)); }
public ActionResult ChiTietSanPham(int iMaSach, string iName, string iComment, string Ngay, int iRating, DANHGIASANPHAM DG) { DG.MaSP = iMaSach; DG.HoTenKH = iName; DG.BinhLuan = iComment; DG.DiemDG = iRating; DG.ThoiGian = DateTime.Parse(Ngay); TempData["MaSach"] = iMaSach; db.DANHGIASANPHAMs.Add(DG); db.SaveChanges(); List <DANHGIASANPHAM> LDG = db.DANHGIASANPHAMs.Where(n => n.MaSP == iMaSach).ToList(); double DGTB = 0; int DiemDG = 0; for (int i = 0; i < LDG.Count(); i++) { DiemDG += int.Parse(DG.DiemDG.ToString()); } DGTB = DiemDG / LDG.Count(); return(RedirectToAction("Login", "Home")); }