public PartialViewResult TopPhanHoi() { var list = (from ph in db.PhanHois join kh in db.KhachHangs on ph.MaKhachHang equals kh.Id select new { Id = ph.Id, MaKhachHang = ph.MaKhachHang, NoiDung = ph.NoiDung, TenKhachHang = kh.TenDangNhap, DaXem = ph.DaXem }).OrderByDescending(x => x.Id).Take(5).ToList(); //var list = db.PhanHois.OrderByDescending(x => x.Id).Take(5).ToList(); var model = new List <PhanHoiModel>(); var i = 0; foreach (var item in list) { i++; var itemmodel = new PhanHoiModel(); itemmodel.STT = i; itemmodel.Id = item.Id; itemmodel.UserId = item.MaKhachHang; itemmodel.Content = item.NoiDung; itemmodel.UserName = item.TenKhachHang; itemmodel.DaXem = item.DaXem; model.Add(itemmodel); } return(PartialView(model)); }
public PartialViewResult PhanHoiChuaDoc() { var list = db.PhanHois.Where(x => x.DaXem == 0).ToList(); var model = new List <PhanHoiModel>(); DateTime now = DateTime.Now; foreach (var item in list) { var itemmodel = new PhanHoiModel(); var khachhang = db.KhachHangs.FirstOrDefault(x => x.Id == item.MaKhachHang); itemmodel.UserName = khachhang.TenDangNhap; itemmodel.PhanHoiTu = new LamTronThoiGian().LamTron(now, item.ThoiGian); model.Add(itemmodel); } return(PartialView(model)); }
public JsonResult List(int?page) { int pageSize = 10; var list = db.PhanHois.OrderByDescending(x => x.Id).ToList(); var data = new List <PhanHoiModel>(); int i = 0; foreach (var item in list) { i++; var itemmodel = new PhanHoiModel(); itemmodel.STT = i; itemmodel.Id = item.Id; var khachhang = new KhachHangDao(); itemmodel.UserName = khachhang.viewDetail(item.MaKhachHang).TenDangNhap; itemmodel.Content = item.NoiDung; DateTime now = DateTime.Now; var convert = new DoAn.Common.Function.LamTronThoiGian(); itemmodel.PhanHoiTu = convert.LamTron(now, item.ThoiGian); itemmodel.DaXem = item.DaXem; data.Add(itemmodel); } if (page > 0) { page = page; } else { page = 1; } int start = (int)(page - 1) * pageSize; ViewBag.pageCurrent = page; int totalPage = data.Count(); float totalNumsize = (totalPage / (float)pageSize); int numSize = (int)Math.Ceiling(totalNumsize); ViewBag.numSize = numSize; var datamodel = data.Skip(start).Take(pageSize); return(Json(new { data = datamodel, pageCurrent = page, numSize = numSize }, JsonRequestBehavior.AllowGet)); }
public ActionResult PhanHoi(PhanHoiModel model) { if (ModelState.IsValid) { var dao = new PhanHoiF(); var ph = new PhanHoi(); ph.TenNguoiPhanHoi = model.TenNguoiDung; ph.NoiDung = model.NoiDung; ph.NgayPhanHoi = DateTime.Now; var result = dao.InsertPH(ph); if (result > 0) { ViewBag.Success = "Gửi phản hồi thành công"; model = new PhanHoiModel(); } else { ModelState.AddModelError("", "Gửi phản hồi không thành công"); } } return(View(model)); }