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