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