public bool ThemDA(string MaDA, string TenDA, string Phong, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
Duan da = new Duan();
da.MaDA = MaDA;
da.TenDA = TenDA;
da.Phong = Phong;
qlnvEntity.Duans.Add(da);
qlnvEntity.SaveChanges();
return(true);
}
public bool XoaLuong(ref string err, string MaNV)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
Luong l = new Luong();
l.MaNV = MaNV;
qlnvEntity.Luongs.Attach(l);
qlnvEntity.Luongs.Remove(l);
qlnvEntity.SaveChanges();
return(true);
}
public bool XoaNV(ref string err, string MaNV)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
NhanVien nv = new NhanVien();
nv.MaNV = MaNV;
qlnvEntity.NhanViens.Attach(nv);
qlnvEntity.NhanViens.Remove(nv);
qlnvEntity.SaveChanges();
return(true);
}
public bool ThemLuong(string MaNV, string LuongCoBan, string LuongThuong, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
Luong l = new Luong();
l.MaNV = MaNV;
l.LuongCoBan = Convert.ToInt32(LuongCoBan);
l.LuongThuong = Convert.ToInt32(LuongThuong);
qlnvEntity.Luongs.Add(l);
qlnvEntity.SaveChanges();
return(true);
}
public bool ThemPC(string MaNV, string MaDA, string NgayBD, string NgayKT, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
PhanCong pc = new PhanCong();
pc.MaNV = MaNV;
pc.MaDA = MaDA;
pc.ThoiGianBatDau = Convert.ToDateTime(NgayBD, cultures);
pc.ThoiGianKetThuc = Convert.ToDateTime(NgayKT, cultures);
qlnvEntity.PhanCongs.Add(pc);
qlnvEntity.SaveChanges();
return(true);
}
public bool ThemPB(string MaPB, string TenPB, string Truong, string Pho, string KT, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
PhongBan pb = new PhongBan();
pb.MaPhong = MaPB;
pb.TenPhong = TenPB;
pb.TruongPhong = Truong;
pb.PhoPhong = Pho;
pb.KeToan = KT;
qlnvEntity.PhongBans.Add(pb);
qlnvEntity.SaveChanges();
return(true);
}
public bool CapNhatDA(string MaDA, string TenDA, string Phong, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var DuanQuery = (from l in qlnvEntity.Duans
where l.MaDA == MaDA
select l).SingleOrDefault();
if (DuanQuery != null)
{
DuanQuery.MaDA = MaDA;
DuanQuery.TenDA = TenDA;
DuanQuery.Phong = Phong;
qlnvEntity.SaveChanges();
}
return(true);
}
public bool CapNhatLuong(string MaNV, string LuongCoban, string LuongThuong, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var LuongQuery = (from l in qlnvEntity.Luongs
where l.MaNV == MaNV
select l).SingleOrDefault();
if (LuongQuery != null)
{
LuongQuery.MaNV = MaNV;
LuongQuery.LuongCoBan = Convert.ToInt32(LuongCoban);
LuongQuery.LuongThuong = Convert.ToInt32(LuongThuong);
qlnvEntity.SaveChanges();
}
return(true);
}
public bool CapNhatNhanVien(string MaNV, string TenNV, string NgaySinh, string Diachi, string GioiTinh, string Phong, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var nvQuery = (from nv in qlnvEntity.NhanViens
where nv.MaNV == MaNV
select nv).SingleOrDefault();
if (nvQuery != null)
{
nvQuery.HoVaTen = TenNV;
nvQuery.NgaySinh = Convert.ToDateTime(NgaySinh, cultures);
nvQuery.DiaChi = Diachi;
nvQuery.GioiTinh = GioiTinh;
nvQuery.Phong = Phong;
qlnvEntity.SaveChanges();
}
return(true);
}
public bool ThemNV(string MaNV, string TenNV, string NgaySinh, string Diachi, string GioiTinh, string Phong, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
NhanVien nv = new NhanVien();
nv.MaNV = MaNV;
nv.HoVaTen = TenNV;
nv.NgaySinh = Convert.ToDateTime(NgaySinh, cultures);
nv.DiaChi = Diachi;
nv.GioiTinh = GioiTinh;
nv.Phong = Phong;
nv.Status = "1";
qlnvEntity.NhanViens.Add(nv);
qlnvEntity.SaveChanges();
return(true);
}
public bool CapNhatPC(string MaNV, string MaDA, string NgayBD, string NgayKT, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var pcQuery = (from pc in qlnvEntity.PhanCongs
where pc.MaNV == MaNV
select pc).SingleOrDefault();
if (pcQuery != null)
{
pcQuery.MaNV = MaNV;
pcQuery.MaDA = MaDA;
pcQuery.ThoiGianBatDau = Convert.ToDateTime(NgayBD, cultures);
pcQuery.ThoiGianKetThuc = Convert.ToDateTime(NgayKT, cultures);
qlnvEntity.SaveChanges();
}
return(true);
}
public bool CapNhatPB(string MaPB, string TenPB, string Truong, string Pho, string KT, ref string err)
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var PBQuery = (from l in qlnvEntity.PhongBans
where l.MaPhong == MaPB
select l).SingleOrDefault();
if (PBQuery != null)
{
PBQuery.MaPhong = MaPB;
PBQuery.TenPhong = TenPB;
PBQuery.TruongPhong = Truong;
PBQuery.PhoPhong = Pho;
PBQuery.KeToan = KT;
qlnvEntity.SaveChanges();
}
return(true);
}
public DataTable LayPC()
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var tps =
from p in qlnvEntity.PhanCongs
select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Nhân Viên");
dt.Columns.Add("Mã Dự Án");
dt.Columns.Add("Ngày Bắt đầu");
dt.Columns.Add("Ngày Kết Thúc");
foreach (var p in tps)
{
dt.Rows.Add(p.MaNV, p.MaDA, p.ThoiGianBatDau, p.ThoiGianKetThuc);
}
return(dt);
}
public DataTable LayDuAn()
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var tps =
from p in qlnvEntity.Duans
select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Dự Án");
dt.Columns.Add("Tên Dự Án");
dt.Columns.Add("Phòng");
foreach (var p in tps)
{
dt.Rows.Add(p.MaDA, p.TenDA, p.Phong);
}
return(dt);
}
public DataTable LayLuong()
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var tps =
from p in qlnvEntity.Luongs
select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Nhân Viên");
dt.Columns.Add("Lương Cơ Bản");
dt.Columns.Add("Lương Thưởng");
foreach (var p in tps)
{
dt.Rows.Add(p.MaNV, p.LuongCoBan, p.LuongThuong);
}
return(dt);
}
public DataTable LayPB()
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var tps =
from p in qlnvEntity.PhongBans
select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Phòng");
dt.Columns.Add("Tên Phòng");
dt.Columns.Add("Trưởng Phòng");
dt.Columns.Add("Phó Phòng");
dt.Columns.Add("Kế Toán");
foreach (var p in tps)
{
dt.Rows.Add(p.MaPhong, p.TenPhong, p.TruongPhong, p.PhoPhong, p.KeToan);
}
return(dt);
}
public DataTable LayNV()
{
QuanLyNVEntities qlnvEntity = new QuanLyNVEntities();
var tps =
from p in qlnvEntity.NhanViens
select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Nhân Viên");
dt.Columns.Add("Họ Và Tên");
dt.Columns.Add("Ngày sinh");
dt.Columns.Add("Địa chỉ");
dt.Columns.Add("Giới tính");
dt.Columns.Add("Phòng");
dt.Columns.Add("Ngày làm trong tháng");
dt.Columns.Add("Ngày làm gần nhất");
dt.Columns.Add("Status");
foreach (var p in tps)
{
dt.Rows.Add(p.MaNV, p.HoVaTen, p.NgaySinh, p.DiaChi, p.GioiTinh, p.Phong, p.NgayLamTrongThang, p.NgayLamGanNhat);
}
return(dt);
}
