private void TinhDiemTrungBinhHocKi(int sinhVienId, HocKi hocKi) { var danhSachDiem = _context.Diem.Where(d => d.SinhVienId == sinhVienId && d.HocKi == hocKi) .Select(d => new { d.DiemTb, d.MonHoc.SoHocPhan }); var diemTb = _context.DiemTrungBinhHocKi.SingleOrDefault(dtb => dtb.SinhVienId == sinhVienId && dtb.HocKi == hocKi); if (diemTb != null) { diemTb.TongDiem = 0; diemTb.DiemTb = 0; foreach (var diem in danhSachDiem) { diemTb.TongDiem += diem.DiemTb.GetValueOrDefault() * diem.SoHocPhan; diemTb.TongHocPhan += diem.SoHocPhan; } diemTb.DiemTb = (float)diemTb.TongDiem / diemTb.TongHocPhan; } _context.SaveChanges(); }
public IHttpActionResult LayDiemHocKiSinhVien(HocKi hocKi) { var sinhVienId = 0; var sinhVien = _context.SinhVien.Where(sv => sv.Id == sinhVienId).Select(sv => new { sv.Id, sv.MSSV, sv.Ten, sv.HoVaTenLot, Diem = sv.Diem.Where(diem => diem.HocKi == hocKi).Select(diem => new { diem.MonHoc.TenMonHoc, diem.MonHoc.SoHocPhan, diem.MonHoc.LoaiMon, diem.MonHoc.HaiDiemDk, diem.DiemChuyenCan, diem.DiemDieuKien1, diem.DiemDieuKien2, diem.DiemThi, diem.DiemTb, DanhSachDiemBoSung = diem.DanhSachDiemBoSung.Select(dbs => dbs.Diem) }) }).SingleOrDefault(); if (sinhVien == null) { return(NotFound()); } return(Ok(sinhVien)); }
private void button1_Click(object sender, EventArgs e) { if (namhoc.Text != "" && checkNH1.ErrorMessage == null && hkcombo.SelectedItem != null) { string mahk = hkcombo.SelectedItem.ToString() + namhoc.Text; int ma = int.Parse(mahk); int i = 0; foreach (var x in HocKi.HK) { if (x.MaHK1 == ma) { i = 1; MessageBox.Show("năm học này đã có học kì " + namhoc.Text); break; } } if (i == 0) { HocKi h = new HocKi(ma, hkcombo.Text); HSB.AddHK(h); MessageBox.Show("successfull"); MonHoc_Load(sender, e); } } else { MessageBox.Show("phải điền đúng và đầy đủ năm học và học kì"); } }
public Diem(int monHocId, int lopId, int sinhVienId, HocKi hocKi) { SinhVienId = sinhVienId; HocKi = hocKi; MonHocId = monHocId; LopId = lopId; }
public void GetKL() { HocSinhDBDataContext hdb = new HocSinhDBDataContext(); try { HocKi.HK.Clear(); var hocki = from hk in hdb.HOCKIs select hk; if (hocki != null) { foreach (var hki in hocki) { HocKi lst = new HocKi(hki.MaHocKi, hki.TenHocKi); HocKi.HK.Add(lst); } } CTMonHoc.ctmh.Clear(); var ct = from mh in hdb.MONHOCs select mh; if (ct != null) { foreach (var b in ct) { CTMonHoc lst = new CTMonHoc(b.MaMonHoc, b.TenMonHoc); CTMonHoc.ctmh.Add(lst); } } ClassDTO.khoilop.Clear(); clasDTO.lop.Clear(); var kk = from l in hdb.DANHSACHLOPs select l; var q = from kq in hdb.KHOILOPs select kq; if (q == null || kk == null) { clasDTO.TonTail = false; ClassDTO.TonTai = false; } else { ClassDTO.TonTai = true; clasDTO.TonTail = true; foreach (var x in q) { ClassDTO kl = new ClassDTO(x.MaKhoiLop, x.TenKhoiLop); ClassDTO.khoilop.Add(kl); } foreach (var n in kk) { clasDTO lop = new clasDTO(n.MaLop, n.TenLop, 0, n.MaKhoiLop); clasDTO.lop.Add(lop); } } } catch { } }
public ActionResult LayDiemLopHocKi(int lopId, HocKi hocKi) { var diemLopHocKi = new DiemLopHocKiDto() { LopId = lopId, HocKi = hocKi }; return(View(diemLopHocKi)); }
private void TinhDiemTrungBinhTheoMon(int sinhVienId, HocKi hocKi, byte diemTbMonHocCu, byte diemTbMonHocMoi, byte hocPhanMonHoc) { var diemTb = _context.DiemTrungBinhHocKi.SingleOrDefault(dtb => dtb.SinhVienId == sinhVienId && dtb.HocKi == hocKi); if (diemTb != null) { diemTb.TongDiem = diemTb.TongDiem - diemTbMonHocCu * hocPhanMonHoc + diemTbMonHocMoi * hocPhanMonHoc; diemTb.DiemTb = (float)diemTb.TongDiem / diemTb.TongHocPhan; } _context.SaveChanges(); }
public bool AddHK(HocKi hk) { HocSinhDBDataContext hdb = new HocSinhDBDataContext(); try { hdb.AddHK(hk.MaHK1, hk.TenHK1); return(true); } catch { return(false); } }
private void ThemDiemTieuChuan(int monHocId, int lopId, int sinhVienId, HocKi hocKi) { _context.Diem.Add(new Diem(monHocId, lopId, sinhVienId, hocKi)); //Thêm điểm tiêu chuẩn }
private void ThemDiem(int monHocId, LoaiMon loaiMon, int lopId, int sinhVienId, HocKi hocKi) { ThemDiemTieuChuan(monHocId, lopId, sinhVienId, hocKi); if (loaiMon == LoaiMon.MonCPDT_TT) //Nếu là môn CPĐT-Thông tin { ThemDiemBs_CPDT(monHocId, sinhVienId); } else if (loaiMon == LoaiMon.MonTiengAnh) //Nếu là môn Tiếng Anh { ThemDiemBs_TA(monHocId, sinhVienId); } }
public bool AddHK(HocKi hk) { return(HS.AddHK(hk)); }