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