public static Boolean danhgiatour(string maDon, string soSao, string noiDung) { int temp; if (int.TryParse(soSao, out temp) && int.TryParse(maDon, out temp) && noiDung != null) { DanhGiaController danhGiaSaoController = new DanhGiaController(); DanhGia danhGia = new DanhGia(); danhGia.MaDonDatTour = Convert.ToInt32(maDon); danhGia.NoiDung = noiDung; danhGia.SoSao = Convert.ToInt32(soSao); danhGia.ThoiGian = DateTime.Now; if (danhGiaSaoController.danhGia(danhGia)) { return(true); } else { Debug.WriteLine(maDon + " " + soSao + " " + noiDung); } return(false); } else { return(false); } }
public async Task <ActionResult> Index(DanhGia danhGia) { try { var kh = Session["LOGIN"] as KhachHang; danhGia.NgayDG = DateTime.Now; danhGia.SDT = kh.SDT; using (SqlConnection con = new SqlConnection(_connectionString)) { danhGia.NoiDungDG = "KH: " + danhGia.HoTen + ", SDT: " + danhGia.SDT + ", Email: " + danhGia.Email + ", Đánh giá: " + danhGia.NoiDungDG + ""; string cmdText = "INSERT INTO [dbo].[DanhGia] ([SDT] ,[NoiDungDG] ,[NgayDG]) VALUES (N'" + danhGia.SDT + "' , N'" + danhGia.NoiDungDG + "', N'" + danhGia.NgayDG.ToString("yyyy-MM-dd") + "');"; SqlCommand cmd = new SqlCommand(cmdText, con); con.Open(); if (cmd.ExecuteNonQuery() > 0) { string content = string.Format("Xin chào {0}, cảm ơn bạn đã gửi đánh giá cho chúng tôi! <br/> Nếu bạn không phải người gửi đóng góp, vui lòng bỏ qua mail này!", danhGia.HoTen); await EmailSender.SendGMail(danhGia.Email, content); } con.Close(); con.Dispose(); } } catch (Exception ex) { TempData["message"] = ex.Message; } return(RedirectToAction("Thank")); }
public ActionResult DanhGia(int star, string maSach) { NguoiDung ND = (NguoiDung)Session["TaiKhoan"]; var DanhGiaVeSach = db.DanhGia.Where(s => s.MaSach == maSach).Where(s => s.MaND == ND.TenDN).ToList(); if (DanhGiaVeSach.Count != 0) { DanhGiaVeSach[0].SoSao = star; } else { DanhGia dg = new DanhGia(); dg.MaND = ND.TenDN; dg.MaSach = maSach; dg.SoSao = star; db.DanhGia.Add(dg); } db.SaveChanges(); var sumStar = 0; var Star = db.DanhGia.Where(m => m.MaSach == maSach).ToList(); foreach (var item in Star) { sumStar += Convert.ToInt32(item.SoSao); } sumStar = Convert.ToInt32(sumStar / Star.Count()); var Sach = db.Sach.Where(m => m.MaSach == maSach).ToList(); Sach[0].DanhGia = sumStar; db.SaveChanges(); return(null); }
public JsonResult AddDanhGia(DanhGia dg) { if (ModelState.IsValid) { DanhGia danhGia = new DanhGia(); danhGia.MaKhach = (int)Session["MaKhach"]; danhGia.TenSP = dg.TenSP; danhGia.NoiDung = dg.NoiDung; danhGia.NgayDG = DateTime.Now; danhGia.DanhGiaStar = dg.DanhGiaStar; db.DanhGias.Add(danhGia); db.SaveChanges(); List <HoaDonBan> hoaDonBans = db.HoaDonBans.Where(x => x.MaKhach == danhGia.MaKhach).ToList(); List <ChiTietHDB> chiTiet = new List <ChiTietHDB>(); foreach (var sohdb in hoaDonBans) { chiTiet = db.ChiTietHDBs.Where(x => x.SoHDB == sohdb.SoHDB && x.SanPham.TenSP == dg.TenSP).ToList(); if (chiTiet.Count > 0) { foreach (ChiTietHDB chi in chiTiet) { chi.MaDG = danhGia.MaDG; db.SaveChanges(); } } } } return(Json(new { Success = true }, JsonRequestBehavior.AllowGet)); }
public async Task <IActionResult> PutDanhGia(int id, DanhGia danhGia) { if (id != danhGia.MaDanhGia) { return(BadRequest()); } _context.Entry(danhGia).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DanhGiaExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <DanhGia> > PostDanhGia(DanhGia danhGia) { _context.danhGias.Add(danhGia); await _context.SaveChangesAsync(); return(CreatedAtAction("GetDanhGia", new { id = danhGia.MaDanhGia }, danhGia)); }
internal void TimKiem(DanhGia danhGia, long id) { danhGia.ketQuaThi1 = new TracNghiemOnlineDB().De_Thi.Where(x => x.MaDeThi == id).ToList().Last(); List <NoiDungThi> noiDungs = new List <NoiDungThi>(); foreach (var item in danhGia.ketQuaThi1.CauHoiDeThis) { foreach (var item1 in noiDungs) { if (item1.noidung.Ma_Chuong == item.Kho_CauHoi.Ma_Chuong) { item1.SoCau++; } } if (!noiDungs.Exists(x => x.noidung.Ma_Chuong == item.Kho_CauHoi.Ma_Chuong)) { noiDungs.Add(new NoiDungThi { noidung = new TracNghiemOnlineDB().Chuong_Hoc.Find(item.Kho_CauHoi.Ma_Chuong), SoCau = 0 }); } } danhGia.DanhGiaMucDo1 = noiDungs; }
public async Task <IActionResult> CustomerDanhGia(string iddonhang, int radio_check) { string sessionval = HttpContext.Session.GetString(SessionId); if (!string.IsNullOrEmpty(sessionval)) { var customer = await _accountRepository.All.FirstOrDefaultAsync(x => x.Id == sessionval); List <CartProduct> listchitietdonhang; listchitietdonhang = await _shoppingCart.All.Where(c => c.CartId == iddonhang) .Include(c => c.Cart) .Include(c => c.Product) .ToListAsync(); foreach (var item in listchitietdonhang) { item.DiemCustomerDanhGia = radio_check; _shoppingCart.UpdateAsync(item); } await _shoppingCart.SaveAsync(); DanhGia danhgia = new DanhGia { Id = Guid.NewGuid().ToString().ToUpper(), IdTaiKhoanDanhGia = customer.Id, Diem = radio_check }; await _danhGiaRepository.AddAsync(danhgia); await _danhGiaRepository.SaveAsync(); } return(RedirectToAction("ChiTietDonMua", new { id = iddonhang })); }
public IActionResult MerchantDanhGia(string iddonhang, int radio_check) { List <ChiTietDonHang> listchitietdonhang = new List <ChiTietDonHang>(); listchitietdonhang = ctx.ChiTietDonHang.Where(c => c.IdDonHang == Guid.Parse(iddonhang) && c.IdSizeSanPhamNavigation.IdSanPhamNavigation.IdTaiKhoanNavigation.TenDangNhap == HttpContext.Session.GetString("TenDangNhap")) .Include(c => c.IdSizeSanPhamNavigation) .Include(c => c.IdSizeSanPhamNavigation.IdSanPhamNavigation) .Include(c => c.IdSizeSanPhamNavigation.IdSanPhamNavigation.IdTaiKhoanNavigation) .ToList(); foreach (var item in listchitietdonhang) { item.DiemMerchantDanhGia = radio_check; } ctx.SaveChanges(); //Đánh giá TaiKhoanBUS taikhoanbus = new TaiKhoanBUS(); TaiKhoan taikhoan = taikhoanbus.CheckTaiKhoan(HttpContext.Session.GetString("TenDangNhap")); DonHang donhang = ctx.DonHang.Where(dh => dh.Id == Guid.Parse(iddonhang)).SingleOrDefault(); DanhGia danhgia = new DanhGia(); danhgia.Id = Guid.Parse(Guid.NewGuid().ToString().ToUpper()); danhgia.IdTaiKhoanDanhGia = taikhoan.Id; danhgia.IdTaiKhoanDuocDanhGia = donhang.IdTaiKhoan; danhgia.Diem = radio_check; ctx.DanhGia.Add(danhgia); ctx.SaveChanges(); //Return return(RedirectToAction("DaGiao")); }
public ActionResult DanhGia2([Bind(Include = "MaDanhGia,DanhGia1,MaNguoiDung,MaSanPham,NgayDanhGia")] DanhGia danhGia) { danhGia.MaSanPham = Int32.Parse(Session["MaSanPhamChiTiet"].ToString()); danhGia.NgayDanhGia = DateTime.Now; dt.DanhGias.Add(danhGia); dt.SaveChanges(); return(Redirect(Request.UrlReferrer.ToString())); }
public ActionResult DeleteConfirmed(int id) { DanhGia danhGia = db.DanhGias.Find(id); db.DanhGias.Remove(danhGia); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "IDKhachHang,TenKhachHang,NhanXet")] DanhGia danhGia) { if (ModelState.IsValid) { db.Entry(danhGia).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(danhGia)); }
public ActionResult Edit([Bind(Include = "Sosao,Danhgiachatluong,PhanHoiKhachHang")] DanhGia danhGia) { if (ModelState.IsValid) { db.Entry(danhGia).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(danhGia)); }
public JsonResult DanhGia(int MaDG) { DanhGia danhGia = db.DanhGias.SingleOrDefault(x => x.MaDG == MaDG); string tensp = danhGia.TenSP; string tenkhach = danhGia.KhachHang.TenKhach; string ngay = string.Format("{0:dd/MM/yyyy}", danhGia.NgayDG); string noidung = danhGia.NoiDung; int star = (int)danhGia.DanhGiaStar; return(Json(new { Success = true, TenSP = tensp, TenKhach = tenkhach, NgayDG = ngay, NoiDung = noidung, Star = star }, JsonRequestBehavior.AllowGet)); }
public void CustomerDanhGiaTable(string iddanhgia, string idduocdanhgia, int radio_check) { DanhGia danhgia = new DanhGia(); danhgia.Id = Guid.Parse(Guid.NewGuid().ToString().ToUpper()); danhgia.IdTaiKhoanDanhGia = Guid.Parse(iddanhgia); danhgia.IdTaiKhoanDuocDanhGia = Guid.Parse(idduocdanhgia); danhgia.Diem = radio_check; context.DanhGia.Add(danhgia); context.SaveChanges(); }
public ActionResult Create([Bind(Include = "Sosao,Danhgiachatluong,PhanHoiKhachHang")] DanhGia danhGia) { if (ModelState.IsValid) { db.DanhGias.Add(danhGia); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(danhGia)); }
public ActionResult Create([Bind(Include = "MaDanhGia,MoTaDanhGia,MaSanPham,IDKhachHang")] DanhGia danhGia) { if (ModelState.IsValid) { db.danhGias.Add(danhGia); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(danhGia)); }
public ActionResult Create([Bind(Include = "IDKhachHang,TenKhachHang,NhanXet")] DanhGia danhGia) { if (ModelState.IsValid) { db.DanhGias.Add(danhGia); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(danhGia)); }
// GET api/danhgia public IEnumerable <DanhGia> Get() { if (Test() == false) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); } DanhGiaDAO dgO = new DanhGiaDAO(); DanhGia[] dg = new DanhGia[dgO.getDsDanhGia().Count]; dg = dgO.getDsDanhGia().ToArray(); return(dg); }
public void TaoDanhGia(int idKH, int idMH, string mota) { DanhGia dg = new DanhGia(); dg.BinhLuan = mota; dg.Flag = true; dg.Ngay = DateTime.Now; dg.KHId = idKH; dg.KinhId = idMH; db.DanhGias.Add(dg); db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "MaDanhGia,DanhGia1,MaNguoiDung,MaSanPham,NgayDanhGia")] DanhGia danhGia) { if (ModelState.IsValid) { db.Entry(danhGia).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaNguoiDung = new SelectList(db.tbNguoiDungs, "MaNguoiDung", "TaiKhoanNguoiDung", danhGia.MaNguoiDung); ViewBag.MaSanPham = new SelectList(db.tbSanPhams, "MaSanPham", "TenSanPham", danhGia.MaSanPham); return(View(danhGia)); }
public ActionResult ChiTietDG(int id) { DanhGia dg = data.DanhGias.SingleOrDefault(n => n.MaDanhGia == id); ViewBag.MaDanhGia = dg.MaDanhGia; if (dg == null) { Response.StatusCode = 404; return(null); } return(View(dg)); }
//Lay bài thi cua 1 phong internal object ListALLexam(string id) { List <DanhGia> ketQuas = new List <DanhGia>(); var phong = db.Phong_Thi.Where(x => x.MaPhong.Equals(id.Trim())).ToList().First(); foreach (var item in phong.DS_SVThi) { var DeThi = db.De_Thi.Where(x => x.MaDeThi == item.MaDeThi).ToList().First(); if (DeThi != null) { if (DeThi.KetQuaThis.Count == 0) { TracNghiemOnlineDB tb1 = new TracNghiemOnlineDB(); DanhGia danhGia = new DanhGia(); danhGia = Mark(DeThi); ketQuas.Add(danhGia); KetQuaThi ketQuaThi = new KetQuaThi(); ketQuaThi.Ma_DeThi = DeThi.MaDeThi; ketQuaThi.NgayThi = DateTime.Now; ketQuaThi.SoCauDung = danhGia.ketQuaThi.SoCauDung; ketQuaThi.SoCauSai = danhGia.ketQuaThi.SoCauSai; ketQuaThi.DiemSo = danhGia.ketQuaThi.DiemSo; tb1.KetQuaThis.Add(ketQuaThi); tb1.SaveChanges(); foreach (var item1 in danhGia.ketQuaThi.De_Thi.Danh_Gia) { Danh_Gia danh_Gia = new Danh_Gia(); danh_Gia.MaChuong = item1.MaChuong; danh_Gia.MaDeThi = item1.MaDeThi; danh_Gia.SoCauDung = item1.SoCauDung; danh_Gia.TongCau = item1.TongCau; // danh_Gia.NhanXet = item1.NhanXet; danh_Gia.DanhGia = item1.DanhGia; tb1.Danh_Gia.Add(danh_Gia); tb1.SaveChanges(); } } else { DanhGia danhGia = new DanhGia(); danhGia.ketQuaThi = DeThi.KetQuaThis.ToList().First(); danhGia.ketQuaThi.De_Thi = DeThi; ketQuas.Add(danhGia); } } } return(ketQuas); }
// GET: DanhGias/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DanhGia danhGia = db.DanhGias.Find(id); if (danhGia == null) { return(HttpNotFound()); } return(View(danhGia)); }
public JsonResult Rating(int id, int score) { int result = RatingState.NotLogin; if (Request.IsAuthenticated) { DanhGia dg = new DanhGia(); dg.NguoiDung = User.Identity.Name; dg.MaSP = id; dg.Diem = score; result = service.Rating(dg) ? RatingState.Success : RatingState.Error; } return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult XacNhanXoaDanhGia(int id) { DanhGia dg = data.DanhGias.SingleOrDefault(n => n.MaDanhGia == id); ViewBag.MaDanhGia = dg.MaDanhGia; if (dg == null) { Response.StatusCode = 404; return(null); } data.DanhGias.DeleteOnSubmit(dg); data.SubmitChanges(); return(RedirectToAction("DanhGia")); }
// GET: api/[email protected]&id=1217 public DanhGia Get(int IdUser, int id) { if (Test() == false) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); } DanhGiaDAO dgO = new DanhGiaDAO(); DanhGia[] dg = new DanhGia[dgO.getDanhGia(IdUser, id).Count]; dg = dgO.getDanhGia(IdUser, id).ToArray(); //if (dg.Length == 0) // throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); return(dg[0]); }
public IActionResult AddRating(string product_id, string rating) { DanhGia newDg = new DanhGia() { MaTaiKhoan = int.Parse(HttpContext.Session.GetString("ACCID_SESSION")), LoiNhanXet = rating, MaThucDon = int.Parse(product_id), NgayDanhGia = DateTime.Now }; db.DanhGia.Add(newDg); db.SaveChanges(); return(RedirectToAction("Index", new RouteValueDictionary( new { controller = "SingleProduct", action = "Index", id = product_id }))); }
public ActionResult SeachDethi(long?id) { if (id == null) { return(View("Error")); } TaiKhoan tk = (TaiKhoan)Session["user"]; DanhGia danhGia = new DanhGia(); new TaoDeDao().TimKiem(danhGia, long.Parse(id.ToString())); Session["lambai"] = danhGia; Session["a"] = (int)0; return(RedirectToAction("KetQuathi")); }
// GET: DanhGia2s/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DanhGia danhGia = db.DanhGias.Find(id); if (danhGia == null) { return(HttpNotFound()); } ViewBag.MaNguoiDung = new SelectList(db.tbNguoiDungs, "MaNguoiDung", "TaiKhoanNguoiDung", danhGia.MaNguoiDung); ViewBag.MaSanPham = new SelectList(db.tbSanPhams, "MaSanPham", "TenSanPham", danhGia.MaSanPham); return(View(danhGia)); }
// DELETE: api/[email protected]&id=1217 public bool Delete(int IdUser, int id) { if (Test() == false) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); } DanhGiaDAO dgO = new DanhGiaDAO(); DanhGia[] dg = new DanhGia[dgO.getDanhGia(IdUser, id).Count]; dg = dgO.getDanhGia(IdUser, id).ToArray(); if (dg.Length == 0) { return(false); } dgO.deleteDanhGia(IdUser, id); return(true); }