public static bool CapNhatSinhVien(SinhVien sinhvien) { try { using (var _context = new DBQuanLyDeAnEntities()) { var sv = (from s in _context.SinhViens where s.IDSinhVien == sinhvien.IDSinhVien select s) .Include("Nhom") .Include("TienDoes") .SingleOrDefault(); sv.HoTen = sinhvien.HoTen; sv.MSSV = sinhvien.MSSV; sv.NgaySinh = sinhvien.NgaySinh; sv.Email = sinhvien.Email; sv.SDT = sinhvien.SDT; sv.GioiTinh = sinhvien.GioiTinh; sv.IDNhom = sinhvien.IDNhom; sv.status = sinhvien.status; _context.SaveChanges(); return(true); } } catch { return(false); } }
public static List <SinhVien> GetSinhVienThuocNhom(int IDNhom) { using (var _context = new DBQuanLyDeAnEntities()) { var nhom = (from n in _context.Nhoms where n.IDNhom == IDNhom && n.status == 1 select n) .SingleOrDefault(); if (nhom == null) { return(null); } var sinhvien = (from s in _context.SinhViens where s.IDNhom == IDNhom && s.status == 1 select s) .Include("Nhom") .Include("TienDoes") .ToList(); if (sinhvien != null) { return(sinhvien); } else { return(null); } } }
public static bool CapNhatTienDo(TienDo tiendo) { try { using (var _context = new DBQuanLyDeAnEntities()) { var td = (from t in _context.TienDoes where t.IDTienDo == tiendo.IDTienDo select t) .SingleOrDefault(); td.NoiDung = tiendo.NoiDung; td.TaiLieuBaoCao = tiendo.TaiLieuBaoCao; td.ThoiGianBaoCao = tiendo.ThoiGianBaoCao; td.HoanThanh = tiendo.HoanThanh; td.NhanXet = tiendo.NhanXet; td.IDSinhVien = tiendo.IDSinhVien; td.status = tiendo.status; _context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool CapNhatDeAn(DeAn dean) { try { using (var _context = new DBQuanLyDeAnEntities()) { var da = (from s in _context.DeAns where s.IDDeAn == dean.IDDeAn select s) .Include("TienDoes") .SingleOrDefault(); da.IDDeAn = dean.IDDeAn; da.TenDeAn = dean.TenDeAn; da.NoiDung = dean.NoiDung; da.IDNhom = dean.IDNhom; da.IDGiaoVien = dean.IDGiaoVien; da.LoaiDeAn = dean.LoaiDeAn; da.status = dean.status; _context.SaveChanges(); return(true); } } catch { return(false); } }
public static List <GiaoVien> GetListGiaoVien() { using (var _context = new DBQuanLyDeAnEntities()) { var gv = (from n in _context.GiaoViens.AsEnumerable() where n.status == 1 && n.status == 1 select n) .Select(x => new GiaoVien { IDGiaoVien = x.IDGiaoVien, BoMon = x.BoMon, SDT = x.SDT, GioiTinh = x.GioiTinh, NgaySinh = x.NgaySinh, Email = x.Email, HoTen = x.HoTen, ad = x.ad, pass = x.pass, username = x.username, status = x.status }).ToList(); return(gv); } }
public static bool UpdateGV(GiaoVien GV) { try { using (var _context = new DBQuanLyDeAnEntities()) { var userdb = _context.GiaoViens.Single(u => u.IDGiaoVien == GV.IDGiaoVien); userdb.IDGiaoVien = GV.IDGiaoVien; userdb.NgaySinh = GV.NgaySinh; userdb.BoMon = GV.BoMon; userdb.GioiTinh = GV.GioiTinh; userdb.SDT = GV.SDT; userdb.Email = GV.Email; userdb.HoTen = GV.HoTen; userdb.username = GV.username; userdb.pass = GV.pass; userdb.status = GV.status; _context.SaveChanges(); return(true); } } catch { return(false); } }
public static List <TienDo> GetListTienDo(int IDNhom) { using (var _context = new DBQuanLyDeAnEntities()) { var tiendo = (from n in _context.TienDoes where n.IDNhom == IDNhom && n.status == 1 select n) .ToList(); return(tiendo); } }
public static List <DeAn> GetListDeAn() { using (var _context = new DBQuanLyDeAnEntities()) { var dean = (from n in _context.DeAns where n.status == 1 select n) .Include("TienDoes") .ToList(); return(dean); } }
public static List <DeAn> GetDeAnGV(int IDGiaoVien) { using (var _context = new DBQuanLyDeAnEntities()) { var da = (from u in _context.DeAns where u.IDGiaoVien == IDGiaoVien && u.status == 1 select u) .Include("TienDoes") .ToList(); return(da); } }
public static List <SinhVien> GetListSinhVien() { using (var _context = new DBQuanLyDeAnEntities()) { var sv = (from n in _context.SinhViens where n.status == 1 select n) .Include("Nhom") .Include("TienDoes") .ToList(); return(sv); } }
public static List <Nhom> GetListNhom() { using (var _context = new DBQuanLyDeAnEntities()) { var nhom = (from n in _context.Nhoms where n.status == 1 select n) .Include("DeAns") .Include("SinhViens") .Include("TienDoes") .ToList(); return(nhom); } }
public static bool ThemSinhVien(SinhVien sinhvien) { try { using (var _context = new DBQuanLyDeAnEntities()) { _context.SinhViens.Add(sinhvien); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool ThemNhom(Nhom nhom) { try { using (var _context = new DBQuanLyDeAnEntities()) { _context.Nhoms.Add(nhom); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool ThemTienDo(TienDo td) { try { using (var _context = new DBQuanLyDeAnEntities()) { _context.TienDoes.Add(td); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool ThemDeAn(DeAn dean) { try { using (var _context = new DBQuanLyDeAnEntities()) { _context.DeAns.Add(dean); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool ThemGV(GiaoVien giaovien) { try { using (var _context = new DBQuanLyDeAnEntities()) { _context.GiaoViens.Add(giaovien); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static void initializeDB() { using (var _context = new DBQuanLyDeAnEntities()) { var sinhvien = new SinhVien { HoTen = "Nguyễn Văn A", MSSV = "18133066", SDT = "0386232296", Email = "*****@*****.**", NgaySinh = DateTime.Parse("2020-06-30"), GioiTinh = "Nam" }; _context.SinhViens.Add(sinhvien); _context.SaveChanges(); } MessageBox.Show("Finish!"); }
public static bool deleteGV(int row) { try { using (var _context = new DBQuanLyDeAnEntities()) { var gv = (from u in _context.GiaoViens where u.IDGiaoVien == row select u).Single(); _context.GiaoViens.Remove(gv); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static GiaoVien GetGV(int ID) { using (var _context = new DBQuanLyDeAnEntities()) { var task = (from u in _context.GiaoViens where u.IDGiaoVien == ID && u.status == 1 select u) .ToList(); if (task.Count == 1) { return(task[0]); } else { return(null); } } }
public static Nhom GetNhom(int IDNhom) { using (var _context = new DBQuanLyDeAnEntities()) { var nhom = (from n in _context.Nhoms where n.IDNhom == IDNhom && n.status == 1 select n) .SingleOrDefault(); if (nhom != null) { return(nhom); } else { return(null); } } }
public static bool XoaTienDo(int IDTienDo) { try { using (var _context = new DBQuanLyDeAnEntities()) { var tiendo = (from n in _context.TienDoes where n.IDTienDo == IDTienDo select n) .SingleOrDefault(); _context.TienDoes.Remove(tiendo); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static GiaoVien DangNhap(GiaoVien giaovien) { using (var _context = new DBQuanLyDeAnEntities()) { var task = (from u in _context.GiaoViens where u.username == giaovien.username && u.pass == giaovien.pass && u.status == 1 select u) .ToList(); if (task.Count == 1) { return(task[0]); } else { return(null); } } }
public static TienDo GetTienDo(int IDTienDo) { using (var _context = new DBQuanLyDeAnEntities()) { var tiendo = (from td in _context.TienDoes where td.IDTienDo == IDTienDo && td.status == 1 select td) .SingleOrDefault(); if (tiendo != null) { return(tiendo); } else { return(null); } } }
public static DeAn GetDeAn(int IDDeAn) { using (var _context = new DBQuanLyDeAnEntities()) { var da = (from u in _context.DeAns where u.IDDeAn == IDDeAn && u.status == 1 select u) .Include("TienDoes") .ToList(); if (da.Count == 1) { return(da[0]); } else { return(null); } } }
public static bool XoaDeAn(int IDDeAn) { try { using (var _context = new DBQuanLyDeAnEntities()) { var da = (from d in _context.DeAns where d.IDDeAn == IDDeAn select d) //.Include("Nhom").Include("TienDoes").Include("GiaoViens") .SingleOrDefault(); _context.DeAns.Remove(da); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool XoaSinhVien(int IDSinhVien) { try { using (var _context = new DBQuanLyDeAnEntities()) { var sinhvien = (from s in _context.SinhViens where s.IDSinhVien == IDSinhVien select s) //.Include("Nhom").Include("TienDoes") .SingleOrDefault(); _context.SinhViens.Remove(sinhvien); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static SinhVien GetSinhVien(int IDSinhVien) { using (var _context = new DBQuanLyDeAnEntities()) { var sinhvien = (from s in _context.SinhViens where s.IDSinhVien == IDSinhVien && s.status == 1 select s) .Include("Nhom") .Include("TienDoes") .SingleOrDefault(); if (sinhvien != null) { return(sinhvien); } else { return(null); } } }
public static bool XoaNhom(int IDNhom) { try { using (var _context = new DBQuanLyDeAnEntities()) { var dbNhom = (from n in _context.Nhoms where n.IDNhom == IDNhom select n) .Include("DeAns") .Include("SinhViens") .SingleOrDefault(); _context.Nhoms.Remove(dbNhom); _context.SaveChanges(); return(true); } } catch { return(false); } }
public static bool CapNhatNhom(Nhom nhom) { try { using (var _context = new DBQuanLyDeAnEntities()) { var dbNhom = (from n in _context.Nhoms where n.IDNhom == nhom.IDNhom select n) .Include("DeAns") .Include("SinhViens") .SingleOrDefault(); dbNhom.TenNhom = nhom.TenNhom; dbNhom.status = nhom.status; _context.SaveChanges(); return(true); } } catch { return(false); } }