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