//
// GET: /TuyenDung/Delete/5
public ActionResult Delete(int id = 0)
{
tdTTUngCuVien tdttungcuvien = db.tdTTUngCuVien.Find(id);
if (tdttungcuvien == null)
{
return(HttpNotFound());
}
return(View(tdttungcuvien));
}
public ActionResult DeleteConfirmed(int id)
{
tdKiemTraH tdkiemtrah = db.tdKiemTraH.Where(kt => kt.UngVien_id == id).First();
tdNoiSinh tdnoisinh = db.tdNoiSinh.Where(ns => ns.UngVien_id == id).First();
tdTheDinhDanh tdthedinhdanh = db.tdTheDinhDanh.Where(dd => dd.UngVien_id == id).First();
tdThongTinUngTuyen tdthongtinungtuyen = db.tdThongTinUngTuyen.Where(ut => ut.UngVien_id == id).First();
tdThongTinLienHe tdthongtinlienhe = db.tdThongTinLienHe.Where(lh => lh.UngVien_id == id).First();
tdHoKhauThuongTru tdhokhauthuongtru = db.tdHoKhauThuongTru.Where(tt => tt.TTLienHe_id == tdthongtinlienhe.id).First();
tdDiaChiLienLac tddiachilienlac = db.tdDiaChiLienLac.Where(ll => ll.TTLienHe_id == tdthongtinlienhe.id).First();
tdTTUngCuVien tdttungcuvien = db.tdTTUngCuVien.Find(id);
db.tdKiemTraH.Remove(tdkiemtrah);
db.tdNoiSinh.Remove(tdnoisinh);
db.tdTheDinhDanh.Remove(tdthedinhdanh);
db.tdThongTinUngTuyen.Remove(tdthongtinungtuyen);
db.tdHoKhauThuongTru.Remove(tdhokhauthuongtru);
db.tdDiaChiLienLac.Remove(tddiachilienlac);
db.tdThongTinLienHe.Remove(tdthongtinlienhe);
try
{
tdXemVaXepLichHen tdquanlylh = db.tdXemVaXepLichHen.Where(qllh => qllh.UngCuVien_id == id).First();
db.tdXemVaXepLichHen.Remove(tdquanlylh);
}
catch
{
}
try
{
var lisqttd = new List <tdQuaTrinhTuyenDung>();
lisqttd = db.tdQuaTrinhTuyenDung.Where(qttd => qttd.UngVien_id == id).ToList();
foreach (var item in lisqttd)
{
db.tdQuaTrinhTuyenDung.Remove(item);
}
}
catch
{
}
try
{
var listdbc = new List <tdBangCap>();
listdbc = db.tdBangCap.Where(qttd => qttd.UngVien_id == id).ToList();
foreach (var item in listdbc)
{
db.tdBangCap.Remove(item);
}
}
catch
{
}
db.tdTTUngCuVien.Remove(tdttungcuvien);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /ThongTinChung/Edit/5
public ActionResult Edit(int UV_id = 0)
{
tdTTUngCuVien tdttungcuvien = db.tdTTUngCuVien.Find(UV_id);
if (tdttungcuvien == null)
{
return(HttpNotFound());
}
ViewBag.UngVien_id = UV_id;
return(View(tdttungcuvien));
}
//
// GET: /ThongTinChung/Details/5
public ActionResult Details(int id = 0)
{
tdTTUngCuVien tdttungcuvien = db.tdTTUngCuVien.Find(id);
if (tdttungcuvien == null)
{
return(HttpNotFound());
}
ViewBag.UngVien_id = id;
ViewBag.UngVien = db.tdTTUngCuVien.Find(id);
return(View(tdttungcuvien));
}
public ActionResult UpdateKQTuyenDung(FormCollection form)
{
var id = int.Parse(form[0]);
var kq = form[1];
var tdttungcuvien = db.tdTTUngCuVien.Find(id);
var kqtd = new Nullable <bool>();
if (kq == "Trúng tuyển")
{
kqtd = true;
}
if (kq == "Không trúng tuyển")
{
kqtd = false;
}
if (kq == "Chưa trúng tuyển")
{
kqtd = null;
}
var newData = new tdTTUngCuVien {
id = id, HoVaTen = tdttungcuvien.HoVaTen, GioiTinh_id = tdttungcuvien.GioiTinh_id, NgaySinh = tdttungcuvien.NgaySinh, TTHonNhan = tdttungcuvien.TTHonNhan, TPGiaDinh_id = tdttungcuvien.TPGiaDinh_id, DanToc_id = tdttungcuvien.DanToc_id, TonGiao_id = tdttungcuvien.TonGiao_id, QuocTich_id = tdttungcuvien.QuocTich_id, hidden = tdttungcuvien.hidden, KetQuaTuyenDung = kqtd
};
db.Entry(tdttungcuvien).CurrentValues.SetValues(newData);
db.SaveChanges();
if (tdttungcuvien.KetQuaTuyenDung == true)
{
/*
* if ((db0.dmChucDanhChuyenMon.Find(tdttungcuvien.tdThongTinUngTuyens.FirstOrDefault().ViTriUngTuyen_id).dmChucDanh ?? new dmChucDanh()).maChucDanh == "NV") //chỉnh sửa khi thay đổi db
* {
* try
* {
* HRM.Services.QLTTNhanSu.themQuanLyThuViec("TV" + id, tdttungcuvien.HoVaTen, Convert.ToDateTime(tdttungcuvien.tdThongTinUngTuyens.FirstOrDefault().NgayBatDauLamViec), tdttungcuvien.tdThongTinUngTuyens.FirstOrDefault().DonViUngTuyen_id, tdttungcuvien.tdThongTinUngTuyens.FirstOrDefault().ViTriUngTuyen_id);
* }
* catch
* {
* HRM.Services.QLTTNhanSu.themQuanLyThuViec("TV" + id, tdttungcuvien.HoVaTen, Convert.ToDateTime("01/01/1990"), tdttungcuvien.tdThongTinUngTuyens.FirstOrDefault().DonViUngTuyen_id, tdttungcuvien.tdThongTinUngTuyens.FirstOrDefault().ViTriUngTuyen_id);
* }
* }
*/
//if ((db0.dmChucDanhChuyenMon.Find(tdttungcuvien.tdThongTinUngTuyens.FirstOrDefault().ViTriUngTuyen_id).dmChucDanh ?? new dmChucDanh()).maChucDanh == "GV")
// return RedirectToAction("CreateGV", new { UV_id = id });
}
return(RedirectToAction("Index"));
}
//
// 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());
}
public ActionResult Create(tdTTUngCuVien tdttungcuvien, tdTheDinhDanh tdthedinhdanh, tdNoiSinh tdnoisinh, tdThongTinLienHe tdthongtinlienhe)
{
if (ModelState.IsValid)
{
db.tdTTUngCuVien.Add(tdttungcuvien);
db.SaveChanges();
// create the dinh danh
var ddmodel = new tdTheDinhDanh()
{
UngVien_id = tdttungcuvien.id, LoaiThe_id = tdthedinhdanh.LoaiThe_id, SoThe = tdthedinhdanh.SoThe, NgayCap = tdthedinhdanh.NgayCap, NoiCap_id = tdthedinhdanh.NoiCap_id, NgayHetHan = tdthedinhdanh.NgayHetHan
};
db.tdTheDinhDanh.Add(ddmodel);
db.SaveChanges();
// create noi sinh
//var nsmodel = new tdNoiSinh() { UngVien_id = tdttungcuvien.id, QuocGia_id = tdnoisinh.QuocGia_id, TinhThanh_id = tdnoisinh.TinhThanh_id};
tdnoisinh.UngVien_id = tdttungcuvien.id;
db.tdNoiSinh.Add(tdnoisinh);
db.SaveChanges();
// create kiem tra hs
var hsmodel = new tdKiemTraH()
{
UngVien_id = tdttungcuvien.id, DonXinViec = false, SoYeuLyLich = false, TheDinhDanh = false, SoHoKhau = false, GiayKhamSucKhoe = false, BangCapBangDiem = false, Hinh = false, GiayToKhac = false
};
db.tdKiemTraH.Add(hsmodel);
db.SaveChanges();
//// create bang cap
//var bcmodel = new tdBangCap() { UngVien_id = tdttungcuvien.id};
//db.tdBangCap.Add(bcmodel);
//db.SaveChanges();
// create thong tin lien he
//var lhmodel = new tdThongTinLienHe() { UngVien_id = tdttungcuvien.id};
tdthongtinlienhe.UngVien_id = tdttungcuvien.id;
db.tdThongTinLienHe.Add(tdthongtinlienhe);
db.SaveChanges();
// create dia chi thuong tru
var lhttmodel = new tdHoKhauThuongTru()
{
TTLienHe_id = tdthongtinlienhe.id
};
db.tdHoKhauThuongTru.Add(lhttmodel);
// create dia chi lien lac
var lhllmodel = new tdDiaChiLienLac()
{
TTLienHe_id = tdthongtinlienhe.id
};
db.tdDiaChiLienLac.Add(lhllmodel);
db.SaveChanges();
// create thong tin ung tuyen
var utmodel = new tdThongTinUngTuyen()
{
UngVien_id = tdttungcuvien.id
};
db.tdThongTinUngTuyen.Add(utmodel);
db.SaveChanges();
//var qttdmodel = new tdQuaTrinhTuyenDung() { UngVien_id = tdttungcuvien.id };
//db.tdQuaTrinhTuyenDung.Add(qttdmodel);
//db.SaveChanges();
//var qllhmodel = new tdXemVaXepLichHen() { UngCuVien_id = tdttungcuvien.id, DaBaoChoUngCuVien = false};
//db.tdXemVaXepLichHen.Add(qllhmodel);
//db.SaveChanges();
//return RedirectToAction("Create","TuyenDung", new { tab = "ThongTinBangCap", UV_id = tdttungcuvien.id });
return(RedirectToAction("Details", "TuyenDung", new { tab = "ThongTinBangCap", nat = "Edit", id = tdttungcuvien.id }));
}
return(View(tdttungcuvien));
}
public ActionResult Edit(tdTTUngCuVien tdttungcuvien, tdNoiSinh tdnoisinh, tdTheDinhDanh tdthedinhdanh, tdBangCap tdbangcap)
{
try
{
// edit thong tin chung
db.Entry(tdttungcuvien).State = EntityState.Modified;
db.SaveChanges();
// edit noi sinh
var nssub = tdnoisinh;
var nsold = db.tdNoiSinh.Where(ns => ns.UngVien_id == tdttungcuvien.id).First();
tdnoisinh = new tdNoiSinh {
id = nsold.id, UngVien_id = tdttungcuvien.id, QuocGia_id = nssub.QuocGia_id, TinhThanh_id = nssub.TinhThanh_id
};
db.Entry(nsold).CurrentValues.SetValues(tdnoisinh);
db.Entry(nsold).State = EntityState.Modified;
db.SaveChanges();
// edit the dinh danh
var sub = tdthedinhdanh;
var old = db.tdTheDinhDanh.Where(dd => dd.UngVien_id == tdttungcuvien.id).First();
tdthedinhdanh = new tdTheDinhDanh {
id = old.id, UngVien_id = tdttungcuvien.id, LoaiThe_id = sub.LoaiThe_id, SoThe = sub.SoThe, NgayCap = sub.NgayCap, NoiCap_id = sub.NoiCap_id, NgayHetHan = sub.NgayHetHan
};
db.Entry(old).CurrentValues.SetValues(tdthedinhdanh);
db.Entry(old).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "TuyenDung", new { tab = "ThongTinChung", nat = "Edit", id = tdttungcuvien.id }));
}
catch
{
if (Request.Form[0] == "")
{
var newtdbc = new tdBangCap {
UngVien_id = tdbangcap.UngVien_id
};
db.SaveChanges();
return(RedirectToAction("Details", "TuyenDung", new { tab = "ThongTinChung", nat = "Edit", id = tdbangcap.UngVien_id }));
}
else
{
tdbangcap.id = int.Parse(Request.Form[0]);
try
{
tdbangcap.TrinhDo_id = int.Parse(Request.Form[2]);
}
catch
{
tdbangcap.TrinhDo_id = null;
}
try
{
tdbangcap.ChuyenNganh_id = int.Parse(Request.Form[3]);
}
catch
{
tdbangcap.ChuyenNganh_id = null;
}
tdbangcap.NoiDaoTao = Request.Form[4];
try
{
tdbangcap.NamTotNghiep = int.Parse(Request.Form[5]);
}
catch
{
tdbangcap.NamTotNghiep = null;
}
try
{
tdbangcap.XepLoai_id = int.Parse(Request.Form[6]);
}
catch
{
tdbangcap.XepLoai_id = null;
}
db.Entry(tdbangcap).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "TuyenDung", new { tab = "ThongTinChung", nat = "Edit", id = tdbangcap.UngVien_id }));
}
}
return(View(tdttungcuvien));
}
public ActionResult ImportToExcel()
{
if (Request.Form["import"] != null)
{
var listview = new List <tdImportExcel>();
listview = (List <tdImportExcel>)TempData["listImport"];
int countSuccess = 0;
int countFail = 0;
try
{
foreach (var dReader in listview)
{
countFail++;
var HoVaTen = dReader.HoVaTen;
var gttempt = dReader.GioiTinh;
var GioiTinh = db0.dmGioiTinh.Where(gt => gt.tenGioiTinh.ToLower() == gttempt.ToLower()).First().id;
var NgaySinh = DateTime.Parse(dReader.NgaySinh);
var nstempt = dReader.NoiSinh;
var NoiSinh = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(nstempt.ToLower())).First().id;
var loaithetempt = dReader.LoaiTheDinhDanh;
var LoaiTheDD = db.tdLoaiTheDinhDanh.Where(dd => dd.LoaiTheDinhDanh.ToLower() == loaithetempt.ToLower()).First().id;
var SoTheDD = dReader.SoThe;
var noicaptempt = dReader.NoiCap;
var NoiCap = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(noicaptempt.ToLower())).First().id;
var NgayCap = DateTime.Parse(dReader.NgayCap);
var NgayHetHan = new DateTime();
try
{
NgayHetHan = DateTime.Parse(dReader.NgayHetHan);
}
catch
{
}
var DTDiDong = dReader.DTDiDong;
var DTNha = dReader.DTNha;
var Email = dReader.Email;
var DiaChiLienHe = dReader.DiaChiLienHe;
var ViTriUngTuyen = dReader.ViTriUngTuyen;
var dvtempt = dReader.DonViUngTuyen;
var DonViUngTuyen = db0.dmDonVi.Where(dv => dv.tenDonVi.ToLower() == dvtempt.ToLower()).First().id;
var NgayNhanHoSo = DateTime.Parse(dReader.NgayNhanHoSo);
var KetQuaTuyenDung = dReader.KetQuaTuyenDung;
var GhiChu = dReader.GhiChu;
var QuocGia = db0.dmQuocGia.Where(qg => qg.tenQuocGia.ToLower() == "Việt Nam".ToLower()).First().id;
//save thong tin ung vien
var tdttungcuvien = new tdTTUngCuVien {
HoVaTen = HoVaTen, GioiTinh_id = GioiTinh, NgaySinh = NgaySinh, QuocTich_id = QuocGia, KetQuaTuyenDung = KetQuaTuyenDung
};
db.tdTTUngCuVien.Add(tdttungcuvien);
db.SaveChanges();
// get ung vien id
var UngVien_id = db.tdTTUngCuVien.ToList().Last().id;
//save bang cap
foreach (var im in dReader.BangCap)
{
try
{
string[] ttdbangcap = im.Split(",".ToArray());
string trinhdo = ttdbangcap[0];
string chuyennganh = ttdbangcap[1];
string noihoc = ttdbangcap[2];
int? namtn;
try
{
namtn = int.Parse(ttdbangcap[3]);
}
catch
{
namtn = null;
}
string xeploai = ttdbangcap[4];
var TrinhDo_id = db0.dmHocVi.Where(hv => hv.tenHocVi.ToLower() == trinhdo.ToLower()).First().id;
var ChuyenNganh_id = db0.dmChuyenNganh.Where(cn => cn.tenChuyenNganh.ToLower() == chuyennganh.ToLower()).First().id;
var XepLoai_id = db0.dmXepLoaiTotNghiep.Where(tn => tn.tenXepLoaiTotNghiep.ToLower() == xeploai.ToLower()).First().id;
var tdbangcapCrete = new tdBangCap {
UngVien_id = UngVien_id, TrinhDo_id = TrinhDo_id, ChuyenNganh_id = ChuyenNganh_id, NoiDaoTao = noihoc, NamTotNghiep = namtn, XepLoai_id = XepLoai_id, SetDefault = false
};
db.tdBangCap.Add(tdbangcapCrete);
db.SaveChanges();
}
catch
{
}
}
//save noi sinh, the dinh danh, kiem tra du thieu hs, qua trinh tuyendung, quan ly lich hen
var tdnoisinh = new tdNoiSinh {
UngVien_id = UngVien_id, QuocGia_id = QuocGia, TinhThanh_id = NoiSinh
};
db.tdNoiSinh.Add(tdnoisinh);
var tdthedinhdanh = new tdTheDinhDanh {
UngVien_id = UngVien_id, LoaiThe_id = LoaiTheDD, SoThe = SoTheDD, NoiCap_id = NoiCap, NgayCap = NgayCap, NgayHetHan = NgayHetHan
};
db.tdTheDinhDanh.Add(tdthedinhdanh);
var hsmodel = new tdKiemTraH()
{
UngVien_id = UngVien_id, DonXinViec = false, SoYeuLyLich = false, TheDinhDanh = false, SoHoKhau = false, GiayKhamSucKhoe = false, BangCapBangDiem = false, Hinh = false, GiayToKhac = false
};
db.tdKiemTraH.Add(hsmodel);
//var tdqttuyendung = new tdQuaTrinhTuyenDung { UngVien_id = UngVien_id };
//db.tdQuaTrinhTuyenDung.Add(tdqttuyendung);
//var tdqllichhen = new tdXemVaXepLichHen { UngCuVien_id = UngVien_id, DaBaoChoUngCuVien = false };
//db.tdXemVaXepLichHen.Add(tdqllichhen);
db.SaveChanges();
// save tt lien he
var tdttlienhe = new tdThongTinLienHe {
UngVien_id = UngVien_id, DTDiDong1 = DTDiDong, DTNha = DTNha, Email = Email
};
db.tdThongTinLienHe.Add(tdttlienhe);
db.SaveChanges();
// get TT lien he id
var TTLienHe_id = db.tdThongTinLienHe.ToList().Last().id;
//save dia chi lien lac & ho khau thuong tru
string[] ttlienhe = DiaChiLienHe.Split(",".ToArray());
string tend = ttlienhe[0];
string pxa = ttlienhe[1];
string qhu = ttlienhe[2];
string tth = ttlienhe[3];
try
{
var PhuongXa = db0.dmPhuongXa.Where(px => px.tenPhuongXa.ToLower().Contains(pxa.ToLower())).First().id;
var QuanHuyen = db0.dmQuanHuyen.Where(qh => qh.tenQuanHuyen.ToLower().Contains(qhu.ToLower())).First().id;
var TinhThanh = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(tth.ToLower())).First().id;
var tddiachilienlac = new tdDiaChiLienLac {
TTLienHe_id = TTLienHe_id, llQuocGia_id = QuocGia, llTinhThanh_id = TinhThanh, llQuanHuyen_id = QuanHuyen, llPhuongXa_id = PhuongXa, llTenDuong = tend
};
db.tdDiaChiLienLac.Add(tddiachilienlac);
}
catch
{
var tddiachilienlac = new tdDiaChiLienLac {
TTLienHe_id = TTLienHe_id
};
db.tdDiaChiLienLac.Add(tddiachilienlac);
}
var tdhokhauthuongtru = new tdHoKhauThuongTru {
TTLienHe_id = TTLienHe_id
};
db.tdHoKhauThuongTru.Add(tdhokhauthuongtru);
db.SaveChanges();
//save thong tin ung tuyen
var ViTriUngTuyen_id = db0.dmChucDanhChuyenMon.Where(cm => cm.tenChucDanhChuyenMon.ToLower() == ViTriUngTuyen.ToLower()).First().id;
var tdttungtuyen = new tdThongTinUngTuyen {
UngVien_id = UngVien_id, ViTriUngTuyen_id = ViTriUngTuyen_id, DonViUngTuyen_id = DonViUngTuyen, NgayNhanHS = NgayNhanHoSo, GhiChu = GhiChu
};
db.tdThongTinUngTuyen.Add(tdttungtuyen);
db.SaveChanges();
countSuccess++;
}
countFail = countFail;
TempData["Message"] = "Bạn đã import thành công thông tin " + countSuccess + "/" + countFail + " ứng viên";
}
catch
{
if (Request.Files["FileUpload1"].ContentLength > 0)
{
string extension = System.IO.Path.GetExtension(Request.Files["FileUpload1"].FileName);
string path1 = string.Format("{0}/{1}", Server.MapPath("~/Areas/TuyenDung/Contents/UploadedFolder"), Request.Files["FileUpload1"].FileName);
if (System.IO.File.Exists(path1))
{
System.IO.File.Delete(path1);
}
Request.Files["FileUpload1"].SaveAs(path1);
//Create connection string to Excel work book
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path1 + ";Extended Properties=Excel 12.0;Persist Security Info=False";
//Create Connection to Excel work book
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
//Create OleDbCommand to fetch data from Excel
OleDbCommand cmd = new OleDbCommand("Select * from [Sheet1$]", excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
while (dReader.Read())
{
try
{
countFail++;
var HoVaTen = dReader.GetValue(0).ToString();
if (HoVaTen == "")
{
dReader.NextResult();
}
else
{
var gttempt = dReader.GetValue(1).ToString();
var GioiTinh = db0.dmGioiTinh.Where(gt => gt.tenGioiTinh.ToLower() == gttempt.ToLower()).First().id;
var NgaySinh = DateTime.Parse(dReader.GetValue(2).ToString());
var nstempt = dReader.GetValue(3).ToString();
var NoiSinh = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(nstempt.ToLower())).First().id;
var loaithetempt = dReader.GetValue(4).ToString();
var LoaiTheDD = db.tdLoaiTheDinhDanh.Where(dd => dd.LoaiTheDinhDanh.ToLower() == loaithetempt.ToLower()).First().id;
var SoTheDD = dReader.GetValue(5).ToString();
var noicaptempt = dReader.GetValue(6).ToString();
var NoiCap = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(noicaptempt.ToLower())).First().id;
var NgayCap = DateTime.Parse(dReader.GetValue(7).ToString());
DateTime?NgayHetHan = new DateTime();
try
{
NgayHetHan = DateTime.Parse(dReader.GetValue(8).ToString());
}
catch
{
NgayHetHan = null;
}
var DTDiDong = dReader.GetValue(9).ToString();
var DTNha = dReader.GetValue(10).ToString();
var Email = dReader.GetValue(11).ToString();
var DiaChiLienHe = dReader.GetValue(12).ToString();
var BangCapList = new List <string>();
int co = dReader.FieldCount - 18;
int i = 0;
var list = new List <string>();
for (i = 0; i < co; i++)
{
list.Add(dReader.GetValue(13 + i).ToString());
}
BangCapList = list;
var ViTriUngTuyen = dReader.GetValue(13 + i).ToString();
var dvtempt = dReader.GetValue(13 + i + 1).ToString();
var DonViUngTuyen = db0.dmDonVi.Where(dv => dv.tenDonVi.ToLower() == dvtempt.ToLower()).First().id;
var NgayNhanHoSo = DateTime.Parse(dReader.GetValue(13 + i + 2).ToString());
var KetQuaTuyenDung = dReader.GetValue(13 + i + 3).ToString();
var GhiChu = dReader.GetValue(13 + i + 4).ToString();
var QuocGia = db0.dmQuocGia.Where(qg => qg.tenQuocGia.ToLower() == "Việt Nam".ToLower()).First().id;
//save thong tin ung vien
var kqtd = new Nullable <bool>();
if (KetQuaTuyenDung == "Trúng tuyển")
{
kqtd = true;
}
if (KetQuaTuyenDung == "Không trúng tuyển")
{
kqtd = false;
}
if (KetQuaTuyenDung == "Chưa có kết quả")
{
kqtd = null;
}
var tdttungcuvien = new tdTTUngCuVien {
HoVaTen = HoVaTen, GioiTinh_id = GioiTinh, NgaySinh = NgaySinh, QuocTich_id = QuocGia, KetQuaTuyenDung = kqtd
};
db.tdTTUngCuVien.Add(tdttungcuvien);
db.SaveChanges();
// get ung vien id
var UngVien_id = db.tdTTUngCuVien.ToList().Last().id;
// save bang cap
foreach (var im in BangCapList)
{
try
{
string[] ttdbangcap = im.Split(",".ToArray());
string trinhdo = ttdbangcap[0];
string chuyennganh = ttdbangcap[1];
string noihoc = ttdbangcap[2];
int? namtn;
try
{
namtn = int.Parse(ttdbangcap[3]);
}
catch
{
namtn = null;
}
string xeploai = ttdbangcap[4];
var TrinhDo_id = db0.dmHocVi.Where(td => td.tenHocVi.ToLower() == trinhdo.ToLower()).First().id;
var ChuyenNganh_id = db0.dmChuyenNganh.Where(td => td.tenChuyenNganh.ToLower() == chuyennganh.ToLower()).First().id;
var XepLoai_id = db0.dmXepLoaiTotNghiep.Where(td => td.tenXepLoaiTotNghiep.ToLower() == xeploai.ToLower()).First().id;
var tdbangcapCrete = new tdBangCap {
UngVien_id = UngVien_id, TrinhDo_id = TrinhDo_id, ChuyenNganh_id = ChuyenNganh_id, NoiDaoTao = noihoc, NamTotNghiep = namtn, XepLoai_id = XepLoai_id, SetDefault = false
};
db.tdBangCap.Add(tdbangcapCrete);
db.SaveChanges();
}
catch
{
}
}
//save noi sinh, the dinh danh, kiem tra du thieu hs, qua trinh tuyendung, quan ly lich hen
var tdnoisinh = new tdNoiSinh {
UngVien_id = UngVien_id, QuocGia_id = QuocGia, TinhThanh_id = NoiSinh
};
db.tdNoiSinh.Add(tdnoisinh);
var tdthedinhdanh = new tdTheDinhDanh {
UngVien_id = UngVien_id, LoaiThe_id = LoaiTheDD, SoThe = SoTheDD, NoiCap_id = NoiCap, NgayCap = NgayCap, NgayHetHan = NgayHetHan
};
db.tdTheDinhDanh.Add(tdthedinhdanh);
var hsmodel = new tdKiemTraH()
{
UngVien_id = UngVien_id, DonXinViec = false, SoYeuLyLich = false, TheDinhDanh = false, SoHoKhau = false, GiayKhamSucKhoe = false, BangCapBangDiem = false, Hinh = false, GiayToKhac = false
};
db.tdKiemTraH.Add(hsmodel);
//var tdqttuyendung = new tdQuaTrinhTuyenDung { UngVien_id = UngVien_id };
//db.tdQuaTrinhTuyenDung.Add(tdqttuyendung);
//var tdqllichhen = new tdXemVaXepLichHen { UngCuVien_id = UngVien_id, DaBaoChoUngCuVien = false };
//db.tdXemVaXepLichHen.Add(tdqllichhen);
db.SaveChanges();
// save tt lien he
var tdttlienhe = new tdThongTinLienHe {
UngVien_id = UngVien_id, DTDiDong1 = DTDiDong, DTNha = DTNha, Email = Email
};
db.tdThongTinLienHe.Add(tdttlienhe);
db.SaveChanges();
// get TT lien he id
var TTLienHe_id = db.tdThongTinLienHe.ToList().Last().id;
//save dia chi lien lac & ho khau thuong tru
string[] ttlienhe = DiaChiLienHe.Split(",".ToArray());
string tend = ttlienhe[0];
string pxa = ttlienhe[1];
string qhu = ttlienhe[2];
string tth = ttlienhe[3];
try
{
var PhuongXa = db0.dmPhuongXa.Where(px => px.tenPhuongXa.ToLower() == pxa.ToString().ToLower()).First().id;
var QuanHuyen = db0.dmQuanHuyen.Where(qh => qh.tenQuanHuyen.ToLower().Contains(qhu.ToLower())).First().id;
var TinhThanh = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(tth.ToLower())).First().id;
var tddiachilienlac = new tdDiaChiLienLac {
TTLienHe_id = TTLienHe_id, llQuocGia_id = QuocGia, llTinhThanh_id = TinhThanh, llQuanHuyen_id = QuanHuyen, llPhuongXa_id = PhuongXa, llTenDuong = tend
};
db.tdDiaChiLienLac.Add(tddiachilienlac);
}
catch
{
var tddiachilienlac = new tdDiaChiLienLac {
TTLienHe_id = TTLienHe_id
};
db.tdDiaChiLienLac.Add(tddiachilienlac);
}
var tdhokhauthuongtru = new tdHoKhauThuongTru {
TTLienHe_id = TTLienHe_id
};
db.tdHoKhauThuongTru.Add(tdhokhauthuongtru);
db.SaveChanges();
//save thong tin ung tuyen
var ViTriUngTuyen_id = db0.dmChucDanhChuyenMon.Where(cm => cm.tenChucDanhChuyenMon.ToLower() == ViTriUngTuyen.ToLower()).First().id;
var tdttungtuyen = new tdThongTinUngTuyen {
UngVien_id = UngVien_id, ViTriUngTuyen_id = ViTriUngTuyen_id, DonViUngTuyen_id = DonViUngTuyen, NgayNhanHS = NgayNhanHoSo, GhiChu = GhiChu
};
db.tdThongTinUngTuyen.Add(tdttungtuyen);
db.SaveChanges();
countSuccess++;
}
}
catch
{
}
}
excelConnection.Close();
countFail = countFail - 1;
TempData["Message"] = "Bạn đã import thành công thông tin " + countSuccess + "/" + countFail + " ứng viên";
}
}
return(RedirectToAction("Index", "TuyenDung"));
}
else
{
if (Request.Files["FileUpload1"].ContentLength > 0)
{
string extension = System.IO.Path.GetExtension(Request.Files["FileUpload1"].FileName);
string path1 = string.Format("{0}/{1}", Server.MapPath("~/Areas/TuyenDung/Contents/UploadedFolder"), Request.Files["FileUpload1"].FileName);
if (System.IO.File.Exists(path1))
{
System.IO.File.Delete(path1);
}
Request.Files["FileUpload1"].SaveAs(path1);
//Create connection string to Excel work book
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path1 + ";Extended Properties=Excel 12.0;Persist Security Info=False";
//Create Connection to Excel work book
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
//Create OleDbCommand to fetch data from Excel
OleDbCommand cmd = new OleDbCommand("Select * from [Sheet1$]", excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
var listview = new List <tdImportExcel>();
while (dReader.Read())
{
var tduv = new tdImportExcel();
var HoVaTen = dReader.GetValue(0).ToString();
if (HoVaTen == "")
{
dReader.NextResult();
}
else
{
tduv.HoVaTen = HoVaTen;
var gttempt = dReader.GetValue(1).ToString();
var gioitinhtempt = db0.dmGioiTinh.Where(gt => gt.tenGioiTinh.ToLower() == gttempt.ToLower()).First().tenGioiTinh;
tduv.GioiTinh = gioitinhtempt;
tduv.NgaySinh = DateTime.Parse(dReader.GetValue(2).ToString()).ToShortDateString();
var nstempt = dReader.GetValue(3).ToString();
tduv.NoiSinh = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(nstempt.ToLower())).First().tenTinhThanh;
var loaithetempt = dReader.GetValue(4).ToString();
tduv.LoaiTheDinhDanh = db.tdLoaiTheDinhDanh.Where(dd => dd.LoaiTheDinhDanh.ToLower() == loaithetempt.ToLower()).First().LoaiTheDinhDanh;
tduv.SoThe = dReader.GetValue(5).ToString();
var noicaptempt = dReader.GetValue(6).ToString();
tduv.NoiCap = db0.dmTinhThanh.Where(tt => tt.tenTinhThanh.ToLower().Contains(noicaptempt.ToLower())).First().tenTinhThanh;
tduv.NgayCap = DateTime.Parse(dReader.GetValue(7).ToString()).ToShortDateString();
DateTime?NgayHetHan = new DateTime();
try
{
NgayHetHan = DateTime.Parse(dReader.GetValue(8).ToString());
tduv.NgayHetHan = NgayHetHan.Value.ToShortDateString();
}
catch
{
NgayHetHan = null;
}
tduv.DTDiDong = dReader.GetValue(9).ToString();
tduv.DTNha = dReader.GetValue(10).ToString();
tduv.Email = dReader.GetValue(11).ToString();
tduv.DiaChiLienHe = dReader.GetValue(12).ToString();
int co = dReader.FieldCount - 18;
int i = 0;
var list = new List <string>();
for (i = 0; i < co; i++)
{
list.Add(dReader.GetValue(13 + i).ToString());
}
tduv.BangCap = list;
tduv.ViTriUngTuyen = dReader.GetValue(13 + i).ToString();
var dvtempt = dReader.GetValue(13 + i + 1).ToString();
tduv.DonViUngTuyen = db0.dmDonVi.Where(dv => dv.tenDonVi.ToLower() == dvtempt.ToLower()).First().tenDonVi;
tduv.NgayNhanHoSo = DateTime.Parse(dReader.GetValue(13 + i + 2).ToString()).ToShortDateString();
var KetQuaTuyenDung = dReader.GetValue(13 + i + 3).ToString();
if (KetQuaTuyenDung == "Trúng tuyển")
{
tduv.KetQuaTuyenDung = true;
}
if (KetQuaTuyenDung == "Không trúng tuyển")
{
tduv.KetQuaTuyenDung = false;
}
if (KetQuaTuyenDung == "Chưa có kết quả")
{
tduv.KetQuaTuyenDung = null;
}
//tduv.KetQuaTuyenDung = dReader.GetValue(13+i+3).ToString();
tduv.GhiChu = dReader.GetValue(13 + i + 4).ToString();
listview.Add(tduv);
}
}
excelConnection.Close();
TempData["tdttungvien"] = listview;
TempData["filepath"] = Request.Files["FileUpload1"].FileName;
}
return(RedirectToAction("Index"));
}
}
