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