public virtual JsonResult DanhSachLoiAjax(JQueryDataTablesModel data) { List<DanhSachLoi_Result> listerror = _db.DanhSachLoi().ToList(); var jsonData = new { data.sEcho, iTotalRecords = listerror.Count(), iTotalDisplayRecords = listerror.Count(), aaData = ( listerror.Skip(data.iDisplayStart).Take(data.iDisplayLength).Select(c => new[] { c.ERRORID.ToString(), c.ERRORDESC, c.ERRORLEVEL, c.LEVELDESC, c.ERRORGROUP.ToString(), c.GROUPDESC }).ToArray()) }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public virtual JsonResult DanhSachLoiChiTiet(string pararm, JQueryDataTablesModel data) { var listerror = new List<DanhSachLoiTheoUserNhap_Result>(); ObjectResult<DanhSachLoiTheoUserNhap_Result> saa = _db.DanhSachLoiTheoUserNhap(User.Identity.Name); switch (pararm) { case "chuaxl": listerror = saa.Where(c => c.COMPLET.GetValueOrDefault() == false).ToList(); break; case "all": listerror = saa.ToList(); break; } var jsonData = new { data.sEcho, iTotalRecords = listerror.Count(), iTotalDisplayRecords = listerror.Count(), aaData = ( listerror.Skip(data.iDisplayStart) .Take(data.iDisplayLength) .Select(c => c.ERRORDATE != null ? new[] { c.ERRORDETAILID.ToString(CultureInfo.InvariantCulture), c.SEQ, c.ERRORDESC, c.ERRORTELLER + "-" + c.TenERRORTELLER, c.ERRORTELLERDEPT + "-" + c.TenERRORTELLERDEPT, c.ERRORDATE.Value.ToString("dd/MM/yyyy"), c.COMPLET.GetValueOrDefault().ToString() } : new string[] { })).ToArray() }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public virtual JsonResult ListError(string sEcho, int iDisplayStart, int iDisplayLength) { List<listerror_Result> listerror = _db.listerror().ToList(); int totalcount = listerror.Count(); var jsonData = new { sEcho, iTotalRecords = totalcount, iTotalDisplayRecords = 5, aaData = ( listerror.Select(c => c.ERRORDATE != null ? new[] { c.ERRORDETAILID.ToString(CultureInfo.InvariantCulture), c.SEQ, c.ERRORDESC, c.ERRORTELLER + "-" + c.TenERRORTELLER, c.ERRORTELLERDEPT + "-" + c.TenERRORTELLERDEPT, c.ERRORDATE.Value.ToString("dd/MM/yyyy") } : new string[] { })).ToArray() }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public virtual ActionResult DanhSachGdvAjax(JQueryDataTablesModel data) { var dsgdv = _db.PAR_TELLER.Select(c => c).ToList(); int totalcount = dsgdv.Count(); var jsonData = new { data.sEcho, iTotalRecords = totalcount, iTotalDisplayRecords = totalcount, aaData = ( dsgdv.Skip(data.iDisplayStart).Take(data.iDisplayLength) .Select(c => new[] { c.TLCODE, c.TLNAME, c.OFFICER.ToString() }) ) }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public virtual JsonResult DanhSachNhomLoiAxAj(JQueryDataTablesModel data) { List<PAR_ERRORGROUP> listgrouperro = _db.PAR_ERRORGROUP.Select(c => c).ToList(); var jsonData = new { data.sEcho, iTotalRecords = listgrouperro.Count(), iTotalDisplayRecords = listgrouperro.Count(), aaData = ( listgrouperro.Skip(data.iDisplayStart).Take(data.iDisplayLength).Select(c => new[] { c.GROUPID.ToString(CultureInfo.InvariantCulture), c.GROUPDESC.ToString(CultureInfo.InvariantCulture) }).ToArray()) }; return Json(jsonData, JsonRequestBehavior.AllowGet); }