public ActionResult LayDiemLopHocKi(int lopId, HocKi hocKi)
{
var diemLopHocKi = new DiemLopHocKiDto()
{
LopId = lopId, HocKi = hocKi
};
return(View(diemLopHocKi));
}
public IHttpActionResult LayDiemHocKiLop(DiemLopHocKiDto diemLopHocKiDto)
{
var lop = _context.Lop.Where(l => l.Id == diemLopHocKiDto.LopId)
.Select(l => new
{
MonHoc = l.DanhSachMonHoc.Where(lmh => lmh.HocKi == diemLopHocKiDto.HocKi)
.OrderBy(lmh => lmh.MonHocId)
.Select(lmh => new
{
lmh.MonHoc.KyHieuMonHoc,
lmh.MonHoc.SoHocPhan,
lmh.MonHoc.HaiDiemDk,
lmh.MonHoc.TenMonHoc
})
}).SingleOrDefault();
var sinhVienVaDiem = _context.DanhSachSinhVienLop.Where(svl => svl.LopId == diemLopHocKiDto.LopId)
.Select(svl => new
{
svl.SinhVien.MSSV,
svl.SinhVien.HoVaTenLot,
svl.SinhVien.Ten,
Diem = svl.SinhVien.Diem.Where(diem => diem.HocKi == diemLopHocKiDto.HocKi)
.OrderBy(diem => diem.MonHocId).Select(diem => new
{
diem.DiemChuyenCan,
diem.DiemDieuKien1,
diem.DiemDieuKien2,
diem.DiemThi,
diem.DiemTb,
diem.DanhSachDiemBoSung
}).ToList()
});
return(Ok(new
{
lop,
sinhVienVaDiem
}));
}
