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