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")); }
//[ValidateInput(false)] ///[ValidateAntiForgeryToken] public ActionResult sua_HS1(HOSO_VUAN hs, FormCollection form, string id) { //ViewBag.lva = new SelectList(db.LOAI_VUAN.OrderBy(x => x.Ten_LoaiVA), "MA_LoaiVA", "Ten_LoaiVA"); //ViewBag.tths = new SelectList(db.TRANGTHAI_HS.OrderBy(x => x.Ten_TT), "MA_TrangThai", "Ten_TT"); //ViewBag.mnv = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV"); hs.MA_LoaiVA = form["lva"].ToString();; hs.MA_NhanVien = form["mnv"].ToString(); //hs.MA_HoSo = id; HOSO_VUAN hoSo = db.HOSO_VUAN.Where(newHoSo => newHoSo.MA_HoSo == hs.MA_HoSo).FirstOrDefault(); hoSo.MA_NhanVien = hs.MA_NhanVien; hoSo.MA_LoaiVA = hs.MA_LoaiVA; hoSo.Ten_VuAn = hs.Ten_VuAn; hoSo.NoiDung_VA = hs.NoiDung_VA; hoSo.Loai_HS = hs.Loai_HS; hoSo.NgayNhan_HS = hs.NgayNhan_HS; // db.Entry(hs).State = EntityState.Modified; db.SaveChanges(); ClearNguyenDonBiDon(hs.MA_HoSo); List <string> selectedNguyenDonList = form["nd"].Split(',').ToList(); for (int i = 0; i < selectedNguyenDonList.Count; i++) { CHITIET_DS nguyendon = new CHITIET_DS { MA_DuongSu = selectedNguyenDonList[i], MA_LoaiDS = "ND", MA_HoSo = hs.MA_HoSo, MA_ChiTietDS = UUID.GetUUID(5) }; themChiTietDuongSu(nguyendon); } List <string> selectedBiDonList = form["bd"].Split(',').ToList(); for (int i = 0; i < selectedBiDonList.Count; i++) { CHITIET_DS bidon = new CHITIET_DS { MA_DuongSu = selectedBiDonList[i], MA_LoaiDS = "BD", MA_HoSo = hs.MA_HoSo, MA_ChiTietDS = UUID.GetUUID(5) }; themChiTietDuongSu(bidon); } return(RedirectToAction("ListHS")); }
public ActionResult xoa_HS(string id) { HOSO_VUAN hoso = db.HOSO_VUAN.SingleOrDefault(s => s.MA_HoSo == id); if (hoso == null) { Response.StatusCode = 404; return(null); } return(View(hoso)); }
public JsonResult GetNgayNhanHoSo(string maHoSo) { if (db.HOSO_VUAN.Count() > 0) { HOSO_VUAN hoSo = db.HOSO_VUAN.FirstOrDefault(ks => ks.MA_HoSo == maHoSo); return(Json(hoSo.NgayNhan_HS, JsonRequestBehavior.AllowGet)); } else { var ngayNhan = DateTime.Now.ToString(); return(Json(ngayNhan, JsonRequestBehavior.AllowGet)); } }
//[HttpPost, ActionName("xoa_HS")] public ActionResult xoa_HS1(string id) { try { HOSO_VUAN hoso = db.HOSO_VUAN.SingleOrDefault(s => s.MA_HoSo == id); ClearNguyenDonBiDon(hoso.MA_HoSo); db.HOSO_VUAN.Remove(hoso); db.SaveChanges(); return(RedirectToAction("ListHS")); } catch { return(RedirectToAction("ListHS")); } }
public ActionResult them_HS(HOSO_VUAN hs, FormCollection form) { //Tao ma tu dong hs.MA_HoSo = UUID.GetUUID(5); hs.MA_LoaiVA = form["lva"].ToString(); hs.MA_TrangThai = "01"; hs.MA_NhanVien = form["mnv"].ToString(); db.HOSO_VUAN.Add(hs); db.SaveChanges(); List <string> selectedNguyenDonList = form["nd"].Split(',').ToList(); for (int i = 0; i < selectedNguyenDonList.Count; i++) { CHITIET_DS nguyendon = new CHITIET_DS { MA_DuongSu = selectedNguyenDonList[i], MA_LoaiDS = "ND", MA_HoSo = hs.MA_HoSo, MA_ChiTietDS = UUID.GetUUID(5) }; themChiTietDuongSu(nguyendon); } List <string> selectedBiDonList = form["bd"].Split(',').ToList(); for (int i = 0; i < selectedBiDonList.Count; i++) { CHITIET_DS bidon = new CHITIET_DS { MA_DuongSu = selectedBiDonList[i], MA_LoaiDS = "BD", MA_HoSo = hs.MA_HoSo, MA_ChiTietDS = UUID.GetUUID(5) }; themChiTietDuongSu(bidon); } var list_HS = from s in db.HOSO_VUAN select s; ViewBag.lva = new SelectList(db.LOAI_VUAN.OrderBy(x => x.Ten_LoaiVA), "MA_LoaiVA", "Ten_LoaiVA"); ViewBag.tths = new SelectList(db.TRANGTHAI_HS.OrderBy(x => x.Ten_TT), "MA_TrangThai", "Ten_TT"); ViewBag.nd = new SelectList(db.DUONGSUs.OrderBy(x => x.HoTen_DS), "MA_DuongSu", "HoTen_DS"); ViewBag.bd = new SelectList(db.DUONGSUs.OrderBy(x => x.HoTen_DS), "MA_DuongSu", "HoTen_DS"); ViewBag.mnv = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV"); return(RedirectToAction("ListHS")); }
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 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")); }
public ActionResult ListHS(string searchString, DateTime?tungay, DateTime?denngay, int?error, int page = 1, int pageSize = 25) { ViewBag.lva = new SelectList(db.LOAI_VUAN.OrderBy(x => x.Ten_LoaiVA), "MA_LoaiVA", "Ten_LoaiVA"); ViewBag.vtnv = new SelectList(db.VAITRO_NV.OrderBy(x => x.Ten_VT), "MA_VaiTro", "Ten_VT"); ViewBag.mnv = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV"); ViewBag.nd = new SelectList(db.DUONGSUs.OrderBy(x => x.HoTen_DS), "MA_DuongSu", "HoTen_DS"); ViewBag.bd = new SelectList(db.DUONGSUs.OrderBy(x => x.HoTen_DS), "MA_DuongSu", "HoTen_DS"); // ViewBag.hs = new SelectList(db.HOSO_VUAN.OrderBy(x => x.Ten_VuAn), "MA_HoSo", "Ten_VuAn"); ViewBag.dd = new SelectList(db.DIADIEM_XX.OrderBy(x => x.Ten_DiaDiem), "MA_DiaDiem", "Ten_DiaDiem"); 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.hd = new SelectList(db.NHANVIENs.OrderBy(x => x.HoTen_NV), "MA_NhanVien", "HoTen_NV"); ViewBag.ds = new SelectList(db.DUONGSUs, "MA_DuongSu", "Hoten_DS"); ViewBag.cxx = new SelectList(db.CAPXETXUs.OrderBy(x => x.MA_CapXetXu), "MA_CapXetXu", "TenCapXetXu"); // 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); } } } IEnumerable <HOSO_VUAN> result = ListVA.GroupBy(x => x.Ten_VuAn).Select(x => x.First()); if (result.Count() > 0) { 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; } else { HOSO_VUAN hosoGia = new HOSO_VUAN { MA_HoSo = "00000", Ten_VuAn = "Không có vụ án" }; List <HOSO_VUAN> newListHoSo = new List <HOSO_VUAN>(); newListHoSo.Add(hosoGia); ViewBag.tva = new SelectList(newListHoSo.AsEnumerable(), "MA_HoSo", "Ten_VuAn"); ViewBag.lxx = new SelectList(newListHoSo.AsEnumerable(), "MA_HoSo", "Ten_VuAn"); var ngayxetxu = DateTime.Now; ViewBag.nxx = ngayxetxu; } IEnumerable <HOSO_VUAN> model = db.HOSO_VUAN; if (!string.IsNullOrEmpty(searchString)) { model = model.Where(x => x.Ten_VuAn.Contains(searchString) || x.MA_HoSo.Contains(searchString)).OrderByDescending(x => x.Ten_VuAn); } ViewBag.SearchString = searchString; DuongSuModel duongSuModel = new DuongSuModel(); if (tungay == null || denngay == null) { duongSuModel.listHoSoVuAn = model.OrderByDescending(x => x.MA_HoSo).ToPagedList(page, pageSize); if (db.HOSO_VUAN.Count() > 0) { ViewBag.tuNgay = db.HOSO_VUAN.Min(hs => hs.NgayNhan_HS).Value; } else { ViewBag.tuNgay = DateTime.Now; } ViewBag.denNgay = DateTime.Now; } else { List <HOSO_VUAN> newList = new List <HOSO_VUAN>(); foreach (var item in model) { if (item.NgayNhan_HS >= tungay && item.NgayNhan_HS <= denngay) { newList.Add(item); } } duongSuModel.listHoSoVuAn = newList.OrderByDescending(x => x.MA_HoSo).ToPagedList(page, pageSize); ViewBag.tuNgay = tungay; ViewBag.denNgay = denngay; } duongSuModel.listChiTietDuongSu = db.CHITIET_DS.ToList(); return(View(duongSuModel)); }
public JsonResult GetNgayNhanHoSo(string maHoSo) { HOSO_VUAN hoSo = db.HOSO_VUAN.FirstOrDefault(ks => ks.MA_HoSo == maHoSo); return(Json(hoSo.NgayNhan_HS, JsonRequestBehavior.AllowGet)); }
// 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))); } }