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