public void Update(DAL.KEHOACH_DAOTAO kehoach)
{
DAL.KEHOACH_DAOTAO kh = GetKeHoachDaoTaoByID(kehoach.MA);
kh.LYDO_DAOTAO = kehoach.LYDO_DAOTAO;
kh.KINHPHI_THUCTE = kehoach.KINHPHI_THUCTE;
kh.KINHPHI_NHANVIEN_DONG = kehoach.KINHPHI_NHANVIEN_DONG;
kh.BATDAU_DANGKY = kehoach.BATDAU_DANGKY;
kh.DEN_NGAY = kehoach.DEN_NGAY;
kh.DIA_DIEM_DAOTAO = kehoach.DIA_DIEM_DAOTAO;
kh.DOITUONG_DAOTAO = kehoach.DOITUONG_DAOTAO;
kh.GHI_CHU = kehoach.GHI_CHU;
kh.HETHAN_DANGKY = kehoach.HETHAN_DANGKY;
kh.KINHPHI_CTY_HOTRO = kehoach.KINHPHI_CTY_HOTRO;
kh.KINHPHI_DUKIEN = kehoach.KINHPHI_DUKIEN;
kh.KINHPHI_NHANVIEN_DONG = kehoach.KINHPHI_NHANVIEN_DONG;
kh.KINHPHI_THUCTE = kehoach.KINHPHI_THUCTE;
kh.MA_CHUNGCHI = kehoach.MA_CHUNGCHI;
kh.MA_DONVIPHUTRACHDAOTAO = kehoach.MA_DONVIPHUTRACHDAOTAO;
kh.MA_LYDODAOTAO = kehoach.MA_LYDODAOTAO;
kh.MUCDICH_KHOAHOC = kehoach.MUCDICH_KHOAHOC;
kh.NOIDUNG_DAOTAO = kehoach.NOIDUNG_DAOTAO;
kh.SOLUONG_HOCVIEN = kehoach.SOLUONG_HOCVIEN;
kh.TEN_DONVIPHUTRACHDAOTAO = kehoach.TEN_DONVIPHUTRACHDAOTAO;
kh.TEN_KHOA_HOC = kehoach.TEN_KHOA_HOC;
kh.THOI_GIAN_DAOTAO = kehoach.THOI_GIAN_DAOTAO;
kh.TRANG_THAI = kehoach.TRANG_THAI;
kh.TU_NGAY = kehoach.TU_NGAY;
Save();
}
void ucChooseEmployee1_AfterClickAcceptButton(object sender, EventArgs e)
{
SelectedRowCollection SelectedRow = sender as SelectedRowCollection;
DaoTaoController dtController = new DaoTaoController();
DAL.KEHOACH_DAOTAO khdt = dtController.GetKeHoachDaoTaoByID(hdfRecordID.Text);
foreach (var item in SelectedRow)
{
try
{
DAL.DM_NhanVienThamGiaDaoTao nv = new DAL.DM_NhanVienThamGiaDaoTao()
{
MaCanBo = item.RecordID,
DaThamGia = true,
CreatedBy = CurrentUser.ID,
CreatedDate = DateTime.Now,
MaKhoaDaoTao = hdfRecordID.Text,
SoTienCongTyHoTro = khdt.KINHPHI_CTY_HOTRO,
SoTienNVDong = khdt.KINHPHI_NHANVIEN_DONG
};
dtController.InsertNhanVienThamgiaHoc(nv);
grp_nhanVienThamGiaDaoTao.Reload();
}
catch
{
}
}
}
/// <summary>
/// Xóa kế hoạch đào tạo
///
/// Trước khi xóa kế hoạch đào tạo cần phải xóa các thông tin ràng buộc
/// bao gồm Giáo viên đào tạo, Các khoản chi phí, Nhân viên tham gia đào tạo
/// </summary>
/// <param name="id">Mã kế hoạch đào tạo</param>
public void DeleteKeHoachDaoTaoByID(string id)
{
DAL.KEHOACH_DAOTAO kehoach = dataContext.KEHOACH_DAOTAOs.FirstOrDefault(t => t.MA == id);
// Xóa bỏ ràng buộc giáo viên - khóa đào tạo (trong bảng GiaoVien_KhoaDaoTao)
DeleteGiaoVien_KhoaDaoTaoByMaKhoaHoc(id);
// Xóa các khoản chi phí
DeleteChiPhiByFrkey(id);
// Xóa nhân viên tham gia đào tạo
DeleteNhanVienThamGiaDaoTaoByMaKhoaHoc(id);
if (kehoach != null)
{
dataContext.KEHOACH_DAOTAOs.DeleteOnSubmit(kehoach);
Save();
}
}
protected void btnCapNhat_Click(object sender, DirectEventArgs e)
{
try
{
DaoTaoController daotao = new DaoTaoController();
DAL.KEHOACH_DAOTAO kehoach = new DAL.KEHOACH_DAOTAO()
{
MA = frm_txtMaKhoaDaoTao.Text.Trim(),
TEN_KHOA_HOC = frm_txtTenKhoaDaoTao.Text.Trim(),
MA_CHUNGCHI = frm_cbChungChi.SelectedItem.Value,
CreatedBy = CurrentUser.ID,
CreatedDate = DateTime.Now,
MA_DONVI = new UserController().GetDonViByUserID(CurrentUser.ID).FirstOrDefault().MA_DONVI,
DIA_DIEM_DAOTAO = frm_txtDiaDiemDaoTao.Text,
THOI_GIAN_DAOTAO = frm_txtThoiLuongDaoTao.Text,
DOITUONG_DAOTAO = frm_txtDoiTuongDaoTao.Text,
LYDO_DAOTAO = frm_txtLyDoDaoTao.Text,
NOIDUNG_DAOTAO = frm_txtNoiDungDaoTao.Text,
GHI_CHU = frm_txtGHiChi.Text,
MA_DONVIPHUTRACHDAOTAO = frm_cbPhuTrachDaoTao.SelectedItem.Value,
TEN_DONVIPHUTRACHDAOTAO = frm_cbPhuTrachDaoTao.SelectedItem.Text,
TRANG_THAI = frm_cbTrangThai.SelectedItem.Value
};
if (!frm_dfBatDauDaoTao.Text.Contains("01/01/0001"))
{
kehoach.TU_NGAY = frm_dfBatDauDaoTao.SelectedDate;
}
if (!frm_dfKetThucDaoTao.Text.Contains("01/01/0001"))
{
kehoach.DEN_NGAY = frm_dfKetThucDaoTao.SelectedDate;
}
if (!frm_dfBatDauDangKy.Text.Contains("01/01/0001"))
{
kehoach.BATDAU_DANGKY = frm_dfBatDauDangKy.SelectedDate;
}
if (!frm_dfHetHanDangKy.Text.Contains("01/01/0001"))
{
kehoach.HETHAN_DANGKY = frm_dfHetHanDangKy.SelectedDate;
}
// kehoach.MA_CHUNGCHI = frm_cbChungChi.SelectedItem.Value;
if (!string.IsNullOrEmpty(frm_txtSoLuongHocVien.Text))
{
kehoach.SOLUONG_HOCVIEN = int.Parse(frm_txtSoLuongHocVien.Text);
}
if (!string.IsNullOrEmpty(frm_txtKinhPhiDuKien.Text))
{
kehoach.KINHPHI_DUKIEN = decimal.Parse(frm_txtKinhPhiDuKien.Text);
}
if (!string.IsNullOrEmpty(frm_txtKinhPhiThucTe.Text))
{
kehoach.KINHPHI_THUCTE = decimal.Parse(frm_txtKinhPhiThucTe.Text);
}
if (!string.IsNullOrEmpty(frm_txtCongTyHoTro.Text))
{
kehoach.KINHPHI_CTY_HOTRO = decimal.Parse(frm_txtCongTyHoTro.Text);
}
if (!string.IsNullOrEmpty(frm_txtNhanVienDongGop.Text))
{
kehoach.KINHPHI_NHANVIEN_DONG = decimal.Parse(frm_txtNhanVienDongGop.Text);
}
NhatkyTruycapInfo accessDiary = new NhatkyTruycapInfo()
{
CHUCNANG = "Thêm kế hoạch đào tạo",
MOTA = "Thêm kế hoạch đào tạo",
IsError = false,
USERNAME = CurrentUser.UserName,
THOIGIAN = DateTime.Now,
MANGHIEPVU = "KEHOACH_DAOTAO",
TENMAY = Util.GetInstance().GetComputerName(Request.UserHostAddress),
IPMAY = Request.UserHostAddress,
THAMCHIEU = "",
};
if (e.ExtraParams["Command"] == "Edit")
{
accessDiary.CHUCNANG = "Sửa kế hoạch đào tạo";
accessDiary.MOTA = "Mã kế hoạch đào tạo được sửa là : " + frm_txtMaKhoaDaoTao.Text;
daotao.Update(kehoach);
}
else
{
daotao.Insert(kehoach);
}
new SoftCore.AccessHistory.AccessHistoryController().AddAccessHistory(accessDiary);
if (e.ExtraParams["Close"] == "True")
{
wdAddWindow.Hide();
}
RM.RegisterClientScriptBlock("zz", "#{Store1}.reload();");
}
catch (Exception ex)
{
if (ex.Message.Contains(" Cannot insert duplicate key in object "))
{
Dialog.ShowError(GlobalResourceManager.GetInstance().GetErrorMessageValue("DuplicateMaDaoTao"));
}
else
{
Dialog.ShowError("Lối xảy ra " + ex.Message);
}
}
}
public void Delete(string p)
{
DAL.KEHOACH_DAOTAO kehoach = GetByID(p);
dataContext.KEHOACH_DAOTAOs.DeleteOnSubmit(kehoach);
Save();
}
public string Insert(DAL.KEHOACH_DAOTAO daotao)
{
dataContext.KEHOACH_DAOTAOs.InsertOnSubmit(daotao);
Save();
return(daotao.MA);
}
public void ChuyenTrangThai(string Ma, string TrangThai)
{
DAL.KEHOACH_DAOTAO daotao = GetByID(Ma);
daotao.TRANG_THAI = TrangThai;
Save();
}
/// <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();
}
}
}
