public Models.QuanHeCongTac Find(int _congtacID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.QuanHeCongTacs.FirstOrDefault(x => x.QHCTID == _congtacID));
}
public Models.TaiSanKhac Find(int _taisanID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.TaiSanKhacs.FirstOrDefault(x => x.TSKID == _taisanID));
}
public Models.DanhGiaLaoDong Find(int _danhgiaID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.DanhGiaLaoDongs.FirstOrDefault(x => x.DGLDID == _danhgiaID));
}
private IEnumerable <Models.PhongTangDanhHieu> All(int _nhanvienID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.PhongTangDanhHieux.Where(x => x.NVID == _nhanvienID).OrderByDescending(x => x.PTDHID));
}
public Models.Dat Find(int _datID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return db.Dats.FirstOrDefault(x => x.DATID == _datID);
}
public Models.HeSoLuong Find(int _hesoID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.HeSoLuongs.FirstOrDefault(x => x.HSLID == _hesoID));
}
public Models.TrinhDoTinHoc Find(int _trinhdotinhocID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.TrinhDoTinHocs.FirstOrDefault(x => x.TDTHID == _trinhdotinhocID));
}
public Models.KhenThuong Find(int _khenthuongID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.KhenThuongs.FirstOrDefault(x => x.KTID == _khenthuongID));
}
public Models.DongSan Find(int _dongsanID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.DongSans.FirstOrDefault(x => x.DSID == _dongsanID));
}
public Models.KyLuat Find(int _kyluatID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.KyLuats.FirstOrDefault(x => x.KLID == _kyluatID));
}
private IEnumerable <Models.KhenThuong> All(int _nhanvienID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.KhenThuongs.Where(x => x.NVID == _nhanvienID).OrderByDescending(x => x.KTID));
}
public Models.KeKhaiCon Find(int _concaiID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.KeKhaiCons.FirstOrDefault(x => x.KKCID == _concaiID));
}
public IEnumerable <Models.KeKhaiCon> All(int _kekhaiID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.KeKhaiCons.Where(x => x.KKID == _kekhaiID).OrderByDescending(x => x.KKCID));
}
// ATTRIBUTES
private IEnumerable <Models.QuanHeCongTac> QuanHeCongTac_Of_QuanHe(int _quanheID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.QuanHeCongTacs.Where(x => x.QHID == _quanheID).OrderBy(x => x.QHCTTuNgay));
}
public Models.Account FindByEmail(string _email)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.Accounts.FirstOrDefault(x => x.ACCEmail.Equals(_email)));
}
public Models.ChucVu Find(int _chucvuID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.ChucVus.FirstOrDefault(x => x.CVID == _chucvuID));
}
public Models.Account Login(string _email, string _password)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.Accounts.FirstOrDefault(x => x.ACCEmail.Equals(_email) && x.ACCPassword.Equals(_password)));
}
public Models.ChinhTriXaHois Find(int _ctxhID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.ChinhTriXaHois.FirstOrDefault(x => x.CTXHID == _ctxhID));
}
public Models.ThuNhap Find(int _thunhapID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.ThuNhaps.FirstOrDefault(x => x.TNID == _thunhapID));
}
public Models.ChamCong Find(int _chamcongID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.ChamCongs.FirstOrDefault(x => x.CCID == _chamcongID));
}
public Models.PhuTrachChamCong Find(int _phutrachID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.PhuTrachChamCongs.FirstOrDefault(x => x.PTCCID == _phutrachID));
}
public Models.ChamCong FindByNgayThangLamViec(int _lamviecID, DateTime _ngaythang)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.ChamCongs.FirstOrDefault(x => x.CCDATE == _ngaythang && x.LVID == _lamviecID));
}
public Models.PhongTangDanhHieu Find(int _danhhieuID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.PhongTangDanhHieux.FirstOrDefault(x => x.PTDHID == _danhhieuID));
}
public Models.Tien Find(int _tienID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.Tiens.FirstOrDefault(x => x.TIEID == _tienID));
}
public Models.GiaiTrinh Find(int _giaitrinhID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.GiaiTrinhs.FirstOrDefault(x => x.GTID == _giaitrinhID));
}
public Models.KhoanNo Find(int _khoannoID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.KhoanNos.FirstOrDefault(x => x.KNID == _khoannoID));
}
private IEnumerable <Models.DanhGiaLaoDong> All(int _nhanvienID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.DanhGiaLaoDongs.Where(x => x.NVID == _nhanvienID).OrderByDescending(x => x.DGLDNam));
}
public Models.Account Find(int _accountID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.Accounts.FirstOrDefault(x => x.ACCID == _accountID));
}
public Models.QuaTrinhDaoTao Find(int _qtdtID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
return(db.QuaTrinhDaoTaos.FirstOrDefault(x => x.QTDTID == _qtdtID));
}
// LOAD DATA SOURCE
public void Load_DataSource_RadGrid(RadGrid _radgrid)
{
EmployeeManagementEntities db = new EmployeeManagementEntities();
_radgrid.DataSource = db.Ngaches.ToList();
}
