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