public IHttpActionResult LayDiemLopMonHoc(LopMonHocDto lopMonHocDto)
{
var sinhVienVaDiem = _context.DanhSachSinhVienLop.Where(svl => svl.LopId == lopMonHocDto.LopId)
.Select(svl => new
{
Id = svl.SinhVienId,
svl.SinhVien.MSSV,
svl.SinhVien.HoVaTenLot,
svl.SinhVien.Ten,
Diem = svl.SinhVien.Diem.Where(diem => diem.MonHocId == lopMonHocDto.MonHocId)
.Select(diem => new
{
diem.DiemChuyenCan,
diem.DiemDieuKien1,
diem.DiemDieuKien2,
diem.DiemThi,
diem.DiemTb,
DanhSachDiemBoSung = diem.DanhSachDiemBoSung
.Select(dbs => new
{
dbs.Id,
dbs.Diem
})
}).FirstOrDefault()
});
return(Ok(sinhVienVaDiem));
}
public ActionResult QuanLyLopMonHoc(int monHoc, int lop)
{
var lopMonHoc = new LopMonHocDto()
{
LopId = lop, MonHocId = monHoc
};
return(View(lopMonHoc));
}
public IHttpActionResult LayDanhSachLichHoc(LopMonHocDto lopMonHocDto) //Lấy danh sách lịch học của lớp môn học
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var lichHoc = _context.LichHoc
.Where(lh => lh.MonHocId == lopMonHocDto.MonHocId && lh.LopId == lopMonHocDto.LopId)
.ToList();
return(Ok(lichHoc.Select(Mapper.Map <LichHoc, LichHocDto>)));
}
public IHttpActionResult XoaDangKiMonHoc(LopMonHocDto lopMonHocDto)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var lopMonHoc = _context.LopMonHoc.Include(lmh => lmh.DanhSachDiem).SingleOrDefault(lmh =>
lmh.LopId == lopMonHocDto.LopId && lmh.MonHocId == lopMonHocDto.MonHocId);
if (lopMonHoc == null)
{
return(NotFound());
}
lopMonHoc.XoaDiem();
_context.LopMonHoc.Remove(lopMonHoc);
_context.SaveChanges();
return(Ok());
}
public IHttpActionResult LayThongTinTrangQuanLyLopMonHoc(LopMonHocDto lopMonHocDto)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var lopMonHoc = _context.LopMonHoc.Where(lmh =>
lmh.LopId == lopMonHocDto.LopId && lmh.MonHocId == lopMonHocDto.MonHocId)
.Select(lmh => new
{
lmh.LopId,
lmh.MonHocId,
lmh.Lop.TenLop,
lmh.NgayThi,
lmh.HocKi,
lmh.DiaDiemThi,
monHoc = new
{
lmh.MonHoc.TenMonHoc,
lmh.MonHoc.HaiDiemDk,
lmh.MonHoc.LoaiMon,
lmh.MonHoc.SoTiet,
lmh.MonHoc.SoHocPhan
},
LichHoc = lmh.DanhSachLichHoc.Select(lh => new
{
lh.Id,
lh.BuoiSang,
lh.BaTietDau,
lh.Thu246,
lh.NgayBatDau,
lh.NgayKetThuc,
lh.GiaoVienDay,
lh.PhongHoc
}).ToList()
}).SingleOrDefault();
if (lopMonHoc == null)
{
return(NotFound());
}
return(Ok(lopMonHoc));
}
