public void Insert(int _nhanvienID, string _chucvudang, string _chucvuchinhquyen, string _donvi,
string _chibo, string _hangchucdanh, int _bac, decimal _hesoluong, string _uudiem,
string _ketquakhacphuc, string _khuyetdiem, string _phuonghuong, string _danhgia, int _nam, DateTime _ngaythang)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DanhGiaDangVien danhgia = new DanhGiaDangVien();
danhgia.NVID = _nhanvienID;
danhgia.DGDVChucVuDang = _chucvudang;
danhgia.DGDVChucVuChinhQuyen = _chucvuchinhquyen;
danhgia.DGDVDonVi = _donvi;
danhgia.DGDVChiBo = _chibo;
danhgia.DGDVHangChucDanh = _hangchucdanh;
danhgia.DGDVBac = _bac;
danhgia.DGDVHeSoLuong = _hesoluong;
danhgia.DGDVUuDiem = _uudiem;
danhgia.DGDVKetQuaKhacPhuc = _ketquakhacphuc;
danhgia.DGDVKhuyetDiem = _khuyetdiem;
danhgia.DGDVPhuongHuong = _phuonghuong;
danhgia.DGDVDanhGia = _danhgia;
danhgia.DGDVNam = _nam;
danhgia.DGDVNgayThang = _ngaythang;
db.DanhGiaDangViens.Add(danhgia);
db.SaveChanges();
db.Dispose();
}
public void Update(int _danhgiaID, int _namdanhgia, string _chucdanh, string _donvi, string _nghenghiep,
int _bac, decimal _hesoluong, string _ketquathuchiencongviec, string _daoducnghenghiep,
string _trachnhiem, string _nghiavu, string _uudiem, string _phanloai, string _ykiendonvi,
string _thongnhattapthe, DateTime _ngaythang)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DanhGiaVienChuc danhgia = db.DanhGiaVienChucs.FirstOrDefault(x => x.DGVCID == _danhgiaID);
danhgia.DGVCNam = _namdanhgia;
danhgia.DGVCChucDanh = _chucdanh;
danhgia.DGVCDonVi = _donvi;
danhgia.DGVCNgheNghiep = _nghenghiep;
danhgia.DGVCBac = _bac;
danhgia.DGVCHeSoLuong = _hesoluong;
danhgia.DGVCKetQua = _ketquathuchiencongviec;
danhgia.DGVCDaoDuc = _daoducnghenghiep;
danhgia.DGVCTrachNhiem = _trachnhiem;
danhgia.DGVCNghiaVu = _nghiavu;
danhgia.DGVCUuDiem = _uudiem;
danhgia.DGVCPhanLoai = _phanloai;
danhgia.DGVCYKien = _ykiendonvi;
danhgia.DGVCThongNhat = _thongnhattapthe;
danhgia.DGVCNgay = _ngaythang;
db.SaveChanges();
db.Dispose();
}
public void Insert(int _nhanvienID, int _namdanhgia, string _chucdanh, string _donvi, string _nghenghiep,
int _bac, decimal _hesoluong, string _ketquathuchiencongviec, string _daoducnghenghiep,
string _trachnhiem, string _nghiavu, string _uudiem, string _phanloai, string _ykiendonvi,
string _thongnhattapthe, DateTime _ngaythang)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DanhGiaLaoDong danhgia = new DanhGiaLaoDong();
danhgia.NVID = _nhanvienID;
danhgia.DGLDNam = _namdanhgia;
danhgia.DGLDChucDanh = _chucdanh;
danhgia.DGLDDonVi = _donvi;
danhgia.DGLDNgheNghiep = _nghenghiep;
danhgia.DGLDBac = _bac;
danhgia.DGLDHeSoLuong = _hesoluong;
danhgia.DGLDKetQua = _ketquathuchiencongviec;
danhgia.DGLDDaoDuc = _daoducnghenghiep;
danhgia.DGLDTrachNhiem = _trachnhiem;
danhgia.DGLDNghiaVu = _nghiavu;
danhgia.DGLDUuDiem = _uudiem;
danhgia.DGLDPhanLoai = _phanloai;
danhgia.DGLDYKien = _ykiendonvi;
danhgia.DGLDThongNhat = _thongnhattapthe;
danhgia.DGLDNgay = _ngaythang;
db.DanhGiaLaoDongs.Add(danhgia);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _kyluatID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.KyLuat kyluat = db.KyLuats.FirstOrDefault(x => x.KLID == _kyluatID);
db.KyLuats.Remove(kyluat);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _kekhaiID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.KeKhai kekhai = db.KeKhais.FirstOrDefault(x => x.KKID == _kekhaiID);
db.KeKhais.Remove(kekhai);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _nhaID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.Nha nha = db.Nhas.FirstOrDefault(x => x.NHAID == _nhaID);
db.Nhas.Remove(nha);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _ngoainguID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.TrinhDoNgoaiNgu ngoaingu = db.TrinhDoNgoaiNgus.FirstOrDefault(x => x.TDNNID == _ngoainguID);
db.TrinhDoNgoaiNgus.Remove(ngoaingu);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _daquiID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DaQui daqui = db.DaQuis.FirstOrDefault(x => x.DQID == _daquiID);
db.DaQuis.Remove(daqui);
db.SaveChanges();
db.Dispose();
}
public void UpdateOwnAccount(string _email, string _password)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.Account account = db.Accounts.FirstOrDefault(x => x.ACCEmail.Equals(_email));
account.ACCPassword = _password;
db.SaveChanges();
db.Dispose();
}
public void Delete(int _khoannoID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.KhoanNo khoanno = db.KhoanNos.FirstOrDefault(x => x.KNID == _khoannoID);
db.KhoanNos.Remove(khoanno);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _tienID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.Tien tien = db.Tiens.FirstOrDefault(x => x.TIEID == _tienID);
db.Tiens.Remove(tien);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _ctxhID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.ChinhTriXaHois ctxh = db.ChinhTriXaHois.FirstOrDefault(x => x.CTXHID == _ctxhID);
db.ChinhTriXaHois.Remove(ctxh);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _chucvuID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.ChucVu chucvu = db.ChucVus.FirstOrDefault(x => x.CVID == _chucvuID);
db.ChucVus.Remove(chucvu);
db.SaveChanges();
db.Dispose();
}
public void Update(int _chucvuID, string _ten)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.ChucVu chucvu = db.ChucVus.FirstOrDefault(x => x.CVID == _chucvuID);
chucvu.CVTen = _ten;
db.SaveChanges();
db.Dispose();
}
public void Delete(int _dongsanID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DongSan dongsan = db.DongSans.FirstOrDefault(x => x.DSID == _dongsanID);
db.DongSans.Remove(dongsan);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _donviID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DonVi donvi = db.DonVis.FirstOrDefault(x => x.DVID == _donviID);
db.DonVis.Remove(donvi);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _accountID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.Account account = db.Accounts.FirstOrDefault(x => x.ACCID == _accountID);
db.Accounts.Remove(account);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _thunhapID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.ThuNhap thunhap = db.ThuNhaps.FirstOrDefault(x => x.TNID == _thunhapID);
db.ThuNhaps.Remove(thunhap);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _thamgiaID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.ThamGiaChinhTriXaHois thamgia = db.ThamGiaChinhTriXaHois.FirstOrDefault(x => x.TGCTXHID == _thamgiaID);
db.ThamGiaChinhTriXaHois.Remove(thamgia);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _trinhdotinhocID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.TrinhDoTinHoc tinhoc = db.TrinhDoTinHocs.FirstOrDefault(x => x.TDTHID == _trinhdotinhocID);
db.TrinhDoTinHocs.Remove(tinhoc);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _taisanID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.TaiSanNuocNgoai taisan = db.TaiSanNuocNgoais.FirstOrDefault(x => x.TSNNID == _taisanID);
db.TaiSanNuocNgoais.Remove(taisan);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _phutrachID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.PhuTrachChamCong phutrach = db.PhuTrachChamCongs.FirstOrDefault(x => x.PTCCID == _phutrachID);
db.PhuTrachChamCongs.Remove(phutrach);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _lamviecID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.LamViec lamviec = db.LamViecs.FirstOrDefault(x => x.LVID == _lamviecID);
db.LamViecs.Remove(lamviec);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _danhhieuID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.PhongTangDanhHieu danhhieu = db.PhongTangDanhHieux.FirstOrDefault(x => x.PTDHID == _danhhieuID);
db.PhongTangDanhHieux.Remove(danhhieu);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _chinhsachID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.ChinhSach chinhsach = db.ChinhSaches.FirstOrDefault(x => x.CSID == _chinhsachID);
db.ChinhSaches.Remove(chinhsach);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _datID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.Dat dat = db.Dats.FirstOrDefault(x => x.DATID == _datID);
db.Dats.Remove(dat);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _quanheID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.QuanHe quanhe = db.QuanHes.FirstOrDefault(x => x.QHID == _quanheID);
db.QuanHes.Remove(quanhe);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _giaitrinhID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.GiaiTrinh giaitrinh = db.GiaiTrinhs.FirstOrDefault(x => x.GTID == _giaitrinhID);
db.GiaiTrinhs.Remove(giaitrinh);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _danhgiaID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DanhGiaVienChuc danhgia = db.DanhGiaVienChucs.FirstOrDefault(x => x.DGVCID == _danhgiaID);
db.DanhGiaVienChucs.Remove(danhgia);
db.SaveChanges();
db.Dispose();
}
public void Delete(int _kekhaiconID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.KeKhaiCon con = db.KeKhaiCons.FirstOrDefault(x => x.KKCID == _kekhaiconID);
db.KeKhaiCons.Remove(con);
db.SaveChanges();
db.Dispose();
}