/// <summary> /// Xóa nhân viên tham gia đào tạo /// </summary> /// <param name="recordID"></param> public void DeleteNhanVien(int recordID) { DAL.DM_NhanVienThamGiaDaoTao nv = dataContext.DM_NhanVienThamGiaDaoTaos.FirstOrDefault(t => t.ID == recordID); if (nv != null) { dataContext.DM_NhanVienThamGiaDaoTaos.DeleteOnSubmit(nv); Save(); } }
public void UpdateNhanVien(NhanVienThamGiaDaoTaoInfo item) { DAL.DM_NhanVienThamGiaDaoTao nv = dataContext.DM_NhanVienThamGiaDaoTaos.FirstOrDefault(t => t.ID == item.ID); nv.KetQua = item.KetQua; nv.NhanXetCuaGiaoVien = item.NhanXetCuaGiaoVien; nv.SoDiem = item.Diem; nv.SoTienCongTyHoTro = item.SoTienCongTyDong; nv.SoTienNVDong = item.SoTienNhanVienDong; nv.DaThamGia = item.DaThamGia; Save(); }
public void InsertNhanVienThamgiaHoc(DAL.DM_NhanVienThamGiaDaoTao nv) { try { dataContext.DM_NhanVienThamGiaDaoTaos.InsertOnSubmit(nv); Save(); } catch (Exception ex) { throw ex; } }
/// <summary> /// Nhân đôi khóa đào tạo /// </summary> /// <param name="OldID">Khóa đào tạo cũ</param> /// <param name="NewID">Khóa đào tạo mới</param> /// <param name="createdUserID">Người tạo</param> /// <param name="copyGiaoVien"></param> /// <param name="copyChiPhi"></param> /// <param name="copyNhanVienThamGiaDaoTao"></param> public void DuplicateRecord(string OldID, string NewID, int createdUserID, bool copyGiaoVien, bool copyChiPhi, bool copyNhanVienThamGiaDaoTao) { DAL.KEHOACH_DAOTAO old = GetByID(OldID); DAL.KEHOACH_DAOTAO _new = new DAL.KEHOACH_DAOTAO() { TEN_KHOA_HOC = old.TEN_KHOA_HOC, TRANG_THAI = old.TRANG_THAI, TEN_DONVIPHUTRACHDAOTAO = old.TEN_DONVIPHUTRACHDAOTAO, MA_DONVIPHUTRACHDAOTAO = old.MA_DONVIPHUTRACHDAOTAO, GHI_CHU = old.GHI_CHU, NOIDUNG_DAOTAO = old.NOIDUNG_DAOTAO, LYDO_DAOTAO = old.LYDO_DAOTAO, DOITUONG_DAOTAO = old.DOITUONG_DAOTAO, THOI_GIAN_DAOTAO = old.THOI_GIAN_DAOTAO, SOLUONG_HOCVIEN = old.SOLUONG_HOCVIEN, DIA_DIEM_DAOTAO = old.DIA_DIEM_DAOTAO, BATDAU_DANGKY = old.BATDAU_DANGKY, CreatedDate = DateTime.Now, DEN_NGAY = old.DEN_NGAY, HETHAN_DANGKY = old.HETHAN_DANGKY, KINHPHI_CTY_HOTRO = old.KINHPHI_CTY_HOTRO, KINHPHI_DUKIEN = old.KINHPHI_DUKIEN, KINHPHI_NHANVIEN_DONG = old.KINHPHI_NHANVIEN_DONG, KINHPHI_THUCTE = old.KINHPHI_THUCTE, MA = NewID, MA_DONVI = old.MA_DONVI, MA_CHUNGCHI = old.MA_CHUNGCHI, MA_LYDODAOTAO = old.MA_LYDODAOTAO, MUCDICH_KHOAHOC = old.MUCDICH_KHOAHOC, TU_NGAY = old.TU_NGAY, CreatedBy = createdUserID }; dataContext.KEHOACH_DAOTAOs.InsertOnSubmit(_new); Save(); if (copyGiaoVien) { var gvdt = dataContext.GiaoVien_KhoaDaoTaos.Where(t => t.MaKhoaHoc == OldID); foreach (var item in gvdt) { DAL.GiaoVien_KhoaDaoTao gv = new DAL.GiaoVien_KhoaDaoTao() { CreatedBy = createdUserID, CreatedDate = DateTime.Now, MaGiaoVien = item.MaGiaoVien, MaKhoaHoc = NewID }; dataContext.GiaoVien_KhoaDaoTaos.InsertOnSubmit(gv); Save(); } } if (copyChiPhi) { var chiPhi = dataContext.DM_CacKhoanChiChoDaoTaos.Where(t => t.FR_KEY == OldID); foreach (var item in chiPhi) { DAL.DM_CacKhoanChiChoDaoTao cp = new DAL.DM_CacKhoanChiChoDaoTao() { FR_KEY = NewID, CreatedBy = createdUserID, CreatedDate = DateTime.Now, NguonChi = item.NguonChi, SoTien = item.SoTien, TenChiPhi = item.TenChiPhi }; dataContext.DM_CacKhoanChiChoDaoTaos.InsertOnSubmit(cp); Save(); } } if (copyNhanVienThamGiaDaoTao) { var nv = dataContext.DM_NhanVienThamGiaDaoTaos.Where(t => t.MaKhoaDaoTao == OldID); foreach (var item in nv) { DAL.DM_NhanVienThamGiaDaoTao nhanVien = new DAL.DM_NhanVienThamGiaDaoTao() { CreatedBy = createdUserID, CreatedDate = DateTime.Now, MaKhoaDaoTao = NewID, DaThamGia = item.DaThamGia, MaCanBo = item.MaCanBo, SoTienCongTyHoTro = item.SoTienCongTyHoTro, SoTienNVDong = item.SoTienNVDong }; dataContext.DM_NhanVienThamGiaDaoTaos.InsertOnSubmit(nhanVien); Save(); } } }