public static List <SinhVien> danhsachSV(string svSearch)
{
using (var _context = new DoanLTWEntities())
{
var sinhvien = (from sv in _context.SinhViens.AsEnumerable()
where sv.MaSV.Contains(svSearch)
select sv)
.Select(x => new SinhVien
{
MaSV = x.MaSV,
HoTen = x.HoTen,
GioiTinh = x.GioiTinh,
SDT = x.SDT,
Email = x.Email,
Khoa = x.Khoa,
LopHoc = x.LopHoc,
NgaySinh = x.NgaySinh,
DiaChi = x.DiaChi,
MaDT = x.MaDT,
DeTai = x.DeTai,
MatKhau = x.MatKhau
}).ToList();
return(sinhvien);
}
}
public static SinhVien getExistSV(string masv)
{
using (var _context = new DoanLTWEntities())
{
return(_context.SinhViens.Find(masv));
}
}
public static bool ThemSV(SinhVien sinhvien)
{
using (var _context = new DoanLTWEntities())
{
_context.SinhViens.Add(sinhvien);
_context.SaveChanges();
return(true);
}
}
public static DeTai danhsach(string masv)
{
using (var _context = new DoanLTWEntities())
{
var sinhvien = (from u in _context.SinhViens
where u.MaSV == masv
select u).Single();
return(sinhvien.DeTai);
}
}
public static bool Deletesinhvien(SinhVien sinhvien)
{
using (var _context = new DoanLTWEntities())
{
//Xóa sinh viên
var dbsinhvien = (from u in _context.SinhViens
where u.MaSV == sinhvien.MaSV
select u).SingleOrDefault();
_context.SinhViens.Remove(dbsinhvien);
_context.SaveChanges();
return(true);
}
}
public static bool UpdateSinhVien(SinhVien sinhvien)
{
try
{
using (var _context = new DoanLTWEntities())
{
_context.SinhViens.AddOrUpdate(sinhvien);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static List <SinhVien> danhsach(string madt)
{
using (var _context = new DoanLTWEntities())
{
var detai = (from u in _context.DeTais
where u.MaDT == madt
select u).Single();
if (detai.SinhViens.Count() >= 1)
{
return(detai.SinhViens.ToList());
}
else
{
return(null);
}
}
}
public static bool checkExistLanhDao(string mald, string mk)
{
using (var _context = new DoanLTWEntities())
{
var ld = from u in _context.LanhDaos
where u.TaiKhoan == mald && u.MatKhau == mk
select u;
if (ld.Count() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool checkExistSV(string masv)
{
using (var _context = new DoanLTWEntities())
{
var sv = from u in _context.SinhViens
where u.MaSV == masv
select u;
if (sv.Count() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool checkExistGiaoVien(string magv, string mk)
{
using (var _context = new DoanLTWEntities())
{
var gv = from u in _context.GiaoViens
where u.MaGV == magv && u.MatKhau == mk
select u;
if (gv.Count() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static List <DeTai> danhsach(string magv)
{
using (var _context = new DoanLTWEntities())
{
var giaovien = (from u in _context.GiaoViens
where u.MaGV == magv
select u).Single();
if (giaovien.DeTais.Count() >= 1)
{
return(giaovien.DeTais.ToList());
}
else
{
return(null);
}
}
}
public static int demdetai(string magv)
{
using (var _context = new DoanLTWEntities())
{
var giaovien = (from u in _context.GiaoViens
where u.MaGV == magv
select u).Single();
if (giaovien.DeTais.Count() >= 1)
{
return(giaovien.DeTais.Count());
}
else
{
return(0);
}
}
}
public static GiaoVien getExistGV(string magv)
{
using (var _context = new DoanLTWEntities())
{
var giaovien = from u in _context.GiaoViens
where u.MaGV == magv
select u;
if (giaovien.Count() == 1)
{
return(giaovien.Single());
}
else
{
return(null);
}
}
}
public static bool checkExistDeTai(string madt)
{
using (var _context = new DoanLTWEntities())
{
var dt = from u in _context.DeTais
where u.MaDT == madt
select u;
if (dt.Count() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public static int demsinhvien(string madt)
{
using (var _context = new DoanLTWEntities())
{
var detai = (from u in _context.DeTais
where u.MaDT == madt
select u).Single();
if (detai.SinhViens.Count() >= 1)
{
return(detai.SinhViens.Count());
}
else
{
return(0);
}
}
}
public static bool ThemDT(DeTai detai)
{
using (var _context = new DoanLTWEntities())
{
foreach (var sinhvien in detai.SinhViens)
{
var dbsinhvien = (from u in _context.SinhViens
where u.MaSV == sinhvien.MaSV
select u).Single();
dbsinhvien.DeTai = detai;
}
detai.SinhViens.Clear();
_context.DeTais.Add(detai);
_context.SaveChanges();
return(true);
}
}
public static DeTai getExistDT(string madt)
{
using (var _context = new DoanLTWEntities())
{
var detai = from u in _context.DeTais
where u.MaDT == madt
select u;
if (detai.Count() == 1)
{
return(detai.Single());
}
else
{
return(null);
}
}
}
public static List <GiaoVien> danhsachGV()
{
using (var _context = new DoanLTWEntities())
{
var giaovien = (from gv in _context.GiaoViens.AsEnumerable()
select gv)
.Select(x => new GiaoVien
{
MaGV = x.MaGV,
HoTen = x.HoTen,
GioiTinh = x.GioiTinh,
SDT = x.SDT,
Email = x.Email,
DeTais = x.DeTais,
MatKhau = x.MatKhau
}).ToList();
return(giaovien);
}
}
public static List <GiaoVien> TimKiemGV(string MaGVSearch, string TenGVSearch)
{
using (var _context = new DoanLTWEntities())
{
var giaovien = (from gv in _context.GiaoViens.AsEnumerable()
where gv.MaGV.Contains(MaGVSearch) && gv.HoTen.Contains(TenGVSearch)
select gv)
.Select(x => new GiaoVien
{
MaGV = x.MaGV,
HoTen = x.HoTen,
GioiTinh = x.GioiTinh,
SDT = x.SDT,
Email = x.Email,
DeTais = x.DeTais,
MatKhau = x.MatKhau
}).ToList();
return(giaovien);
}
}
public static bool DeleteGiaoVien(GiaoVien giaovien)
{
using (var _context = new DoanLTWEntities())
{
//Xóa list giao vien
var dbgiaovien = (from u in _context.GiaoViens
where u.MaGV == giaovien.MaGV
select u).SingleOrDefault();
foreach (var detai in dbgiaovien.DeTais)
{
var detaidb = (from u in _context.DeTais
where u.MaDT == detai.MaDT
select u).Single();
}
_context.GiaoViens.Remove(dbgiaovien);
_context.SaveChanges();
return(true);
}
}
public static bool DeleteDeTai(DeTai detai)
{
using (var _context = new DoanLTWEntities())
{
//Xóa list đề tài
var dbdetai = (from u in _context.DeTais
where u.MaDT == detai.MaDT
select u).SingleOrDefault();
foreach (var sinhvien in dbdetai.SinhViens)
{
var sinhviendb = (from u in _context.SinhViens
where u.MaSV == sinhvien.MaSV
select u).Single();
}
_context.DeTais.Remove(dbdetai);
_context.SaveChanges();
return(true);
}
}
public static bool ThemGV(GiaoVien giaovien)
{
using (var _context = new DoanLTWEntities())
{
foreach (var detai in giaovien.DeTais)
{
var dbdetai = (from u in _context.DeTais
where u.MaDT == detai.MaDT
select u).Single();
dbdetai.GiaoVien = giaovien;
}
giaovien.DeTais.Clear();
_context.GiaoViens.Add(giaovien);
_context.SaveChanges();
return(true);
}
}
public static bool UpdateGiaoVien(GiaoVien giaovien)
{
using (var _context = new DoanLTWEntities())
{
var giaoviendb = (from u in _context.GiaoViens
where u.MaGV == giaovien.MaGV
select u).Single();
giaoviendb.DeTais.Clear();
foreach (var i in giaovien.DeTais)
{
var detai = (from u in _context.DeTais
where u.MaDT == i.MaDT
select u).Single();
giaoviendb.DeTais.Add(detai);
}
giaovien.DeTais.Clear();
_context.GiaoViens.AddOrUpdate(giaovien);
_context.SaveChanges();
return(true);
}
}
public static bool UpdateDeTai(DeTai detai)
{
using (var _context = new DoanLTWEntities())
{
var detaidb = (from u in _context.DeTais
where u.MaDT == detai.MaDT
select u).Single();
detaidb.SinhViens.Clear();
foreach (var i in detai.SinhViens)
{
var sinhvien = (from u in _context.SinhViens
where u.MaSV == i.MaSV
select u).Single();
detaidb.SinhViens.Add(sinhvien);
}
detai.SinhViens.Clear();
_context.DeTais.AddOrUpdate(detai);
_context.SaveChanges();
return(true);
}
}
public static List <DeTai> danhsachDT()
{
using (var _context = new DoanLTWEntities())
{
var detai = (from dt in _context.DeTais.AsEnumerable()
select dt)
.Select(x => new DeTai
{
MaDT = x.MaDT,
TenDT = x.TenDT,
TienDoDT = x.TienDoDT,
NgayBatDau = x.NgayBatDau,
NgayKetThuc = x.NgayKetThuc,
MoTaDT = x.MoTaDT,
GiaoVien = x.GiaoVien,
SinhViens = x.SinhViens,
MaGV = x.MaGV,
NhanXet = x.NhanXet,
FileDeTai = x.FileDeTai
}).ToList();
return(detai);
}
}
public static List <DeTai> TimKiemDeTaiKhiCoCheck(string dtSearchMaDT, string dtSearchTenDT)
{
using (var _context = new DoanLTWEntities())
{
var detai = (from dt in _context.DeTais.AsEnumerable()
where dt.MaDT.Contains(dtSearchMaDT) && dt.TenDT.Contains(dtSearchTenDT) && dt.SinhViens.Count == 0
select dt)
.Select(x => new DeTai
{
MaDT = x.MaDT,
TenDT = x.TenDT,
TienDoDT = x.TienDoDT,
NgayBatDau = x.NgayBatDau,
NgayKetThuc = x.NgayKetThuc,
MoTaDT = x.MoTaDT,
GiaoVien = x.GiaoVien,
SinhViens = x.SinhViens,
MaGV = x.MaGV,
NhanXet = x.NhanXet,
FileDeTai = x.FileDeTai
}).ToList();
return(detai);
}
}
