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"));
}
