// GET: LopTinChis/Create public ActionResult ThemSinhVienVaoLop(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LopTinChi lopTinChi = db.LopTinChis.Find(id); if (lopTinChi == null) { return(HttpNotFound()); } var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID; KichHoatLopTinChi ltc = new KichHoatLopTinChi(); ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat); ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID); ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID); ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID); ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID); var data = db.SinhViens.Where(x => x.KhoaID == khoaID && x.TinhTrang == 1).ToList(); ViewData["dataSinhVien"] = data; return(View(lopTinChi)); }
// GET: LopTinChis/Create public ActionResult Create() { KichHoatLopTinChi ltc = new KichHoatLopTinChi(); ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text"); ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen"); ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa"); ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc"); ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh"); return(View()); }
// GET: LopTinChis/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LopTinChi lopTinChi = db.LopTinChis.Find(id); if (lopTinChi == null) { return(HttpNotFound()); } var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID; KichHoatLopTinChi ltc = new KichHoatLopTinChi(); ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat); ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID); ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID); ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID); ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID); var data = db.BangDiems .Join(db.SinhViens, o1 => o1.SinhVienID, o2 => o2.SinhVienID, (o1, o2) => new DanhSachLopViewModels() { BangDiemID = o1.BangDiemID, LopTinChiID = o1.LopTinChiID , SinhVienID = o1.SinhVienID , MaSinhVien = o2.MaSinhVien , HoTen = o2.HoTen , NgaySinh = o2.NgaySinh , DiemThanhPhan = o1.DiemThanhPhan , DiemThi = o1.DiemThi , DiemTrungBinh = (o1.DiemThanhPhan * 0.3) + (o1.DiemThi * 0.7) //so1.DiemTrungBinh , DiemChu = o1.DiemChu }) .Where(X => X.LopTinChiID == lopTinChi.LopTinChiID).ToList(); ViewData["dataSinhVien"] = data; return(View(lopTinChi)); }
public ActionResult Edit([Bind(Include = "LopTinChiID,MaLopTinChi,TenLopTinChi,SoLuongToiDa,NgayBatDau,NgayKetThuc,GiangVienID,MonHocID,NganhDaoTaoID,KichHoat")] LopTinChi lopTinChi) { if (ModelState.IsValid) { db.Entry(lopTinChi).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID; KichHoatLopTinChi ltc = new KichHoatLopTinChi(); ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat); ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID); ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID); ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID); ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID); return(View(lopTinChi)); }
// GET: LopTinChis/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LopTinChi lopTinChi = db.LopTinChis.Find(id); if (lopTinChi == null) { return(HttpNotFound()); } var khoaID = db.NganhDaoTaos.FirstOrDefault(x => x.NganhDaoTaoID == lopTinChi.NganhDaoTaoID).KhoaID; KichHoatLopTinChi ltc = new KichHoatLopTinChi(); ViewBag.KichHoat = new SelectList(ltc.GetListLopTinChi(), "Value", "Text", lopTinChi.KichHoat); ViewBag.GiangVienID = new SelectList(db.GiangViens, "GiangVienID", "HoTen", lopTinChi.GiangVienID); ViewBag.KhoaID = new SelectList(db.Khoas, "KhoaID", "TenKhoa", khoaID); ViewBag.MonHocID = new SelectList(db.MonHocs, "MonHocID", "TenMonHoc", lopTinChi.MonHocID); ViewBag.NganhDaoTaoID = new SelectList(db.NganhDaoTaos, "NganhDaoTaoID", "TenNganh", lopTinChi.NganhDaoTaoID); return(View(lopTinChi)); }