// GET: Admin/ThongKe public ActionResult Index() { var BaiThis = _baiThiRepo.GetAllBaiThi().Data; var DeThis = _deThiRepo.GetAllDeThi().Data; ViewBag.TongBaiThi = BaiThis.Count(); ViewBag.TongDeThi = DeThis.Count(); var DeThiDcLamNhieuNhat = from bt in BaiThis group bt by bt.MaDe into btGroup select new MaxDeThi { MaDe = btGroup.Key, SoLan = btGroup.Count(), }; ViewBag.MaxDeThi = DeThiDcLamNhieuNhat.OrderByDescending(m => m.SoLan).FirstOrDefault(); var NguoiLamBaiThiNhieuNhat = from bt in BaiThis group bt by bt.TaiKhoan into btGroup select new MaxDeThi { TenTK = btGroup.Key, SoLan = btGroup.Count(), }; ViewBag.MaxUserThiNhieuNhat = NguoiLamBaiThiNhieuNhat.OrderByDescending(m => m.SoLan).FirstOrDefault(); return(View()); }
public ActionResult ThongTinBaiThi(FormCollection MaMon) { string mon = MaMon["MaMon"]; if (!string.IsNullOrEmpty(mon)) { var DeThi = _deThiRepo.GetAllDeThi().Data.Where(m => m.MaMon == mon).ToList(); var tenMonThi = _monThiRepo.GetMonThiById(mon).Data.FirstOrDefault(); ViewBag.MonThi = tenMonThi.TenMon; return(View(DeThi)); } return(View()); }
// GET: Admin/DeThi public ActionResult Index() { var model = _deThiRepo.GetAllDeThi(); var tenMon = _monThiRepo.GetMonThiToDropDownList(); var result = (from dt in model.Data join m in tenMon on dt.MaMon equals m.MaMon select new DeThiModel { MaDe = dt.MaDe, TenMon = m.TenMon, TacGia = dt.TacGia, ThoiGianLamBai = dt.ThoiGianLamBai, TongCauHoi = dt.TongCauHoi, }).ToList(); return(View(result)); }