public static void capNhatDuAn(Project DuAn) { using (var _context = new DBLabManagerEntities()) { _context.Projects.AddOrUpdate(DuAn); _context.SaveChanges(); } }
public static void capNhatCongViec(ProjectMember congViec) { using (var _context = new DBLabManagerEntities()) { _context.ProjectMembers.AddOrUpdate(congViec); _context.SaveChanges(); } }
public static void SuaThongTinThanhVien(Member thanhVien) { using (var _context = new DBLabManagerEntities()) { _context.Members.AddOrUpdate(thanhVien); _context.SaveChanges(); } }
public static void themDuAn(Project DuAn) { using (var _context = new DBLabManagerEntities()) { _context.Projects.Add(DuAn); _context.SaveChanges(); } }
public static void themTaiKhoan(SignIn signIn) { using (var _context = new DBLabManagerEntities()) { _context.SignIns.Add(signIn); _context.SaveChanges(); } }
public static void themNhanVien(Member nhanVien) { using (var _context = new DBLabManagerEntities()) { _context.Members.Add(nhanVien); _context.SaveChanges(); } }
public static List <string> layDanhSachMaNV() { using (var _context = new DBLabManagerEntities()) { var dsMaNV = (from m in _context.Members select m.ID).ToList(); return(dsMaNV); } }
public static List <Member> layDanhSachThanhVien() { using (var _context = new DBLabManagerEntities()) { var danhSachThanhVien = (from m in _context.Members select m); return(danhSachThanhVien.ToList()); } }
public static List <Project> layDanhSachDuAn() { using (var _context = new DBLabManagerEntities()) { var danhSachDuAn = (from p in _context.Projects select p); return(danhSachDuAn.ToList()); } }
public static List <string> layDanhSachTenDangNhap() { using (var _context = new DBLabManagerEntities()) { var danhSachTenDangNhap = (from s in _context.SignIns select s.UserName); return(danhSachTenDangNhap.ToList()); } }
public static List <ProjectMember> layDSNhungCongViecChuaLam() { using (var _context = new DBLabManagerEntities()) { var dsCongViec = (from pm in _context.ProjectMembers where pm.Progress == false select pm).ToList(); return(dsCongViec); } }
public static List <Member> layDanhSachThanhVienTheoMaNV(string kyTu) { using (var _context = new DBLabManagerEntities()) { var danhSachThanhVien = (from m in _context.Members where m.ID.Contains(kyTu) select m); return(danhSachThanhVien.ToList()); } }
public static Member layNhanVienTuMaNV(string MaNV) { using (var _context = new DBLabManagerEntities()) { var nhanVien = (from m in _context.Members where string.Compare(m.ID.Trim(), MaNV, false) == 0 select m).SingleOrDefault(); return(nhanVien); } }
public static List <ProjectMember> layDanhSachCongViec(string maDA) { using (var _context = new DBLabManagerEntities()) { var danhSachCongViec = (from pm in _context.ProjectMembers where string.Compare(pm.IDProject.Trim(), maDA, false) == 0 select pm); return(danhSachCongViec.ToList()); } }
public static Project layDuAn(string maDA) { using (var _context = new DBLabManagerEntities()) { Project DuAn = (from p in _context.Projects where string.Compare(p.ID.Trim(), maDA, false) == 0 select p).SingleOrDefault(); return(DuAn); } }
public static List <Project> layDanhSachDuAnTheoMaDuAn(string kyTu) { using (var _context = new DBLabManagerEntities()) { var danhSachDuAn = (from p in _context.Projects where p.ID.Contains(kyTu) select p); return(danhSachDuAn.ToList()); } }
public static ProjectMember layCongViec(string maDA, string maNV) { using (var _context = new DBLabManagerEntities()) { var CongViec = (from pm in _context.ProjectMembers where string.Compare(pm.IDProject.Trim(), maDA, false) == 0 && string.Compare(pm.IDMember.Trim(), maNV, false) == 0 select pm).SingleOrDefault(); return(CongViec); } }
public static List <ProjectMember> layDSNhungCongViecChuaLamCuaNhanVien(string maNV) { using (var _context = new DBLabManagerEntities()) { var dsCongViec = (from pm in _context.ProjectMembers where string.Compare(pm.IDMember.Trim(), maNV, false) == 0 && pm.Progress == false select pm).ToList(); return(dsCongViec); } }
public static bool kiemTraDuAnDaTonTai(string maDA) { using (var _context = new DBLabManagerEntities()) { if (layDuAn(maDA) == null) { return(false); } return(true); } }
public static string layIDNVTuTenDangNhap(string tenDangNhap) { using (var _context = new DBLabManagerEntities()) { var NV = (from s in _context.SignIns where s.UserName == tenDangNhap select s).SingleOrDefault(); if (NV == null) { return(null); } if (string.Compare(NV.UserName.Trim(), tenDangNhap, false) == 0) { return(NV.IDMember.Trim()); } return(null); } }
public static bool kiemTraMatKhau(string matKhau, string tenDangNhap) { using (var _context = new DBLabManagerEntities()) { var DangNhap = (from s in _context.SignIns where s.PassWord == matKhau && s.UserName == tenDangNhap select s.UserName).SingleOrDefault(); if (DangNhap == null) { return(false); } if (string.Compare(DangNhap.Trim(), tenDangNhap, false) == 0) { return(true); } return(false); } }
public static bool kiemTraTenDangNhap(string tenDangNhap) { using (var _context = new DBLabManagerEntities()) { var TenDangNhapDB = (from s in _context.SignIns where s.UserName == tenDangNhap select s.UserName).SingleOrDefault(); if (TenDangNhapDB == null) { return(false); } if (string.Compare(TenDangNhapDB.Trim(), tenDangNhap, false) == 0) { return(true); } return(false); } }
public static bool kiemTraMaSoNhanVien(string maSoNhanVien) { using (var _context = new DBLabManagerEntities()) { var MaSoNhanVienDB = (from s in _context.SignIns where s.IDMember == maSoNhanVien select s.IDMember).SingleOrDefault(); if (MaSoNhanVienDB == null) { return(false); } if (string.Compare(MaSoNhanVienDB.Trim(), maSoNhanVien, false) == 0) { return(true); } return(false); } }
public static void xoaDuAn(string maDA) { using (var _context = new DBLabManagerEntities()) { Project DuAn = (from p in _context.Projects where string.Compare(p.ID.Trim(), maDA, false) == 0 select p).SingleOrDefault(); List <ProjectMember> dSCongViec = (from pm in _context.ProjectMembers where string.Compare(pm.IDProject.Trim(), maDA, false) == 0 select pm).ToList(); foreach (ProjectMember CongViec in dSCongViec) { _context.ProjectMembers.Remove(CongViec); } _context.Projects.Remove(DuAn); _context.SaveChanges(); } }
public static bool themCongViec(string maDA, string maNV, string congViec) { using (var _context = new DBLabManagerEntities()) { var CongViec = layCongViec(maDA, maNV); if (CongViec == null) { ProjectMember CongViecMoi = new ProjectMember(); CongViecMoi.IDProject = maDA; CongViecMoi.IDMember = maNV; CongViecMoi.Works = congViec; CongViecMoi.LinkCheckProgress = ""; CongViecMoi.Progress = false; _context.ProjectMembers.Add(CongViecMoi); _context.SaveChanges(); return(true); } return(false); } }
public static void xoaNhanVien(Member thanhVien) { using (var _context = new DBLabManagerEntities()) { var ThanhVien = (from m in _context.Members where m.ID == thanhVien.ID select m).SingleOrDefault(); try { var TaiKhoan = (from s in _context.SignIns where s.IDMember == thanhVien.ID select s).SingleOrDefault(); _context.SignIns.Remove(TaiKhoan); } catch { } _context.Members.Remove(ThanhVien); _context.SaveChanges(); } }