public static bool updatebc(BaoCao baocao)
{
using (var _context = new QuanlidoansinhvienEntities())
{
_context.BaoCaos.AddOrUpdate(baocao);
_context.SaveChanges();
return(true);
}
}
public static bool updatedetai(DeTai dt)
{
using (var _context = new QuanlidoansinhvienEntities())
{
_context.DeTais.AddOrUpdate(dt);
_context.SaveChanges();
return(true);
}
}
public static bool updategiangvien(GiaoVien gv)
{
using (var _context = new QuanlidoansinhvienEntities())
{
_context.GiaoViens.AddOrUpdate(gv);
_context.SaveChanges();
return(true);
}
}
public static bool updatesinhvien(SinhVien sinhVien)
{
using (var _context = new QuanlidoansinhvienEntities())
{
_context.SinhViens.AddOrUpdate(sinhVien);
_context.SaveChanges();
return(true);
}
}
public DataTable LayUser(string UserName, string Password)
{
QuanlidoansinhvienEntities sv = new QuanlidoansinhvienEntities();
var s = from p in sv.Logins
where p.Username == UserName && p.Password == Password
select new { p.Username, p.Password, p.PhanQuyen };
DataTable dt = new DataTable();
dt.Columns.Add("UserName");
dt.Columns.Add("PassWord");
dt.Columns.Add("PhanQuyen");
foreach (var q in s)
{
dt.Rows.Add(q.Username, q.Password, q.PhanQuyen);
}
return(dt);
}
public static BaoCao getidbaocao(string ID)
{
using (var _context = new QuanlidoansinhvienEntities())
{
var baocao = (from u in _context.BaoCaos
where u.IDBaoCao == ID
select u).ToList();
if (baocao.Count == 1)
{
return(baocao[0]);
}
else
{
return(null);
}
}
}
public static DeTai getdt(string ID)
{
using (var _context = new QuanlidoansinhvienEntities())
{
var detai = (from u in _context.DeTais
where u.ID == ID
select u).ToList();
if (detai.Count == 1)
{
return(detai[0]);
}
else
{
return(null);
}
}
}
public static GiaoVien getgv(string ID)
{
using (var _context = new QuanlidoansinhvienEntities())
{
var user = (from u in _context.GiaoViens
where u.ID == ID
select u).ToList();
if (user.Count == 1)
{
return(user[0]);
}
else
{
return(null);
}
}
}
public DataTable Searchsv(string Ten)
{
QuanlidoansinhvienEntities sv = new QuanlidoansinhvienEntities();
var data = from p in sv.BaoCaos
where p.IDDeTai.Contains(Ten) || p.IDBaoCao.Contains(Ten)
select p;
DataTable dt = new DataTable();
dt.Columns.Add("IDBaoCao");
dt.Columns.Add("IDDeTai");
dt.Columns.Add("LanBaoCao");
dt.Columns.Add("TaiLieu");
dt.Columns.Add("NhanXet");
dt.Columns.Add("DiemTong");
dt.Columns.Add("TrangThai");
foreach (var q in data)
{
dt.Rows.Add(q.IDBaoCao, q.IDDeTai, q.LanBaoCao, q.TaiLieu, q.NhanXet, q.DiemTong, q.TrangThai);
}
return(dt);
}
public DataTable Searchsv(string Ten)
{
QuanlidoansinhvienEntities sv = new QuanlidoansinhvienEntities();
var data = from c in sv.DeTais
join d in sv.SinhViens on c.ID equals d.DeTai
join a in sv.Lops on d.Lop equals a.ID
join b in sv.Khoas on d.khoa equals b.ID
join f in sv.BaoCaos on c.ID equals f.IDDeTai
join g in sv.LoaiDeTais on c.LoaiDeTai equals g.ID
where f.TrangThai == true && d.ID.Contains(Ten)
select new
{
ID = d.ID,
Ten = d.Ten,
GioiTinh = d.GioiTinh,
Lop = a.TenLop,
Khoa = b.TenKhoa,
TenDeTai = c.TenDeTai,
LoaiDeTai = g.LoaiDeTai1,
TrangThai = f.TrangThai,
DiemTong = f.DiemTong
};
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Ten");
dt.Columns.Add("GioiTinh");
dt.Columns.Add("Lop");
dt.Columns.Add("Khoa");
dt.Columns.Add("TenDeTai");
dt.Columns.Add("LoaiDeTai");
dt.Columns.Add("TrangThai");
dt.Columns.Add("DiemTong");
foreach (var q in data)
{
dt.Rows.Add(q.ID, q.Ten, q.GioiTinh, q.Lop, q.Khoa, q.TenDeTai, q.LoaiDeTai, q.TrangThai, q.DiemTong);
}
return(dt);
}
public DataTable Searchgv(string Ten)
{
QuanlidoansinhvienEntities sv = new QuanlidoansinhvienEntities();
var data = from p in sv.GiaoViens
where p.Ten.Contains(Ten) || p.ID.Contains(Ten)
select p;
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Ten");
dt.Columns.Add("NgaySinh");
dt.Columns.Add("GioiTinh");
dt.Columns.Add("ChucVu");
dt.Columns.Add("Khoa");
dt.Columns.Add("DiaChi");
dt.Columns.Add("Sdt");
foreach (var q in data)
{
dt.Rows.Add(q.ID, q.Ten, q.NgaySinh, q.GioiTinh, q.ChucVu, q.Khoa, q.DiaChi, q.Sdt);
}
return(dt);
}
public DataTable Searchsv(string Ten)
{
QuanlidoansinhvienEntities sv = new QuanlidoansinhvienEntities();
var data = from p in sv.DeTais
where p.TenDeTai.Contains(Ten) || p.ID.Contains(Ten)
select p;
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("TenDeTai");
dt.Columns.Add("LoaiDeTai");
dt.Columns.Add("GiaoVienHuongDan");
dt.Columns.Add("MoTa");
dt.Columns.Add("SoLuongSinhVien");
dt.Columns.Add("ThoiGianBatDau");
dt.Columns.Add("ThoiGianKetThuc");
dt.Columns.Add("SoLanBaoCao");
dt.Columns.Add("TinhTrang");
foreach (var q in data)
{
dt.Rows.Add(q.ID, q.TenDeTai, q.LoaiDeTai, q.GiaoVienHuongDan, q.MoTa, q.SoLuongSinhVien, q.ThoiGianBatDau, q.ThoiGianKetThuc, q.SoLanBaoCao, q.TinhTrang);
}
return(dt);
}
