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