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