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