public static NhanVienDTO CapNhat(NhanVienDTO nv)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
NHANVIEN NhanVienCanCapNhat = db.NHANVIENs.SingleOrDefault(i => i.MaNV == nv.MaNV);
if (NhanVienCanCapNhat != null)
{
NhanVienCanCapNhat.HoLot = nv.HoLot;
NhanVienCanCapNhat.Ten = nv.Ten;
NhanVienCanCapNhat.CMND = nv.CMND;
NhanVienCanCapNhat.GioiTinh = nv.GioiTinh;
NhanVienCanCapNhat.NgaySinh = nv.NgaySinh;
NhanVienCanCapNhat.DienThoai = nv.DienThoai;
NhanVienCanCapNhat.HinhAnh = nv.HinhAnh;
NhanVienCanCapNhat.DiaChi = nv.DiaChi;
NhanVienCanCapNhat.MaBP = nv.MaBP;
NhanVienCanCapNhat.MaChucVu = nv.MaChucVu;
NhanVienCanCapNhat.MaTrinhDo = nv.MaTrinhDo;
NhanVienCanCapNhat.DaThoiViec = nv.DaThoiViec;
db.SaveChanges();
}
return(MyConvert.Convert_NhanVien_To_NhanVienDTO(NhanVienCanCapNhat));
}
catch
{
return(null);
}
}
public static List <NhanVienDTO> LoadNhanVien()
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
var query = from nv in db.NHANVIENs
where nv.DaThoiViec == false
orderby nv.Ten ascending
select new NhanVienDTO
{
MaNV = nv.MaNV,
HoLot = nv.HoLot,
Ten = nv.Ten,
CMND = nv.CMND,
GioiTinh = nv.GioiTinh,
NgaySinh = nv.NgaySinh,
DienThoai = nv.DienThoai,
HinhAnh = nv.HinhAnh,
DiaChi = nv.DiaChi,
MaTrinhDo = nv.MaTrinhDo,
TenTrinhDo = nv.TRINHDO.TenTrinhDo,
MaBP = nv.MaBP,
MaChucVu = nv.MaChucVu,
TenBP = nv.BOPHAN.TenBP,
TenChucVu = nv.CHUCVU.TenChucVu,
DaThoiViec = nv.DaThoiViec
};
return(query.ToList());
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
}
public static List <NhanVienDTO> LoadNhanVienDaThoiViec()
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
var query = from nv in db.NHANVIENs
where nv.DaThoiViec == true
select new NhanVienDTO
{
MaNV = nv.MaNV,
HoLot = nv.HoLot,
Ten = nv.Ten,
CMND = nv.CMND,
GioiTinh = nv.GioiTinh,
NgaySinh = nv.NgaySinh,
DienThoai = nv.DienThoai,
HinhAnh = nv.HinhAnh,
DiaChi = nv.DiaChi,
MaBP = nv.MaBP,
MaChucVu = nv.MaChucVu,
TenBP = nv.BOPHAN.TenBP,
TenChucVu = nv.CHUCVU.TenChucVu,
DaThoiViec = nv.DaThoiViec
};
return(query.ToList());
}
public static NhanVienDTO Them(NhanVienDTO nvDTO)
{
NHANVIEN nv = MyConvert.Convert_NhanVienDTO_To_NhanVien(nvDTO);
QuanLyNhanSuEntities db = DataProvider.dbContext;
NHANVIEN nvAdded = db.NHANVIENs.Add(nv);
db.SaveChanges();
return(MyConvert.Convert_NhanVien_To_NhanVienDTO(nvAdded));
}
public static bool Them(List <NHANVIEN> lstNhanVien)
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
List <NHANVIEN> lstNhanVienInserted = db.NHANVIENs.AddRange(lstNhanVien).ToList();
if (lstNhanVien.Count == lstNhanVienInserted.Count)
{
db.SaveChanges();
return(true);
}
return(false);
}
public static List <TinhLuongDTO> TinhLuongTatCaNhanVien(int thang, int nam, double lcb, double ltc)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.Database.SqlQuery <TinhLuongDTO>("sp_TinhLuongTatCaNhanVien @thang, @nam, @luongCoBan, @luongTangCa", new SqlParameter("@thang", thang), new SqlParameter("@nam", nam), new SqlParameter("@luongCoBan", lcb), new SqlParameter("@luongTangCa", ltc)).ToList());
}
catch (Exception e)
{
return(null);
}
}
public static bool Xoa(int maNhanVien)
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
NHANVIEN nv = db.NHANVIENs.SingleOrDefault(i => i.MaNV == maNhanVien);
nv = db.NHANVIENs.Remove(nv);
db.SaveChanges();
if (nv != null)
{
return(true);
}
return(false);
}
public static bool ChamCongNhanVien(List <CHAMCONG> lstChamCong)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
db.CHAMCONGs.AddRange(lstChamCong);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static bool Xoa(string soBaoHiem)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
BAOHIEM bh = db.BAOHIEMs.SingleOrDefault(i => i.SoBH == soBaoHiem);
db.BAOHIEMs.Remove(bh);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static ChucVuDTO XoaChucVu(ChucVuDTO chucVuDTO)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
CHUCVU cv = db.CHUCVUs.SingleOrDefault(i => i.MaChucVu == chucVuDTO.MaChucVu);
cv = db.CHUCVUs.Remove(cv);
db.SaveChanges();
return(chucVuDTO);
}
catch
{
return(null);
}
}
public static BoPhanDTO SuaBoPhan(BoPhanDTO boPhanDTO)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
BOPHAN boPhan = db.BOPHANs.SingleOrDefault(i => i.MaBP == boPhanDTO.MaBP);
boPhan.TenBP = boPhanDTO.TenBP;
db.SaveChanges();
return(boPhanDTO);
}
catch
{
return(null);
}
}
public static bool XoaBoPhan(int maBoPhanCanXoa)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
BOPHAN boPhan = db.BOPHANs.SingleOrDefault(i => i.MaBP == maBoPhanCanXoa);
boPhan = db.BOPHANs.Remove(boPhan);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static bool CapNhat(BAOHIEM bh)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
BAOHIEM bhUpdate = db.BAOHIEMs.SingleOrDefault(i => i.SoBH == bh.SoBH);
bhUpdate.NgayCap = bh.NgayCap;
bhUpdate.NoiCap = bh.NoiCap;
bhUpdate.NoiKhamBenh = bh.NoiKhamBenh;
bhUpdate.NgayHetHan = bh.NgayHetHan;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public static ChucVuDTO ThemChucVu(ChucVuDTO chucVuDTO)
{
try
{
CHUCVU chucVu = new CHUCVU();
chucVu.TenChucVu = chucVuDTO.TenChucVu;
QuanLyNhanSuEntities db = DataProvider.dbContext;
chucVu = db.CHUCVUs.Add(chucVu);
db.SaveChanges();
chucVuDTO.MaChucVu = chucVu.MaChucVu;
chucVuDTO.TenChucVu = chucVu.TenChucVu;
chucVuDTO.SoLuong = 0;
return(chucVuDTO);
}
catch
{
return(null);
}
}
public static BoPhanDTO ThemBoPhan(BoPhanDTO boPhanDTO)
{
try
{
BOPHAN boPhan = new BOPHAN();
boPhan.TenBP = boPhanDTO.TenBP;
QuanLyNhanSuEntities db = DataProvider.dbContext;
boPhan = db.BOPHANs.Add(boPhan);
db.SaveChanges();
boPhanDTO.MaBP = boPhan.MaBP;
boPhanDTO.TenBP = boPhan.TenBP;
boPhanDTO.SoLuong = 0;
return(boPhanDTO);
}
catch
{
return(null);
}
}
public static BAOHIEM Them(BAOHIEM bh)
{
try
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
bh = db.BAOHIEMs.Add(bh);
if (bh != null)
{
db.SaveChanges();
return(bh);
}
return(null);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
return(null);
}
}
public static List <TRINHDO> LoadTrinhDo()
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.TRINHDOes.ToList());
}
public static List <TRANGTHAICHAMCONG> Load()
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.TRANGTHAICHAMCONGs.ToList());
}
public static List <BOPHAN> LoadBoPhan()
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.BOPHANs.ToList());
}
public static List <ChucVuDTO> LoadSoLuongNhanVienTungChucVu()
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.Database.SqlQuery <ChucVuDTO>("sp_SoLuongNhanVienTungChucVu").ToList());
}
public static List <CHUCVU> LoadChucVu()
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.CHUCVUs.ToList());
}
public static List <BAOHIEM> Load(int maNhanVien)
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.BAOHIEMs.Where(i => i.MaNV == maNhanVien).ToList());
}
public static List <ChamCongDTO> LoadBangChamCongTheoNgay(int ngay, int thang, int nam)
{
QuanLyNhanSuEntities db = DataProvider.dbContext;
return(db.Database.SqlQuery <ChamCongDTO>("sp_ChamCongNhanVien @ngay, @thang, @nam", new SqlParameter("@ngay", ngay), new SqlParameter("@thang", thang), new SqlParameter("@nam", nam)).ToList());
}
