public Admin CreateAdmin(Admin ad)
{
db = new GDUDataConnectionsDataContext();
db.Admins.InsertOnSubmit(ad);
db.SubmitChanges();
return(ad);
}
public MonHoc CreateMonHoc(MonHoc monHoc)
{
db = new GDUDataConnectionsDataContext();
db.MonHocs.InsertOnSubmit(monHoc);
db.SubmitChanges();
return(monHoc);
}
public CheckAccount CheckAcc(CheckAccount chkAcc)
{
db = new GDUDataConnectionsDataContext();
db.CheckAccounts.InsertOnSubmit(chkAcc);
db.SubmitChanges();
return(chkAcc);
}
public DiemMonHoc AddDiemMonHoc(DiemMonHoc diemMonHoc)
{
db = new GDUDataConnectionsDataContext();
db.DiemMonHocs.InsertOnSubmit(diemMonHoc);
db.SubmitChanges();
return(diemMonHoc);
}
public ThoiKhoaBieu CreateThoiKhoaBieu(ThoiKhoaBieu tkb)
{
db = new GDUDataConnectionsDataContext();
db.ThoiKhoaBieus.InsertOnSubmit(tkb);
db.SubmitChanges();
return(tkb);
}
//tạo mới 1 giảng viên
public GiangVien CreateGiangVien(GiangVien giangVien)
{
db = new GDUDataConnectionsDataContext();
db.GiangViens.InsertOnSubmit(giangVien);
db.SubmitChanges();
return(giangVien);
}
public KhoaHoc CreateKhoaHoc(KhoaHoc khoaHoc)
{
db = new GDUDataConnectionsDataContext();
db.KhoaHocs.InsertOnSubmit(khoaHoc);
db.SubmitChanges();
return(khoaHoc);
}
public Lop CreateLop(Lop lop)
{
db = new GDUDataConnectionsDataContext();
db.Lops.InsertOnSubmit(lop);
db.SubmitChanges();
return(lop);
}
//thêm mới một sinh viên
public SinhVien CreateSinhVien(SinhVien sinhVien)
{
db = new GDUDataConnectionsDataContext();
db.SinhViens.InsertOnSubmit(sinhVien);
db.SubmitChanges();
return(null);
}
public PhongHoc AddClassRoom(PhongHoc phongHoc)
{
db = new GDUDataConnectionsDataContext();
db.PhongHocs.InsertOnSubmit(phongHoc);
db.SubmitChanges();
return(phongHoc);
}
//xóa môn học theo ngành
public void DeleteMonHocByNganh(string maNganh)
{
db = new GDUDataConnectionsDataContext();
var listMonHocDelete = from x in db.MonHocs.Where(p => p.MaNganh == maNganh) select x;
db.MonHocs.DeleteAllOnSubmit(listMonHocDelete.ToList());
db.SubmitChanges();
}
//xóa danh sách giảng viên theo khoa
public void DeleteListGiangVienByMaKhoa(string maKhoa)
{
db = new GDUDataConnectionsDataContext();
var listGVDelete = from x in db.GiangViens.Where(p => p.MaKhoa == maKhoa) select x;
db.GiangViens.DeleteAllOnSubmit(listGVDelete.ToList());
db.SubmitChanges();
}
//update trạng thái acc
public void UpdateStatusAccountByEmail(Admin admin)
{
db = new GDUDataConnectionsDataContext();
Admin ad = new Admin();
ad = db.Admins.Single(p => p.MaAdmin == admin.MaAdmin);
ad.StatusAcc = admin.StatusAcc;
db.SubmitChanges();
}
public void DeleteVerificationCode()
{
db = new GDUDataConnectionsDataContext();
var listDeleteCodes = from x in db.CheckAccounts select x;
listCodes = listDeleteCodes.ToList();
db.CheckAccounts.DeleteAllOnSubmit(listCodes);
db.SubmitChanges();
}
//xóa giảng viên
public void DeleteGiangVien(string maGV)
{
db = new GDUDataConnectionsDataContext();
GiangVien gv = new GiangVien();
gv = db.GiangViens.Single(p => p.MaGV == maGV);
db.GiangViens.DeleteOnSubmit(gv);
db.SubmitChanges();
}
public void DeleteThoiKhoaBieu(string maLop, string maMonHoc)
{
db = new GDUDataConnectionsDataContext();
ThoiKhoaBieu tkb = new ThoiKhoaBieu();
tkb = db.ThoiKhoaBieus.Single(p => p.MaLop == maLop && p.MaMonHoc == maMonHoc);
db.ThoiKhoaBieus.DeleteOnSubmit(tkb);
db.SubmitChanges();
}
public void DeleteKhoaHoc(string maKhoaHoc)
{
db = new GDUDataConnectionsDataContext();
KhoaHoc khoaHoc = new KhoaHoc();
khoaHoc = db.KhoaHocs.Single(x => x.MaKhoaHoc == maKhoaHoc);
db.KhoaHocs.DeleteOnSubmit(khoaHoc);
db.SubmitChanges();
}
public void UpdateKhoa(Khoa khoa)
{
db = new GDUDataConnectionsDataContext();
Khoa kh = new Khoa();
kh = db.Khoas.Single(x => x.MaKhoa == khoa.MaKhoa);
kh.TenKhoa = khoa.TenKhoa;
db.SubmitChanges();
}
public void DeleteAllDiemMonHocByMaSinhVien(string maSV)
{
db = new GDUDataConnectionsDataContext();
List <DiemMonHoc> dmh = db.DiemMonHocs.Where(p => p.MaSV.Equals(maSV)).ToList();
listDiemMonHocs = dmh.ToList();
db.DiemMonHocs.DeleteAllOnSubmit(listDiemMonHocs);
db.SubmitChanges();
}
//xóa ngành
public void DeleteNganhHoc(string maNganhHoc)
{
db = new GDUDataConnectionsDataContext();
NganhHoc nh = new NganhHoc();
nh = db.NganhHocs.Single(x => x.MaNganh == maNganhHoc);
db.NganhHocs.DeleteOnSubmit(nh);
db.SubmitChanges();
}
public void DeleteKhoa(string maKhoa)
{
db = new GDUDataConnectionsDataContext();
Khoa kh = new Khoa();
kh = db.Khoas.Single(x => x.MaKhoa == maKhoa);
db.Khoas.DeleteOnSubmit(kh);
db.SubmitChanges();
}
//xóa môn học
public void DeleteMonHoc(string maMonHoc)
{
db = new GDUDataConnectionsDataContext();
MonHoc monhoc = new MonHoc();
monhoc = db.MonHocs.Single(x => x.MaMonHoc == maMonHoc);
db.MonHocs.DeleteOnSubmit(monhoc);
db.SubmitChanges();
}
public void DeleteLop(string maLop)
{
db = new GDUDataConnectionsDataContext();
Lop lop = new Lop();
lop = db.Lops.Single(x => x.MaLop == maLop);
db.Lops.DeleteOnSubmit(lop);
db.SubmitChanges();
}
//xóa sinh viên
public void DeleteSinhVien(string maSV)
{
db = new GDUDataConnectionsDataContext();
SinhVien sv = new SinhVien();
sv = db.SinhViens.Single(p => p.MaSV == maSV);
db.SinhViens.DeleteOnSubmit(sv);
db.SubmitChanges();
}
//xóa tất cả sinh viên
public void DeleteAllSinhVienByMaLop(string maLop)
{
db = new GDUDataConnectionsDataContext();
List <SinhVien> sv = db.SinhViens.Where(p => p.MaLop.Equals(maLop)).ToList();
listSinhViens = sv.ToList();
db.SinhViens.DeleteAllOnSubmit(listSinhViens);
db.SubmitChanges();
}
// lấy ngành học theo KHOA
//public NganhHoc GetNganhHocByKHOA(string maKhoa)
//{
// db = new GDUDataConnectionsDataContext();
// NganhHoc nganhHoc = new NganhHoc();
// nganhHocs.ForEach(nganh =>
// {
// if( nganh.MaKhoa == maKhoa)
// {
// nganhHoc = nganh;
// }
// });
// return nganhHoc;
//}
//cập nhật ngành
public void UpdateNganhHoc(NganhHoc nganhHoc)
{
db = new GDUDataConnectionsDataContext();
NganhHoc nh = new NganhHoc();
nh = db.NganhHocs.Single(x => x.MaNganh == nganhHoc.MaNganh);
nh.TenNganh = nganhHoc.TenNganh;
db.SubmitChanges();
}
public void UpdateClassRoom(PhongHoc phongHoc)
{
db = new GDUDataConnectionsDataContext();
PhongHoc ph = new PhongHoc();
ph = db.PhongHocs.Single(p => p.MaPhongHoc == phongHoc.MaPhongHoc);
ph.GhiChu = phongHoc.GhiChu;
db.SubmitChanges();
}
public void DeleteClassRoom(string maPH)
{
db = new GDUDataConnectionsDataContext();
PhongHoc ph = new PhongHoc();
ph = db.PhongHocs.Single(x => x.MaPhongHoc == maPH);
db.PhongHocs.DeleteOnSubmit(ph);
db.SubmitChanges();
}
//xóa admin
public void DeleteAdmin(string maAD)
{
db = new GDUDataConnectionsDataContext();
Admin ad = new Admin();
ad = db.Admins.Single(p => p.MaAdmin == maAD);
db.Admins.DeleteOnSubmit(ad);
db.SubmitChanges();
}
//Xóa tất cả lớp trong ngành
public void DeleteAllLopInNganh(string maKhoasHoc, string maNganh)
{
db = new GDUDataConnectionsDataContext();
var listLop = from x in db.Lops.Where(p => p.MaKhoaHoc == maKhoasHoc & p.MaNganh == maNganh) select x;
List <Lop> listLopDeleteAll = new List <Lop>();
listLopDeleteAll = listLop.ToList();
db.Lops.DeleteAllOnSubmit(listLopDeleteAll);
db.SubmitChanges();
}
