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