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