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