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