public ActionResult Info()
{
HOC_VIEN student = (HOC_VIEN)Session["HocVien"];
StudentInfo info = new StudentInfo();
info.IdHocVien = student.IDHocVien;
info.HoTen = student.HoTen;
info.Email = student.Email;
List <KHOA_HOC> kh = new List <KHOA_HOC>();
foreach (DANG_KY dk in db.DANG_KY.Where(x => x.IDHocVien == student.IDHocVien).ToList())
{
KHOA_HOC k = db.KHOA_HOC.SingleOrDefault(x => x.IDKhoaHoc == dk.IDKhoaHoc);
kh.Add(k);
}
info.KhoaHocDangKy = kh;
var baitapdalam = db.BAI_LAM.Where(x => x.IDHocVien == student.IDHocVien).GroupBy(b => b.IDBaiTap).Select(c => c.Key);
List <BAI_TAP> bt = new List <BAI_TAP>();
foreach (int x in baitapdalam)
{
BAI_TAP b = db.BAI_TAP.SingleOrDefault(m => m.IDBaiTap == x);
bt.Add(b);
}
info.BaiTapDaLam = bt;
var kq = from m in db.BAI_LAM
where m.IDHocVien == student.IDHocVien
group m by new { m.IDHocVien, m.IDBaiTap } into NHOM
from n in NHOM
select n;
info.BaiLam = kq.ToList();
return(View(info));
}
public ActionResult Create(BAI_TAP model)
{
if (ModelState.IsValid)
{
db.BAI_TAP.Add(model);
db.SaveChanges();
return(RedirectToAction("ThemDeBai", new { ID = model.IDBaiTap }));
}
return(View());
}
public ActionResult Details(int id)
{
BAI_TAP b = db.BAI_TAP.Find(id);
if (b == null)
{
return(View("eror404"));
}
List <DE_BAI> list = de.DE_BAI.Where(x => x.IDBaiTap == b.IDBaiTap).ToList();
List <CAU_HOI> dscauhoi = new List <CAU_HOI>();
foreach (DE_BAI x in list)
{
dscauhoi.Add(db.CAU_HOI.Find(x.MaCauHoi));
}
ViewBag.idbaitap = b.IDBaiTap;
ViewBag.socauhoi = de.DE_BAI.GroupBy(x => x.IDBaiTap == b.IDBaiTap).Count();
return(View(dscauhoi));
}
