public static DTO_CUS_HRM_STAFF_NhanSu_SYLL get_CUS_HRM_STAFF_NhanSu_SYLLByNhanSu(AppEntities db, int nhanSuId)
{
var query = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.Where(d => d.IDNhanSu == nhanSuId && d.IsDeleted == false).Select(s => new DTO_CUS_HRM_STAFF_NhanSu_SYLL
{
ID = s.ID,
IDNhanSu = s.IDNhanSu,
HoTen = s.HoTen,
GioiTinh = s.GioiTinh,
NgaySinh = s.NgaySinh,
DiaChi = s.DiaChi,
DienThoaiCQ = s.DienThoaiCQ,
Mobile = s.Mobile,
Email = s.Email,
ChucVu = s.ChucVu,
CoQuanLamViec = s.CoQuanLamViec,
ThuTruongCoQuan = s.ThuTruongCoQuan,
DienThoaiThuTruong = s.DienThoaiThuTruong,
DiaChiCoQuan = s.DiaChiCoQuan,
JSON_TrinhDoChuyenMon = s.JSON_TrinhDoChuyenMon,
JSON_KinhNghiem = s.JSON_KinhNghiem,
HTML = s.HTML,
FormConfig = s.FormConfig,
IsDisabled = s.IsDisabled,
IsDeleted = s.IsDeleted,
CreatedDate = s.CreatedDate,
CreatedBy = s.CreatedBy,
ModifiedDate = s.ModifiedDate,
ModifiedBy = s.ModifiedBy,
NgayKy_ChuKy = s.NgayKy_ChuKy,
NgayKy_Nam = s.NgayKy_Nam,
NgayKy_Ngay = s.NgayKy_Ngay,
NgayKy_Thang = s.NgayKy_Thang,
JSON_HocVi = s.JSON_HocVi,
DienThoaiNhaRieng = s.DienThoaiNhaRieng,
IsCNDT = s.tbl_CUS_HRM_STAFF_NhanSu.IsCNDT == true
}).FirstOrDefault();
if (query == null)
{
//New
query = new DTO_CUS_HRM_STAFF_NhanSu_SYLL
{
IDNhanSu = nhanSuId
};
var nhansu = db.tbl_CUS_HRM_STAFF_NhanSu.FirstOrDefault(c => c.ID == nhanSuId);
query.IsCNDT = nhansu != null && nhansu.IsCNDT == true;
query.ListTrinhDoChuyenMon = new List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon>();
var objHocVi1 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi2 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi3 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objLL = db.tbl_CUS_HRM_STAFF_NhanSu_LLKH.FirstOrDefault(c => c.IDNhanSu == nhanSuId);
if (objLL != null)
{
query.HoTen = objLL.HoTen;
query.NgaySinh = objLL.NgaySinh;
query.Email = objLL.Email_CaNhan;
query.DiaChi = objLL.DiaChi_CaNhan;
query.Mobile = objLL.DienThoai_CaNhan;
query.GioiTinh = objLL.GioiTinh;
query.ChucVu = objLL.ChucVu;
query.DiaChiCoQuan = objLL.DiaChi_CoQuan;
query.CoQuanLamViec = "Bệnh viện Mỹ Đức";
query.DienThoaiCQ = objLL.DienThoai_CoQuan;
objHocVi1.HocVi = objLL.HocViThacSy;
objHocVi1.NamNhanBang = objLL.NamHocViThacSy;
objHocVi2.HocVi = objLL.HocViTienSy;
objHocVi2.NamNhanBang = objLL.NamHocViTienSy;
objHocVi3.HocVi = objLL.HocHam;
objHocVi3.NamNhanBang = objLL.NamPhongHocHam;
}
query.ListTrinhDoChuyenMon.Add(objHocVi1);
query.ListTrinhDoChuyenMon.Add(objHocVi2);
query.ListTrinhDoChuyenMon.Add(objHocVi3);
query.ListKinhNghiem = new List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_KinhNghiem>()
{
new DTO_CUS_HRM_STAFF_NhanSu_SYLL_KinhNghiem
{
}
};
}
else
{
//Edit
if (!string.IsNullOrWhiteSpace(query.JSON_KinhNghiem))
{
query.ListKinhNghiem = JsonConvert.DeserializeObject <List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_KinhNghiem> >(query.JSON_KinhNghiem);
}
if (!string.IsNullOrWhiteSpace(query.JSON_TrinhDoChuyenMon))
{
query.ListTrinhDoChuyenMon = JsonConvert.DeserializeObject <List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon> >(query.JSON_TrinhDoChuyenMon);
}
}
return(query);
}
public static DTO_CUS_HRM_STAFF_NhanSu_SYLL save_CUS_HRM_STAFF_NhanSu_SYLL(AppEntities db, DTO_CUS_HRM_STAFF_NhanSu_SYLL item, string Username)
{
var dbitem = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.Find(item.ID);
if (dbitem == null)
{
dbitem = new tbl_CUS_HRM_STAFF_NhanSu_SYLL();
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.HoTen = item.HoTen;
dbitem.GioiTinh = item.GioiTinh;
dbitem.NgaySinh = item.NgaySinh;
dbitem.DiaChi = item.DiaChi;
dbitem.DienThoaiCQ = item.DienThoaiCQ;
dbitem.Mobile = item.Mobile;
dbitem.Email = item.Email;
dbitem.ChucVu = item.ChucVu;
dbitem.CoQuanLamViec = item.CoQuanLamViec;
dbitem.DiaChiCoQuan = item.DiaChiCoQuan;
dbitem.DienThoaiNhaRieng = item.DienThoaiNhaRieng;
if (item.ListTrinhDoChuyenMon != null)
{
dbitem.JSON_TrinhDoChuyenMon = JsonConvert.SerializeObject(item.ListTrinhDoChuyenMon);
}
else
{
dbitem.JSON_TrinhDoChuyenMon = string.Empty;
}
db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.Add(dbitem);
}
else
{
var objHocVi1 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi2 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi3 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objLL = db.tbl_CUS_HRM_STAFF_NhanSu_LLKH.FirstOrDefault(c => c.IDNhanSu == item.IDNhanSu);
if (objLL != null)
{
objHocVi1.HocVi = objLL.HocViThacSy;
objHocVi1.NamNhanBang = objLL.NamHocViThacSy;
objHocVi2.HocVi = objLL.HocViTienSy;
objHocVi2.NamNhanBang = objLL.NamHocViTienSy;
objHocVi3.HocVi = objLL.HocHam;
objHocVi3.NamNhanBang = objLL.NamPhongHocHam;
}
var ListTrinhDoChuyenMon = new List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon>();
ListTrinhDoChuyenMon.Add(objHocVi1);
ListTrinhDoChuyenMon.Add(objHocVi2);
ListTrinhDoChuyenMon.Add(objHocVi3);
if (item.ListTrinhDoChuyenMon != null && item.ListTrinhDoChuyenMon.Count == 3)
{
int count = 1;
foreach (var itemTrinhDoChuyenMon in item.ListTrinhDoChuyenMon)
{
if (count == 1)
{
objHocVi1.HocHam = itemTrinhDoChuyenMon.HocHam;
objHocVi1.ChuyenNganhDaoTao = itemTrinhDoChuyenMon.ChuyenNganhDaoTao;
}
if (count == 2)
{
objHocVi2.HocHam = itemTrinhDoChuyenMon.HocHam;
objHocVi2.ChuyenNganhDaoTao = itemTrinhDoChuyenMon.ChuyenNganhDaoTao;
}
if (count == 3)
{
objHocVi3.HocHam = itemTrinhDoChuyenMon.HocHam;
objHocVi3.ChuyenNganhDaoTao = itemTrinhDoChuyenMon.ChuyenNganhDaoTao;
}
count++;
}
}
dbitem.JSON_TrinhDoChuyenMon = Newtonsoft.Json.JsonConvert.SerializeObject(ListTrinhDoChuyenMon);
}
dbitem.IDNhanSu = item.IDNhanSu;
dbitem.ThuTruongCoQuan = item.ThuTruongCoQuan;
dbitem.DienThoaiThuTruong = item.DienThoaiThuTruong;
dbitem.DienThoaiNhaRieng = item.DienThoaiNhaRieng;
dbitem.NgayKy_ChuKy = item.NgayKy_ChuKy;
dbitem.NgayKy_Ngay = item.NgayKy_Ngay;
dbitem.NgayKy_Thang = item.NgayKy_Thang;
dbitem.NgayKy_Nam = item.NgayKy_Nam;
if (item.ListKinhNghiem != null)
{
dbitem.JSON_KinhNghiem = JsonConvert.SerializeObject(item.ListKinhNghiem);
}
else
{
dbitem.JSON_KinhNghiem = 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_CUS_HRM_STAFF_NhanSu_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_CUS_HRM_STAFF_NhanSu_SYLL", e);
return(null);
}
}
public static void PRO_LLKH_CN_Update(AppEntities db, int IDDeTai, int IDNhanSu)
{
var llkh = db.tbl_PRO_LLKH.FirstOrDefault(c => c.IDDetai == IDDeTai && c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (llkh != null)
{
var tmdt = db.tbl_PRO_ThuyetMinhDeTai.FirstOrDefault(c => c.IDDeTai == IDDeTai && c.IsDeleted == false);
if (tmdt != null)
{
tmdt.A6_HoTen = (!string.IsNullOrEmpty(llkh.HocHam) ? llkh.HocHam + ", " : "") + (!string.IsNullOrEmpty(llkh.HocViThacSy) ? llkh.HocViThacSy + ", " : "") + (!string.IsNullOrEmpty(llkh.HocViTienSy) ? llkh.HocViTienSy + ", " : "") + llkh.HoTen;
tmdt.A6_NgaySinh = llkh.NgaySinh;
tmdt.A6_GioiTinh = llkh.GioiTinh;
tmdt.A6_CMND = llkh.CMND;
tmdt.A6_NgayCap = llkh.CMND_NgayCap;
tmdt.A6_NoiCap = llkh.CMND_NoiCap;
tmdt.A6_MST = llkh.TaiKhoan_MST;
tmdt.A6_STK = llkh.TaiKhoan_STK;
tmdt.A6_NganHang = llkh.TaiKhoan_NganHang;
tmdt.A6_DiaChiCoQuan = llkh.DiaChi_CoQuan;
tmdt.A6_DienThoai = llkh.DienThoai_CaNhan;
tmdt.A6_Email = llkh.Email_CaNhan;
try
{
var chunhiem = Newtonsoft.Json.JsonConvert.DeserializeObject <DTO_PRO_ThuyetMinhDeTai_NhanLucNghienCuu>(tmdt.A9_JSON_NhanLucNghienCuu_ChuNhiemDeTai);
chunhiem.HoTen = tmdt.A6_HoTen;
chunhiem.DonVi = llkh.TruongVien;
}
catch { }
}
var dgdd = db.tbl_PRO_DonXinDanhGiaDaoDuc.FirstOrDefault(c => c.IDDeTai == IDDeTai && c.IsDeleted == false);
if (dgdd != null)
{
if (llkh != null)
{
dgdd.HoTenChuNhiem = llkh.HoTen;
dgdd.DiaChi = llkh.DiaChi_CaNhan;
dgdd.DienThoai = llkh.DienThoai_CaNhan;
}
}
try
{
var syll = db.tbl_PRO_SYLL.FirstOrDefault(c => c.IDDetai == IDDeTai && c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (syll != null)
{
List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon> ListTrinhDoChuyenMon = new List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon>();
var objHocVi1 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi2 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi3 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
objHocVi1.HocVi = llkh.HocViThacSy;
objHocVi1.NamNhanBang = llkh.NamHocViThacSy;
objHocVi2.HocVi = llkh.HocViTienSy;
objHocVi2.NamNhanBang = llkh.NamHocViTienSy;
objHocVi3.HocVi = llkh.HocHam;
objHocVi3.NamNhanBang = llkh.NamPhongHocHam;
var myData = Newtonsoft.Json.JsonConvert.DeserializeObject <List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon> >(syll.JSON_TrinhDoChuyenMon);
if (myData != null)
{
if (myData.Count > 0)
{
var hocvi = myData.ToArray()[0];
if (hocvi != null)
{
objHocVi1.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
}
}
if (myData.Count > 1)
{
var hocvi = myData.ToArray()[1];
if (hocvi != null)
{
objHocVi2.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
}
}
if (myData.Count > 2)
{
var hocvi = myData.ToArray()[2];
if (hocvi != null)
{
objHocVi3.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
}
}
}
ListTrinhDoChuyenMon.Add(objHocVi1);
ListTrinhDoChuyenMon.Add(objHocVi2);
ListTrinhDoChuyenMon.Add(objHocVi3);
syll.JSON_TrinhDoChuyenMon = Newtonsoft.Json.JsonConvert.SerializeObject(ListTrinhDoChuyenMon);
}
}
catch { }
db.SaveChanges();
}
}
public static void STAFF_LLKH_Update(AppEntities db, int IDNhanSu)
{
var objLL = db.tbl_CUS_HRM_STAFF_NhanSu_LLKH.FirstOrDefault(c => c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (objLL != null)
{
var query = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.FirstOrDefault(c => c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (query != null)
{
query.HoTen = objLL.HoTen;
query.NgaySinh = objLL.NgaySinh;
query.Email = objLL.Email_CaNhan;
query.DiaChi = objLL.DiaChi_CaNhan;
query.Mobile = objLL.DienThoai_CaNhan;
query.GioiTinh = objLL.GioiTinh;
query.ChucVu = objLL.ChucVu;
query.DiaChiCoQuan = objLL.DiaChi_CoQuan;
query.CoQuanLamViec = "Bệnh viện Mỹ Đức";
query.DienThoaiCQ = objLL.DienThoai_CoQuan;
try
{
List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon> ListTrinhDoChuyenMon = new List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon>();
var objHocVi1 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi2 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi3 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
objHocVi1.HocVi = objLL.HocViThacSy;
objHocVi1.NamNhanBang = objLL.NamHocViThacSy;
objHocVi2.HocVi = objLL.HocViTienSy;
objHocVi2.NamNhanBang = objLL.NamHocViTienSy;
objHocVi3.HocVi = objLL.HocHam;
objHocVi3.NamNhanBang = objLL.NamPhongHocHam;
var myData = Newtonsoft.Json.JsonConvert.DeserializeObject <List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon> >(query.JSON_TrinhDoChuyenMon);
if (myData != null)
{
if (myData.Count > 0)
{
var hocvi = myData.ToArray()[0];
if (hocvi != null)
{
objHocVi1.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
objHocVi1.HocHam = hocvi.HocHam;
}
}
if (myData.Count > 1)
{
var hocvi = myData.ToArray()[1];
if (hocvi != null)
{
objHocVi2.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
objHocVi2.HocHam = hocvi.HocHam;
}
}
if (myData.Count > 2)
{
var hocvi = myData.ToArray()[2];
if (hocvi != null)
{
objHocVi3.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
objHocVi3.HocHam = hocvi.HocHam;
}
}
}
ListTrinhDoChuyenMon.Add(objHocVi1);
ListTrinhDoChuyenMon.Add(objHocVi2);
ListTrinhDoChuyenMon.Add(objHocVi3);
query.JSON_TrinhDoChuyenMon = Newtonsoft.Json.JsonConvert.SerializeObject(ListTrinhDoChuyenMon);
}
catch { }
}
db.SaveChanges();
}
}
public static void PRO_LLKH_NCV_Update(AppEntities db, int IDDeTai, int IDNhanSu)
{
var llkh = db.tbl_PRO_LLKH.FirstOrDefault(c => c.IDDetai == IDDeTai && c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (llkh != null)
{
var xxdd = db.tbl_PRO_BangKiemLuaChonQuyTrinhXXDD.FirstOrDefault(c => c.IDDeTai == IDDeTai && c.IsDeleted == false);
if (xxdd != null)
{
xxdd.PhanHai_NCVChinh_KhoaPhong = llkh.PhongKhoa;
}
try
{
var syll = db.tbl_PRO_SYLL.FirstOrDefault(c => c.IDDetai == IDDeTai && c.IDNhanSu == IDNhanSu && c.IsDeleted == false);
if (syll != null)
{
List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon> ListTrinhDoChuyenMon = new List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon>();
var objHocVi1 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi2 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
var objHocVi3 = new DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon();
objHocVi1.HocVi = llkh.HocViThacSy;
objHocVi1.NamNhanBang = llkh.NamHocViThacSy;
objHocVi2.HocVi = llkh.HocViTienSy;
objHocVi2.NamNhanBang = llkh.NamHocViTienSy;
objHocVi3.HocVi = llkh.HocHam;
objHocVi3.NamNhanBang = llkh.NamPhongHocHam;
var myData = Newtonsoft.Json.JsonConvert.DeserializeObject <List <DTO_CUS_HRM_STAFF_NhanSu_SYLL_TrinhDoChuyenMon> >(syll.JSON_TrinhDoChuyenMon);
if (myData != null)
{
if (myData.Count > 0)
{
var hocvi = myData.ToArray()[0];
if (hocvi != null)
{
objHocVi1.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
}
}
if (myData.Count > 1)
{
var hocvi = myData.ToArray()[1];
if (hocvi != null)
{
objHocVi2.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
}
}
if (myData.Count > 2)
{
var hocvi = myData.ToArray()[2];
if (hocvi != null)
{
objHocVi3.ChuyenNganhDaoTao = hocvi.ChuyenNganhDaoTao;
}
}
}
ListTrinhDoChuyenMon.Add(objHocVi1);
ListTrinhDoChuyenMon.Add(objHocVi2);
ListTrinhDoChuyenMon.Add(objHocVi3);
syll.JSON_TrinhDoChuyenMon = Newtonsoft.Json.JsonConvert.SerializeObject(ListTrinhDoChuyenMon);
}
}
catch { }
db.SaveChanges();
}
}
