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