public static void themSinhVien(SinhVien sv)
{
var db = new SinhVienDbContext();
db.SinhVienDbset.Add(sv);
db.SaveChanges();
}
public static void xoaSinhVien(string maSinhVien)
{
var db = new SinhVienDbContext();
var sinhVien = db.SinhVienDbset.Where(e => e.MaSinhVien == maSinhVien).FirstOrDefault();
db.SinhVienDbset.Remove(sinhVien);
db.SaveChanges();
}
public static void xoaDiemHocTap(string maSinhVien)
{
var db = new SinhVienDbContext();
List <DiemHocTap> diemHocTap = db.DiemHocTapDbSet.Where(e => e.MaSinhVien == maSinhVien).ToList();
db.DiemHocTapDbSet.RemoveRange(diemHocTap);
db.SaveChanges();
}
public static void editDiemHocTap(string maSinhVien, double diem1, double diem2)
{
var db = new SinhVienDbContext();
var diemHocTap = db.DiemHocTapDbSet.Where(e => e.MaSinhVien == maSinhVien).ToList();
diemHocTap.ElementAt(0).Diem = diem1;
diemHocTap.ElementAt(1).Diem = diem2;
db.SaveChanges();
}
public static List <SinhVien> getListSinhVien()
{
List <SinhVien> list = new SinhVienDbContext().SinhVienDbset.Select(e => e).ToList();
for (int i = 0; i < list.Count; i++)
{
//SinhVien temp = list.ElementAt(i);
string msv = list.ElementAt(i).MaSinhVien;
list.ElementAt(i).ListDiemHocTap = DiemHocTap.getDiemHocTap(msv);
}
return(list);
}
public static void editSinhVien(string maSinhVien, string hoVaTen, bool gioiTinh, DateTime ngaySinh, double diem1, double diem2)
{
var db = new SinhVienDbContext();
var sinhVien = db.SinhVienDbset.Where(e => e.MaSinhVien == maSinhVien).FirstOrDefault();
sinhVien.HoVaTen = hoVaTen;
sinhVien.GioiTinh = gioiTinh;
sinhVien.NgaySinh = ngaySinh;
var diem = db.DiemHocTapDbset.Where(e => e.MaSinhVien == maSinhVien).ToList();
diem.ElementAt(0).Diem = diem1;
diem.ElementAt(1).Diem = diem2;
db.SaveChanges();
}
public static void themDiemHocTap(string maSinhVien, string maMonHoc1, string tenMonHoc1, double diem1, string maMonHoc2, string tenMonHoc2, double diem2)
{
var db = new SinhVienDbContext();
DiemHocTap diemHocTap1 = new DiemHocTap {
MaMonHoc = maMonHoc1, Diem = diem1, MaSinhVien = maSinhVien, TenMonHoc = tenMonHoc1
};
DiemHocTap diemHocTap2 = new DiemHocTap {
MaMonHoc = maMonHoc2, Diem = diem2, MaSinhVien = maSinhVien, TenMonHoc = tenMonHoc2
};
db.DiemHocTapDbSet.Add(diemHocTap1);
db.DiemHocTapDbSet.Add(diemHocTap2);
db.SaveChanges();
}
public static List <DiemHocTap> getDiemHocTap(string maSinhVien)
{
List <DiemHocTap> temp = new SinhVienDbContext().DiemHocTapDbSet.Where(e => e.MaSinhVien == maSinhVien).ToList();
return(temp);
}
public static List <Nganh> getNganh()
{
List <Nganh> list = new SinhVienDbContext().NganhDbSet.Select(e => e).ToList();
return(list);
}
