public static DTO_PRO_SYLL update_PRO_SYLL(AppEntities db, DTO_PRO_SYLL item, string Username)
{
var dbitem = db.tbl_PRO_SYLL.Find(item.ID);
if (dbitem == null)
{
dbitem = new tbl_PRO_SYLL();
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.IDDetai = item.IDDetai;
dbitem.IDNhanSu = item.IDNhanSu;
db.tbl_PRO_SYLL.Add(dbitem);
}
var objHRM_SYLL = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.FirstOrDefault(c => c.IDNhanSu == item.IDNhanSu);
if (objHRM_SYLL != null)
{
int id = dbitem.ID;
CopyHelper copyHelper = new CopyHelper();
copyHelper.Copy(objHRM_SYLL, dbitem);
dbitem.ID = id;
}
dbitem.IDDetai = item.IDDetai;
dbitem.IDNhanSu = item.IDNhanSu;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == dbitem.IDDetai);
if (detai != null)
{
if (detai.IDNCV == dbitem.IDNhanSu)
{
BS_HelperReference.PRO_SYLL_NCV_Update(db, dbitem.IDDetai, dbitem.IDNhanSu);
}
}
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_SYLL", DateTime.Now, Username);
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
return(item);
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("save_PRO_SYLL", e);
return(null);
}
}
public static DTO_PRO_SYLL save_PRO_SYLL(AppEntities db, DTO_PRO_SYLL item, string Username)
{
var dbitem = db.tbl_PRO_SYLL.Find(item.ID);
if (dbitem == null)
{
dbitem = new tbl_PRO_SYLL();
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
db.tbl_PRO_SYLL.Add(dbitem);
}
dbitem.IDDetai = item.IDDetai;
dbitem.IDNhanSu = item.IDNhanSu;
dbitem.HoTen = item.HoTen;
dbitem.GioiTinh = item.GioiTinh;
dbitem.NgaySinh = item.NgaySinh;
dbitem.DiaChi = item.DiaChi;
dbitem.DienThoaiCQ = item.DienThoaiCQ;
dbitem.DienThoaiNhaRieng = item.DienThoaiNhaRieng;
dbitem.Mobile = item.Mobile;
dbitem.Email = item.Email;
dbitem.ChucVu = item.ChucVu;
dbitem.CoQuanLamViec = item.CoQuanLamViec;
dbitem.ThuTruongCoQuan = item.ThuTruongCoQuan;
dbitem.DienThoaiThuTruong = item.DienThoaiThuTruong;
dbitem.DiaChiCoQuan = item.DiaChiCoQuan;
dbitem.NgayKy_ChuKy = item.NgayKy_ChuKy;
dbitem.NgayKy_Nam = item.NgayKy_Nam;
dbitem.NgayKy_Ngay = item.NgayKy_Ngay;
dbitem.NgayKy_Thang = item.NgayKy_Thang;
if (item.ListKinhNghiem != null)
{
dbitem.JSON_KinhNghiem = JsonConvert.SerializeObject(item.ListKinhNghiem);
}
else
{
dbitem.JSON_KinhNghiem = string.Empty;
}
if (item.ListTrinhDoChuyenMon != null)
{
dbitem.JSON_TrinhDoChuyenMon = JsonConvert.SerializeObject(item.ListTrinhDoChuyenMon);
}
else
{
dbitem.JSON_TrinhDoChuyenMon = string.Empty;
}
dbitem.FormConfig = item.FormConfig;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_SYLL", DateTime.Now, Username);
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == dbitem.IDDetai);
if (detai != null)
{
if (detai.IDNCV == dbitem.IDNhanSu)
{
BS_HelperReference.PRO_SYLL_NCV_Update(db, dbitem.IDDetai, dbitem.IDNhanSu);
}
}
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
return(item);
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("save_PRO_SYLL", e);
return(null);
}
}
public static DTO_CUS_HRM_STAFF_NhanSu_LLKH save_CUS_HRM_STAFF_NhanSu_LLKH(AppEntities db, DTO_CUS_HRM_STAFF_NhanSu_LLKH item, string Username)
{
var dbitem = db.tbl_CUS_HRM_STAFF_NhanSu_LLKH.Find(item.ID);
if (dbitem == null)
{
dbitem = new tbl_CUS_HRM_STAFF_NhanSu_LLKH();
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
db.tbl_CUS_HRM_STAFF_NhanSu_LLKH.Add(dbitem);
}
dbitem.IDNhanSu = item.IDNhanSu;
dbitem.ImageURL = item.ImageURL;
dbitem.HoTen = item.HoTen;
dbitem.GioiTinh = item.GioiTinh;
dbitem.NgaySinh = item.NgaySinh;
dbitem.TruongVien = item.TruongVien;
dbitem.PhongKhoa = item.PhongKhoa;
dbitem.ChucVu = item.ChucVu;
dbitem.CMND = item.CMND;
dbitem.CMND_NgayCap = item.CMND_NgayCap;
dbitem.CMND_NoiCap = item.CMND_NoiCap;
dbitem.HocVi = item.HocVi;
dbitem.HocHam = item.HocHam;
dbitem.DiaChi_CoQuan = item.DiaChi_CoQuan;
dbitem.DiaChi_CaNhan = item.DiaChi_CaNhan;
dbitem.DienThoai_CoQuan = item.DienThoai_CoQuan;
dbitem.DienThoai_CaNhan = item.DienThoai_CaNhan;
dbitem.Email_CoQuan = item.Email_CoQuan;
dbitem.Email_CaNhan = item.Email_CaNhan;
dbitem.TaiKhoan_MST = item.TaiKhoan_MST;
dbitem.TaiKhoan_STK = item.TaiKhoan_STK;
dbitem.TaiKhoan_NganHang = item.TaiKhoan_NganHang;
dbitem.LinhVucChuyenMon = item.LinhVucChuyenMon;
dbitem.LinhVuc = item.LinhVuc;
dbitem.ChuyenNganh = item.ChuyenNganh;
dbitem.HuongNghienCuu = item.HuongNghienCuu;
dbitem.HoatDongKhac = item.HoatDongKhac;
dbitem.NgayKy_Ngay = item.NgayKy_Ngay;
dbitem.NgayKy_Thang = item.NgayKy_Thang;
dbitem.NgayKy_Nam = item.NgayKy_Nam;
dbitem.NgayKy_ChuKy = item.NgayKy_ChuKy;
dbitem.NamPhongHocHam = item.NamPhongHocHam;
dbitem.HocViThacSy = item.HocViThacSy;
dbitem.NamHocViThacSy = item.NamHocViThacSy;
dbitem.HocViTienSy = item.HocViTienSy;
dbitem.NamHocViTienSy = item.NamHocViTienSy;
if (item.ListNgoaiNgu != null)
{
dbitem.JSON_NgoaiNgu = JsonConvert.SerializeObject(item.ListNgoaiNgu);
}
else
{
dbitem.JSON_NgoaiNgu = string.Empty;
}
if (item.ListThoiGianCongTac != null)
{
dbitem.JSON_ThoiGianCongTac = JsonConvert.SerializeObject(item.ListThoiGianCongTac);
}
else
{
dbitem.JSON_ThoiGianCongTac = string.Empty;
}
if (item.ListQuaTrinhDaoTao != null)
{
dbitem.JSON_QuaTrinhDaoTao = JsonConvert.SerializeObject(item.ListQuaTrinhDaoTao);
}
else
{
dbitem.JSON_QuaTrinhDaoTao = string.Empty;
}
if (item.ListDeTai != null)
{
dbitem.JSON_DeTai = JsonConvert.SerializeObject(item.ListDeTai);
}
else
{
dbitem.JSON_DeTai = string.Empty;
}
if (item.ListHuongDan != null)
{
dbitem.JSON_HuongDan = JsonConvert.SerializeObject(item.ListHuongDan);
}
else
{
dbitem.JSON_HuongDan = string.Empty;
}
if (item.ListSachQuocTe != null)
{
dbitem.JSON_CongTrinhDaCongBo_SachQuocTe = JsonConvert.SerializeObject(item.ListSachQuocTe);
}
else
{
dbitem.JSON_CongTrinhDaCongBo_SachQuocTe = string.Empty;
}
if (item.ListSachTrongNuoc != null)
{
dbitem.JSON_CongTrinhDaCongBo_SachTrongNuoc = JsonConvert.SerializeObject(item.ListSachTrongNuoc);
}
else
{
dbitem.JSON_CongTrinhDaCongBo_SachTrongNuoc = string.Empty;
}
if (item.ListTapChiQuocTe != null)
{
dbitem.JSON_CongTrinhDaCongBo_TapChiQuocTe = JsonConvert.SerializeObject(item.ListTapChiQuocTe);
}
else
{
dbitem.JSON_CongTrinhDaCongBo_TapChiQuocTe = string.Empty;
}
if (item.ListTapChiTrongNuoc != null)
{
dbitem.JSON_CongTrinhDaCongBo_TapChiTrongNuoc = JsonConvert.SerializeObject(item.ListTapChiTrongNuoc);
}
else
{
dbitem.JSON_CongTrinhDaCongBo_TapChiTrongNuoc = string.Empty;
}
if (item.ListHoiNghiQuocTe != null)
{
dbitem.JSON_CongTrinhDaCongBo_HoiNghiQuocTe = JsonConvert.SerializeObject(item.ListHoiNghiQuocTe);
}
else
{
dbitem.JSON_CongTrinhDaCongBo_HoiNghiQuocTe = string.Empty;
}
if (item.ListHoiNghiTrongNuoc != null)
{
dbitem.JSON_CongTrinhDaCongBo_HoiNghiTrongNuoc = JsonConvert.SerializeObject(item.ListHoiNghiTrongNuoc);
}
else
{
dbitem.JSON_CongTrinhDaCongBo_HoiNghiTrongNuoc = string.Empty;
}
if (item.ListGiaiThuong != null)
{
dbitem.JSON_GiaiThuong = JsonConvert.SerializeObject(item.ListGiaiThuong);
}
else
{
dbitem.JSON_GiaiThuong = string.Empty;
}
if (item.ListHiepHoiKhoaHoc != null)
{
dbitem.JSON_ThongTinKhac_HiepHoiKhoaHoc = JsonConvert.SerializeObject(item.ListHiepHoiKhoaHoc);
}
else
{
dbitem.JSON_ThongTinKhac_HiepHoiKhoaHoc = string.Empty;
}
if (item.ListTruongDaiHoc != null)
{
dbitem.JSON_ThongTinKhac_TruongDaiHoc = JsonConvert.SerializeObject(item.ListTruongDaiHoc);
}
else
{
dbitem.JSON_ThongTinKhac_TruongDaiHoc = string.Empty;
}
dbitem.FormConfig = item.FormConfig;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
var syll = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.FirstOrDefault(c => c.IDNhanSu == dbitem.IDNhanSu);
if (syll == null)
{
var objSYLL = BS_CUS_HRM_STAFF_NhanSu_SYLL.get_CUS_HRM_STAFF_NhanSu_SYLLByNhanSu(db, dbitem.IDNhanSu);
if (objSYLL.ID == 0)
{
BS_CUS_HRM_STAFF_NhanSu_SYLL.save_CUS_HRM_STAFF_NhanSu_SYLL(db, objSYLL, Username);
}
}
else
{
BS_HelperReference.STAFF_LLKH_Update(db, dbitem.IDNhanSu);
}
BS_CUS_Version.update_CUS_Version(db, null, "DTO_CUS_HRM_STAFF_NhanSu_LLKH", DateTime.Now, Username);
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
return(item);
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("save_CUS_HRM_STAFF_NhanSu_LLKH", e);
return(null);
}
}
