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