//đếm số lượng admin
public int CountAdmin()
{
db = new GDUDataConnectionsDataContext();
int countsAD = db.Admins.Count();
return(countsAD);
}
//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 DiemMonHoc AddDiemMonHoc(DiemMonHoc diemMonHoc)
{
db = new GDUDataConnectionsDataContext();
db.DiemMonHocs.InsertOnSubmit(diemMonHoc);
db.SubmitChanges();
return(diemMonHoc);
}
public KhoaHoc CreateKhoaHoc(KhoaHoc khoaHoc)
{
db = new GDUDataConnectionsDataContext();
db.KhoaHocs.InsertOnSubmit(khoaHoc);
db.SubmitChanges();
return(khoaHoc);
}
public Admin CreateAdmin(Admin ad)
{
db = new GDUDataConnectionsDataContext();
db.Admins.InsertOnSubmit(ad);
db.SubmitChanges();
return(ad);
}
//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 MonHoc CreateMonHoc(MonHoc monHoc)
{
db = new GDUDataConnectionsDataContext();
db.MonHocs.InsertOnSubmit(monHoc);
db.SubmitChanges();
return(monHoc);
}
public PhongHoc AddClassRoom(PhongHoc phongHoc)
{
db = new GDUDataConnectionsDataContext();
db.PhongHocs.InsertOnSubmit(phongHoc);
db.SubmitChanges();
return(phongHoc);
}
public Lop CreateLop(Lop lop)
{
db = new GDUDataConnectionsDataContext();
db.Lops.InsertOnSubmit(lop);
db.SubmitChanges();
return(lop);
}
public ThoiKhoaBieu CreateThoiKhoaBieu(ThoiKhoaBieu tkb)
{
db = new GDUDataConnectionsDataContext();
db.ThoiKhoaBieus.InsertOnSubmit(tkb);
db.SubmitChanges();
return(tkb);
}
public CheckAccount CheckAcc(CheckAccount chkAcc)
{
db = new GDUDataConnectionsDataContext();
db.CheckAccounts.InsertOnSubmit(chkAcc);
db.SubmitChanges();
return(chkAcc);
}
public List <KhoaHoc> GetAllKhoaHoc()
{
db = new GDUDataConnectionsDataContext();
var kh = from x in db.KhoaHocs select x;
listkhoaHoc = kh.ToList();
return(listkhoaHoc);;
}
//tìm kiếm account giảng viên
public List <GiangVien> SearchGiangVienByEmail(string email)
{
db = new GDUDataConnectionsDataContext();
var searchGV = from x in db.GiangViens.Where(p => p.Email.Contains(email)) select x;
listGV = new List <GiangVien>();
return(listGV);
}
//lấy danh sách giảng viên theo khoa
public List <GiangVien> GetGiangVienByMaKhoa(string maKhoa)
{
db = new GDUDataConnectionsDataContext();
var lgv = db.GiangViens.Where(p => p.MaKhoa == maKhoa).ToList();
listGV = lgv.ToList();
return(listGV);
}
//lấy danh sách admin
public List <Admin> GetAllAdmin()
{
db = new GDUDataConnectionsDataContext();
var ad = from x in db.Admins select x;
listAD = ad.ToList();
return(listAD);
}
public PhongHoc GetPhongHocByMaPhongHoc(string maPhongHoc)
{
db = new GDUDataConnectionsDataContext();
PhongHoc ph = new PhongHoc();
ph = db.PhongHocs.Single(p => p.MaPhongHoc == maPhongHoc);
return(ph);
}
//lấy thông tin Lớp
public Lop GetLopByMaLop(string maLop)
{
db = new GDUDataConnectionsDataContext();
Lop lp = new Lop();
lp = db.Lops.Single(p => p.MaLop == maLop);
return(lp);
}
public ThoiKhoaBieu GetThoiKhoaBieuByMaLopMaMonHoc(string maLop, string maMH)
{
db = new GDUDataConnectionsDataContext();
ThoiKhoaBieu InfoTKB = new ThoiKhoaBieu();
InfoTKB = db.ThoiKhoaBieus.Single(p => p.MaLop == maLop && p.MaMonHoc == maMH);
return(InfoTKB);
}
public List <Khoa> GetAllKhoa()
{
db = new GDUDataConnectionsDataContext();
var k = from x in db.Khoas select x;
khoas = k.ToList();
return(khoas);
}
//lấy thông tin contacts theo id
public InforContact InfoContact(string idContacts)
{
db = new GDUDataConnectionsDataContext();
InforContact infoContact = new InforContact();
infoContact = db.InforContacts.Single(p => p.ID == idContacts);
return(infoContact);
}
//lấy tất cả contacts
public List <InforContact> GetAllContact()
{
db = new GDUDataConnectionsDataContext();
var ltContact = from x in db.InforContacts select x;
listContact = ltContact.ToList();
return(listContact);
}
public List <MonHoc> GetAllMonHoc()
{
db = new GDUDataConnectionsDataContext();
var mh = from x in db.MonHocs select x;
listmonHoc = mh.ToList();
return(listmonHoc);
}
public List <Lop> getAllLop()
{
db = new GDUDataConnectionsDataContext();
var lop = db.Lops;
listLop = lop.ToList();
return(listLop);
}
//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();
}
//tìm kiếm lớp theo tên lớp
public List <Lop> SearchLopHocByTenLop(string maNganh, string tenLop)
{
db = new GDUDataConnectionsDataContext();
var lop = from x in db.Lops.Where(p => p.MaNganh == maNganh & p.TenLop.Contains(tenLop)) select x;
listLop = lop.ToList();
return(listLop);
}
//lấy tất cả danh sách giảng viên
public List <GiangVien> GetAllGiangVien()
{
db = new GDUDataConnectionsDataContext();
var gv = from x in db.GiangViens select x;
listGV = gv.ToList();
return(listGV);
}
public List <PhongHoc> GetAllPhongHoc()
{
db = new GDUDataConnectionsDataContext();
var ph = from x in db.PhongHocs select x;
listPhongHoc = ph.ToList();
return(listPhongHoc);
}
//lấy thông tin giảng viên theo mã gv
public GiangVien GetGiangVienByMaGV(string maGV)
{
db = new GDUDataConnectionsDataContext();
GiangVien gv = new GiangVien();
gv = db.GiangViens.Single(p => p.MaGV == maGV);
return(gv);
}
public List <PhongHoc> SearchPhongHoc(string ph)
{
db = new GDUDataConnectionsDataContext();
var sph = from x in db.PhongHocs.Where(p => p.MaPhongHoc.Contains(ph)) select x;
listPhongHoc = sph.ToList();
return(listPhongHoc);
}
//lấy thông tin admin theo email
public Admin GetAdminByMaAdmin(string idAdmin)
{
db = new GDUDataConnectionsDataContext();
Admin admin = new Admin();
admin = db.Admins.Single(p => p.MaAdmin == idAdmin);
return(admin);
}
