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