// create exeption // POST: / public ActionResult Create_Exeption(int NLD_id) { var hdNLD = db.hdNLD.Where(nl => nl.id == NLD_id).FirstOrDefault(); var hdcantao = new hdCanTaoHDLD(); hdcantao.Hoten = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().HotenNLD; hdcantao.GioiTinh_id = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Gioitinh_id; hdcantao.Quoctich_id = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Quoctich_id; hdcantao.Ngaysinh = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Ngaysinh; hdcantao.Noisinh = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Noisinh; hdcantao.Nghenghiep_id = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Nghenghiep_id; hdcantao.Diachithuongtru = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Diachithuongtru; hdcantao.soCMND = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().soCMND; hdcantao.cmndNgaycap = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().cmndNgaycap; hdcantao.cmndNoicap = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().cmndNoicap; hdcantao.VitriCT_id = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Chucdanh_id; hdcantao.Lydo = "Trường hợp ngoại lệ"; hdcantao.Donvi_id = hdNLD.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Donvi_id; hdcantao.MaNV = hdNLD.NV_id; hdcantao.MaTD = hdNLD.TD_id; db.hdCanTaoHDLD.Add(hdcantao); db.SaveChanges(); return(RedirectToAction("TruyenID", "ThemMoiHD", new { DSNLDCanTaoHD_id = hdcantao.id })); }
public ActionResult DeleteConfirmed(int id) { hdCanTaoHDLD hdcantaohdld = db.hdCanTaoHDLD.Find(id); db.hdCanTaoHDLD.Remove(hdcantaohdld); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /DSNLDCanTaoHD/Delete/5 public ActionResult Delete(int id = 0) { hdCanTaoHDLD hdcantaohdld = db.hdCanTaoHDLD.Find(id); if (hdcantaohdld == null) { return(HttpNotFound()); } return(View(hdcantaohdld)); }
public ActionResult Create(hdCanTaoHDLD hdcantaohdld) { if (ModelState.IsValid) { db.hdCanTaoHDLD.Add(hdcantaohdld); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hdcantaohdld)); }
// // GET: /TuyenDung/ public ActionResult Index() { var listCD_id = new List <int>(); foreach (var item in db0.dmChucDanhChuyenMon.ToList()) { if (item.tenChucDanhChuyenMon == "Trợ giảng 1" || item.tenChucDanhChuyenMon == "Trợ giảng 2" || item.tenChucDanhChuyenMon == "Giảng viên" || item.tenChucDanhChuyenMon == "Giảng viên chính" || item.tenChucDanhChuyenMon == "Giảng viên cao cấp" || item.tenChucDanhChuyenMon == "Giáo viên" || item.tenChucDanhChuyenMon == "Giáo viên thực hành") { listCD_id.Add(item.id); } } foreach (var item in db.tdTTUngCuVien.ToList()) { if (item.hidden == false && item.KetQuaTuyenDung == true) { bool isHad = false; for (int i = 0; i < listCD_id.Count; i++) { if (item.tdThongTinUngTuyens.FirstOrDefault().ViTriUngTuyen_id == listCD_id[i]) { isHad = true; } } if (isHad == false) { var hdnldct = new hdCanTaoHDLD(); hdnldct.MaTD = item.id.ToString(); hdnldct.Hoten = item.HoVaTen; hdnldct.GioiTinh_id = item.GioiTinh_id; hdnldct.Quoctich_id = item.QuocTich_id; hdnldct.Ngaysinh = item.NgaySinh; int?NoiSinh_id = item.tdNoiSinhs.FirstOrDefault().TinhThanh_id; try { hdnldct.Noisinh = db0.dmTinhThanh.Where(tt => tt.id == NoiSinh_id).FirstOrDefault().tenTinhThanh; } catch { } int? ttTinhThanh_id = item.tdThongTinLienHes.FirstOrDefault().tdHoKhauThuongTrus.FirstOrDefault().hkTinhThanh_id; int? ttQuanHuyen_id = item.tdThongTinLienHes.FirstOrDefault().tdHoKhauThuongTrus.FirstOrDefault().hkQuanHuyen_id; int? ttPhuongXa_id = item.tdThongTinLienHes.FirstOrDefault().tdHoKhauThuongTrus.FirstOrDefault().hkPhuongXa_id; string ttTinhThanh = ""; string ttQuanHuyen = ""; string ttPhuongXa = ""; try { ttTinhThanh = db0.dmTinhThanh.Where(tt => tt.id == ttTinhThanh_id).FirstOrDefault().tenTinhThanh; } catch { } try { ttQuanHuyen = db0.dmQuanHuyen.Where(qh => qh.id == ttQuanHuyen_id).FirstOrDefault().tenQuanHuyen; } catch { } try { ttPhuongXa = db0.dmPhuongXa.Where(px => px.id == ttPhuongXa_id).FirstOrDefault().tenPhuongXa; } catch { } if (ttPhuongXa != "") { hdnldct.Diachithuongtru = ttPhuongXa; } if (ttQuanHuyen != "") { hdnldct.Diachithuongtru = hdnldct.Diachithuongtru + ", " + ttQuanHuyen; } if (ttTinhThanh != null) { hdnldct.Diachithuongtru = hdnldct.Diachithuongtru + ", " + ttTinhThanh; } hdnldct.soCMND = item.tdTheDinhDanhs.FirstOrDefault().SoThe; hdnldct.cmndNgaycap = item.tdTheDinhDanhs.FirstOrDefault().NgayCap; hdnldct.cmndNoicap = item.tdTheDinhDanhs.FirstOrDefault().NoiCap_id; hdnldct.VitriCT_id = item.tdThongTinUngTuyens.FirstOrDefault().ViTriUngTuyen_id; hdnldct.Donvi_id = item.tdThongTinUngTuyens.FirstOrDefault().DonViUngTuyen_id; hdnldct.Lydo = "Thử việc"; db.hdCanTaoHDLD.Add(hdnldct); db.SaveChanges(); var newTTUngCV = new tdTTUngCuVien(); newTTUngCV.id = item.id; newTTUngCV.HoVaTen = item.HoVaTen; newTTUngCV.GioiTinh_id = item.GioiTinh_id; newTTUngCV.NgaySinh = item.NgaySinh; newTTUngCV.TTHonNhan = item.TTHonNhan; newTTUngCV.TPGiaDinh_id = item.TPGiaDinh_id; newTTUngCV.DanToc_id = item.DanToc_id; newTTUngCV.TonGiao_id = item.TonGiao_id; newTTUngCV.QuocTich_id = item.QuocTich_id; newTTUngCV.hidden = true; newTTUngCV.KetQuaTuyenDung = item.KetQuaTuyenDung; db.Entry(item).CurrentValues.SetValues(newTTUngCV); db.SaveChanges(); } } } var tdttungcuviens = db.tdTTUngCuVien; ViewBag.DB0 = db0; return(View()); }
// // GET: /HDNguoiLaoDong/ public ActionResult Index() { int count = 0; foreach (var item in db.hdNLD.ToList()) { if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().NgayhetHL != null) { System.TimeSpan diffDate = (DateTime)item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().NgayhetHL - DateTime.Today; if ((diffDate.Days <= db.hdCauHinh.FirstOrDefault().NgayHDTV&& item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD == "Thử việc") || (diffDate.Days <= db.hdCauHinh.FirstOrDefault().NgayHDCT&& item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD == "Hợp đồng dài hạn") || (diffDate.Days <= db.hdCauHinh.FirstOrDefault().NgayHDCT&& item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD == "Hợp đồng cơ hữu")) { if (diffDate.Days > 0) { count = count + 1; } if (diffDate.Days <= 0) { if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD != "Thử việc") { if (db.hdCanTaoHDLD.Count() <= 0) { var hdcantao = new hdCanTaoHDLD(); hdcantao.Hoten = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().HotenNLD; hdcantao.GioiTinh_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Gioitinh_id; hdcantao.Quoctich_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Quoctich_id; hdcantao.Ngaysinh = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Ngaysinh; hdcantao.Noisinh = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Noisinh; hdcantao.Nghenghiep_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Nghenghiep_id; hdcantao.Diachithuongtru = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Diachithuongtru; hdcantao.soCMND = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().soCMND; hdcantao.cmndNgaycap = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().cmndNgaycap; hdcantao.cmndNoicap = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().cmndNoicap; hdcantao.VitriCT_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Chucdanh_id; if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD == "Hợp đồng dài hạn") { hdcantao.Lydo = "Hợp đồng dài hạn hết hạn"; } if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD == "Hợp đồng cơ hữu") { hdcantao.Lydo = "Hợp đồng cơ hữu hết hạn"; } hdcantao.Donvi_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Donvi_id; hdcantao.MaNV = item.NV_id; hdcantao.MaTD = item.TD_id; db.hdCanTaoHDLD.Add(hdcantao); db.SaveChanges(); } else { bool isHas = false; foreach (var it in db.hdCanTaoHDLD.ToList()) { if (it.MaNV != null) { if (item.NV_id == it.MaNV) { isHas = true; } } if (it.MaTD != null) { if (item.TD_id == it.MaTD) { isHas = true; } } } if (isHas == false) { var hdcantao = new hdCanTaoHDLD(); hdcantao.Hoten = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().HotenNLD; hdcantao.GioiTinh_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Gioitinh_id; hdcantao.Quoctich_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Quoctich_id; hdcantao.Ngaysinh = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Ngaysinh; hdcantao.Noisinh = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Noisinh; hdcantao.Nghenghiep_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Nghenghiep_id; hdcantao.Diachithuongtru = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Diachithuongtru; hdcantao.soCMND = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().soCMND; hdcantao.cmndNgaycap = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().cmndNgaycap; hdcantao.cmndNoicap = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().cmndNoicap; hdcantao.VitriCT_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Chucdanh_id; if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD == "Hợp đồng dài hạn") { hdcantao.Lydo = "Hợp đồng dài hạn hết hạn"; } if (item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().LoaiHD == "Hợp đồng cơ hữu") { hdcantao.Lydo = "Hợp đồng cơ hữu hết hạn"; } hdcantao.Donvi_id = item.hdChiTietHDLDs.OrderByDescending(ct => ct.NgayhetHL).FirstOrDefault().Donvi_id; hdcantao.MaNV = item.NV_id; hdcantao.MaTD = item.TD_id; db.hdCanTaoHDLD.Add(hdcantao); db.SaveChanges(); } } } } } } } if (db.hdCanTaoHDLD.Count() > 0) { TempData["MessageNLDCT"] = db.hdCanTaoHDLD.Count(); } if (count > 0) { TempData["MessageHDHH"] = count; } //check nghi viec var listNVNghiViec = new List <string>(); foreach (var item in db0.NhanVien.ToList()) { if (item.ngayNghiViec != null) { listNVNghiViec.Add(item.MaNV); } } foreach (var item in db.hdNLD.ToList()) { for (int i = 0; i < listNVNghiViec.Count; i++) { if (item.NV_id == listNVNghiViec[i]) { var hdnld = new hdNLD(); hdnld.id = item.id; hdnld.NV_id = item.NV_id; hdnld.TD_id = item.TD_id; hdnld.hidden = true; db.Entry(item).CurrentValues.SetValues(hdnld); db.SaveChanges(); } } } //check nhan vien moi if (db0.dsNhanVienMoi.ToList().Count > 0) { var listnvmoi_id = new List <int>(); foreach (var item in db0.dsNhanVienMoi.ToList()) { if (String.IsNullOrEmpty(item.HoVaTen)) { continue; } var hdnldct = new hdCanTaoHDLD(); hdnldct.MaNV = item.MaNV; hdnldct.MaTD = item.MaTV; hdnldct.Hoten = item.HoVaTen ?? ""; hdnldct.GioiTinh_id = item.GioiTinh_id; hdnldct.Quoctich_id = item.QuocTich_id; hdnldct.Ngaysinh = item.NgaySinh; hdnldct.Noisinh = item.NoiSinh_tenTinhThanh; if (item.DiaChi_tenPhuongXa != null) { hdnldct.Diachithuongtru = item.DiaChi_tenPhuongXa; } if (item.DiaChi_tenQuanHuyen != null) { hdnldct.Diachithuongtru = hdnldct.Diachithuongtru + ", " + item.DiaChi_tenQuanHuyen; } if (item.DiaChi_tenTinhThanh != null) { hdnldct.Diachithuongtru = hdnldct.Diachithuongtru + ", " + item.DiaChi_tenTinhThanh; } hdnldct.soCMND = item.CMND_SoThe; hdnldct.cmndNgaycap = item.CMND_NgayCap; hdnldct.cmndNoicap = item.CMND_NoiCap_id; hdnldct.VitriCT_id = item.ChucDanhChucVu_id; hdnldct.Donvi_id = item.DonVi_id; hdnldct.Nghenghiep_id = item.NgheNghiep_id; hdnldct.Lydo = "Nhân viên mới"; db.hdCanTaoHDLD.Add(hdnldct); db.SaveChanges(); HRM.Services.QLTTNhanSu.ketThucNhanVienMoi(new int[] { item.nid }); } } var aaaa = db.hdNLD.Where(ld => ld.hidden == false).ToList(); return(View(db.hdNLD.Where(ld => ld.hidden == false).ToList())); }