public ActionResult Edit1(int id = 0) { tdXemVaXepLichHen tdxemvaxeplichhen = db.tdXemVaXepLichHen.Find(id); if (tdxemvaxeplichhen == null) { return(HttpNotFound()); } return(View(tdxemvaxeplichhen)); }
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")); }
public ActionResult Edit1(FormCollection form) { if (form["id"] != "") { var id = int.Parse(form["id"]); var ungvien_id = form["ungvienid"]; var ngayphongvan = form["item.NgayPhongVan"]; var gio = form["item.Gio"]; var diadiemphongvan = form["item.DiaDiemPhongVan"]; var donviphongvan = new int?(); try { donviphongvan = int.Parse(form["item.DonViPhongVan_id"]); } catch { donviphongvan = null; } var dabaochoungvien = false; if (form["item.DaBaoChoUngCuVien"] == "true,false") { dabaochoungvien = true; } var ghichu = form["item.GhiChu"]; if (ModelState.IsValid) { var old = db.tdXemVaXepLichHen.Find(id); try { var newdata = new tdXemVaXepLichHen { id = id, UngCuVien_id = old.UngCuVien_id, NgayPhongVan = DateTime.Parse(ngayphongvan), Gio = gio, DiaDiemPhongVan = diadiemphongvan, DonViPhongVan_id = donviphongvan, DaBaoChoUngCuVien = dabaochoungvien, GhiChu = ghichu }; db.Entry(old).CurrentValues.SetValues(newdata); } catch { var newdata = new tdXemVaXepLichHen { id = id, UngCuVien_id = old.UngCuVien_id, NgayPhongVan = null, Gio = gio, DiaDiemPhongVan = diadiemphongvan, DonViPhongVan_id = donviphongvan, DaBaoChoUngCuVien = dabaochoungvien, GhiChu = ghichu }; db.Entry(old).CurrentValues.SetValues(newdata); } db.SaveChanges(); TempData["Message"] = "Bạn đã cập nhật thành công."; return(RedirectToAction("Index")); } } else if (form["id"] == "") { if (form["ungvienid"] != "") { var ngayphongvan = form["NgayPhongVan"]; var gio = form["Gio"]; var diadiemphongvan = form["DDPhongVan"]; var donviphongvan = new int?(); try { donviphongvan = int.Parse(form["DonViPhongVan_id"]); } catch { donviphongvan = null; } var ungvien_id = int.Parse(form["ungvienid"]); var dabaochoungvien = false; if (form["DaBaoChoUngCuVien"] == "true,false") { dabaochoungvien = true; } var ghichu = form["GhiChu"]; if (ModelState.IsValid) { try { var tdqllichhen = new tdXemVaXepLichHen { UngCuVien_id = ungvien_id, NgayPhongVan = DateTime.Parse(ngayphongvan), Gio = gio, DiaDiemPhongVan = diadiemphongvan, DonViPhongVan_id = donviphongvan, DaBaoChoUngCuVien = dabaochoungvien, GhiChu = ghichu }; db.tdXemVaXepLichHen.Add(tdqllichhen); db.SaveChanges(); var temptlist = db.tdXemVaXepLichHen.ToList().Last(); var tdquatrinhtd = new tdQuaTrinhTuyenDung { UngVien_id = ungvien_id, QuanLyLH_id = temptlist.id }; db.tdQuaTrinhTuyenDung.Add(tdquatrinhtd); } catch { var tdqllichhen = new tdXemVaXepLichHen { UngCuVien_id = ungvien_id, NgayPhongVan = null, Gio = gio, DiaDiemPhongVan = diadiemphongvan, DonViPhongVan_id = donviphongvan, DaBaoChoUngCuVien = dabaochoungvien, GhiChu = ghichu }; db.tdXemVaXepLichHen.Add(tdqllichhen); db.SaveChanges(); var temptlist = db.tdXemVaXepLichHen.ToList().Last(); var tdquatrinhtd = new tdQuaTrinhTuyenDung { UngVien_id = ungvien_id, QuanLyLH_id = temptlist.id }; db.tdQuaTrinhTuyenDung.Add(tdquatrinhtd); } db.SaveChanges(); TempData["Message"] = "Bạn đã thêm mới thành công."; } } else { TempData["Message"] = "Thêm mới thất bại. Bạn chưa chọn tên ứng viên."; } return(RedirectToAction("Index")); } return(null); //ViewBag.UngCuVien_id = new SelectList(db.tdTTUngCuVien, "id", "HoVaTen", tdxemvaxeplichhen.UngCuVien_id); //return View(tdxemvaxeplichhen); }