public ActionResult Edit_XX1(XETXU xx, FormCollection form) { XETXU newXetXu = db.XETXUs.FirstOrDefault(nxx => nxx.MA_XetXu == xx.MA_XetXu); newXetXu.Ngay_XetXu = xx.Ngay_XetXu; newXetXu.MA_DiaDiem = form["dd"].ToString(); CHITIET_XX newThuKy = db.CHITIET_XX.FirstOrDefault(ntk => ntk.MA_XetXu == xx.MA_XetXu && ntk.MA_VaiTro == "C1"); newThuKy.MA_NhanVien = form["tk"].ToString(); CHITIET_XX newKiemSat = db.CHITIET_XX.FirstOrDefault(nks => nks.MA_XetXu == xx.MA_XetXu && nks.MA_VaiTro == "C3"); newKiemSat.MA_NhanVien = form["ks"].ToString(); ClearHoiDong(xx.MA_XetXu); List <string> selectedHoiDongList = form["hd"].Split(',').ToList(); for (int i = 0; i < selectedHoiDongList.Count; i++) { CHITIET_XX hoidong = new CHITIET_XX { MA_NhanVien = selectedHoiDongList[i], MA_VaiTro = "C4", MA_XetXu = xx.MA_XetXu, MA_ChiTietXX = UUID.GetUUID(5) }; themChiTietXetXu(hoidong); } db.SaveChanges(); return(RedirectToAction("ListXX")); }
public JsonResult GetKiemSat(string maXetXu) { int intMaXetXu = Convert.ToInt32(maXetXu); CHITIET_XX kiemSat = db.CHITIET_XX.FirstOrDefault(ks => ks.MA_XetXu == intMaXetXu && ks.MA_VaiTro == "C3"); return(Json(kiemSat.MA_NhanVien, JsonRequestBehavior.AllowGet)); }
public JsonResult CheckXoa(string id) { try { CHITIET_XX chiTietXetXu = db.CHITIET_XX.SingleOrDefault(s => s.MA_NhanVien == id); HOSO_VUAN hoSo = db.HOSO_VUAN.SingleOrDefault(s => s.MA_NhanVien == id); if (chiTietXetXu == null && hoSo == null) { return(Json("true", JsonRequestBehavior.AllowGet)); } else { return(Json("false", JsonRequestBehavior.AllowGet)); } } catch { return(Json("false", JsonRequestBehavior.AllowGet)); } }
public void themChiTietXetXu(CHITIET_XX ctxx) { db.CHITIET_XX.Add(ctxx); db.SaveChanges(); }
public ActionResult themLXX(XETXU xx, FormCollection form) { ViewBag.dd = new SelectList(db.DIADIEM_XX.OrderBy(x => x.Ten_DiaDiem), "MA_DiaDiem", "Ten_DiaDiem"); ViewBag.hs = new SelectList(db.HOSO_VUAN.OrderBy(x => x.MA_HoSo), "MA_HoSo", "Ten_VuAn"); ViewBag.hd = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV"); ViewBag.ks = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV"); ViewBag.tk = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV"); ViewBag.cxx = new SelectList(db.CAPXETXUs.OrderBy(x => x.MA_CapXetXu), "MA_CapXetXu", "TenCapXetXu"); if (db.XETXUs.Any(x => x.MA_XetXu == xx.MA_XetXu)) { return(RedirectToAction("ListXX", new { error = 1 })); } xx.MA_CapXetXu = form["cxx"].ToString(); xx.MA_DiaDiem = form["dd"].ToString(); xx.MA_HoSo = form["hs"].ToString(); if (!ModelState.IsValid) { return(View(xx)); } db.XETXUs.Add(xx); db.SaveChanges(); HOSO_VUAN hoSo = db.HOSO_VUAN.Where(hs => hs.MA_HoSo == xx.MA_HoSo).FirstOrDefault(); hoSo.MA_TrangThai = "02"; db.SaveChanges(); List <string> selectedHoiDongList = form["hd"].Split(',').ToList(); for (int i = 0; i < selectedHoiDongList.Count; i++) { CHITIET_XX hoidong = new CHITIET_XX { MA_NhanVien = selectedHoiDongList[i], MA_VaiTro = "C4", MA_XetXu = xx.MA_XetXu, MA_ChiTietXX = UUID.GetUUID(5) }; themChiTietXetXu(hoidong); } CHITIET_XX kiemSat = new CHITIET_XX { MA_NhanVien = form["ks"].ToString(), MA_VaiTro = "C3", MA_XetXu = xx.MA_XetXu, MA_ChiTietXX = UUID.GetUUID(5) }; themChiTietXetXu(kiemSat); CHITIET_XX thuky = new CHITIET_XX { MA_NhanVien = form["tk"].ToString(), MA_VaiTro = "C1", MA_XetXu = xx.MA_XetXu, MA_ChiTietXX = UUID.GetUUID(5) }; themChiTietXetXu(thuky); return(RedirectToAction("ListXX")); }