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 ActionResult them_KQ(KETQUA_XX kqxx, FormCollection form, string troVe) { var listKetQua = from s in db.KETQUA_XX select s; if (db.KETQUA_XX.Any(x => x.MA_KetQuaXX == kqxx.MA_KetQuaXX)) { return(RedirectToAction("ListKQ", new { error = 1 })); } kqxx.MA_XetXu = Convert.ToInt32(form["lxx"]); if (!ModelState.IsValid) { return(View(kqxx)); } kqxx.MA_KetQuaXX = UUID.GetUUID(5); db.KETQUA_XX.Add(kqxx); db.SaveChanges(); KETQUA_XX newKQXX = db.KETQUA_XX.Where(newKQ => newKQ.MA_KetQuaXX == kqxx.MA_KetQuaXX).FirstOrDefault(); XETXU newXX = db.XETXUs.Where(xx => xx.MA_XetXu == newKQXX.MA_XetXu).FirstOrDefault(); string maHoSo = newXX.MA_HoSo; HOSO_VUAN hoSo = db.HOSO_VUAN.Where(hs => hs.MA_HoSo == maHoSo).FirstOrDefault(); hoSo.MA_TrangThai = "03"; db.SaveChanges(); if (troVe == "troVe") { return(RedirectToAction("ListHS", "HoSoVuAn")); } return(RedirectToAction("ListKQ")); }
//[HttpPost, ActionName("xoaLXX")] public ActionResult xoaLXX1(XETXU xx, int id) { try { XETXU xetxu = db.XETXUs.SingleOrDefault(x => x.MA_XetXu == id); ClearChiTietXetXu(id); db.XETXUs.Remove(xetxu); db.SaveChanges(); return(RedirectToAction("ListXX")); } catch (Exception e) { return(RedirectToAction("ListXX")); } }
public JsonResult CheckXoa(string id) { try { XETXU hoso = db.XETXUs.SingleOrDefault(s => s.MA_HoSo == id); if (hoso == null) { return(Json("true", JsonRequestBehavior.AllowGet)); } else { return(Json("false", JsonRequestBehavior.AllowGet)); } } catch { return(Json("false", JsonRequestBehavior.AllowGet)); } }
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")); }
// GET: KetQuaXetXu public ActionResult ListKQ(string searchString, string maHoSo, DateTime?tungay, DateTime?denngay, int?error, int page = 1, int pageSize = 10) { List <HOSO_VUAN> ListVA = new List <HOSO_VUAN>(); foreach (var item in db.XETXUs.ToList()) { ListVA.Add(item.HOSO_VUAN); //Xoa vu an da duoc xet xet xu khoi danh sach foreach (var itemKQ in db.KETQUA_XX.ToList()) { //Kiem tra vu an da duoc xet xu chua if (item.Equals(itemKQ.XETXU)) { ListVA.Remove(item.HOSO_VUAN); } } } try { IEnumerable <HOSO_VUAN> result = ListVA.GroupBy(x => x.Ten_VuAn).Select(x => x.First()); ViewBag.tva = new SelectList(result, "MA_HoSo", "Ten_VuAn"); HOSO_VUAN hoso = result.First(); List <XETXU> listXetXu = db.XETXUs.Where(xx => xx.MA_HoSo == hoso.MA_HoSo).ToList(); List <XETXU> newListXetXu = listXetXu; foreach (var itemXX in listXetXu.ToList()) { //Kiem tra vu an da duoc xet xu chua(theo lan) foreach (var itemKQ in db.KETQUA_XX.ToList()) { if (itemXX.Equals(itemKQ.XETXU)) { newListXetXu.Remove(itemXX); } } } ViewBag.lxx = new SelectList(newListXetXu.AsEnumerable(), "MA_XetXu", "Lan_XetXu"); var ngayxetxu = listXetXu.First().Ngay_XetXu; ViewBag.nxx = ngayxetxu; //loc IEnumerable <KETQUA_XX> model = db.KETQUA_XX; if (tungay == null || denngay == null) { ViewBag.tuNgay = db.KETQUA_XX.Min(hs => hs.XETXU.Ngay_XetXu).Value; ViewBag.denNgay = DateTime.Now; } else { List <KETQUA_XX> newList = new List <KETQUA_XX>(); foreach (var item in model) { if (item.XETXU.Ngay_XetXu >= tungay && item.XETXU.Ngay_XetXu <= denngay) { newList.Add(item); } } model = newList.OrderByDescending(x => x.MA_XetXu).ToPagedList(page, pageSize); ViewBag.tuNgay = tungay; ViewBag.denNgay = denngay; } if (!string.IsNullOrEmpty(searchString)) { model = model.Where(x => x.XETXU.HOSO_VUAN.Ten_VuAn.Contains(searchString)).OrderByDescending(x => x.XETXU.HOSO_VUAN.Ten_VuAn); } if (!String.IsNullOrEmpty(maHoSo)) { model = model.Where(kqxx => kqxx.XETXU.HOSO_VUAN.MA_HoSo == maHoSo); } ViewBag.SearchString = searchString; return(View(model.OrderByDescending(x => x.XETXU.HOSO_VUAN.Ten_VuAn).ToPagedList(page, pageSize))); } catch { List <XETXU> newListXetXu = new List <XETXU>(); XETXU xetxu = new XETXU { MA_XetXu = 0, MA_HoSo = "Không có vụ án" }; HOSO_VUAN hosoGia = new HOSO_VUAN { MA_HoSo = "00000", Ten_VuAn = "Không có vụ án" }; newListXetXu.Add(xetxu); List <HOSO_VUAN> newListHoSo = new List <HOSO_VUAN>(); newListHoSo.Add(hosoGia); ViewBag.lxx = new SelectList(newListXetXu.AsEnumerable(), "MA_XetXu", "Lan_XetXu"); ViewBag.tva = new SelectList(newListHoSo.AsEnumerable(), "MA_HoSo", "Ten_VuAn"); IEnumerable <KETQUA_XX> model = db.KETQUA_XX; if (tungay == null || denngay == null) { ViewBag.tuNgay = db.KETQUA_XX.Min(kq => kq.XETXU.Ngay_XetXu).Value; ViewBag.denNgay = DateTime.Now; } else { List <KETQUA_XX> newList = new List <KETQUA_XX>(); foreach (var item in model) { if (item.XETXU.Ngay_XetXu >= tungay && item.XETXU.Ngay_XetXu <= denngay) { newList.Add(item); } } model = newList.OrderByDescending(x => x.MA_XetXu).ToPagedList(page, pageSize); ViewBag.tuNgay = tungay; ViewBag.denNgay = denngay; } if (!string.IsNullOrEmpty(searchString)) { model = model.Where(x => x.XETXU.HOSO_VUAN.Ten_VuAn.Contains(searchString)).OrderByDescending(x => x.XETXU.HOSO_VUAN.Ten_VuAn); } if (!String.IsNullOrEmpty(maHoSo)) { model = model.Where(kqxx => kqxx.XETXU.HOSO_VUAN.MA_HoSo == maHoSo); } ViewBag.SearchString = searchString; return(View(model.OrderByDescending(x => x.XETXU.HOSO_VUAN.Ten_VuAn).ToPagedList(page, pageSize))); } }