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