public ActionResult GetDataModule(string sEcho, int Start, int Length) { var filter = Convert.ToString(Request["search[value]"]); var orderby = Convert.ToString(Request["order[0][column]"]); var dir = Convert.ToString(Request["order[0][dir]"]); var ModuleClass = new TModuleClass(); //remark by Irham 27 augustus 2015 //change : Add New parameter for limit and offset, remark display table, change result to res var res = ModuleClass.ModuleSelect("", "", Length, Start); Int32?TotalRecords; if (res.Count() > 0) { TotalRecords = res.FirstOrDefault().TotalRecords; } else { TotalRecords = 0; } //var displaytable = res.Skip(Start).Take(Length); var resutltnya = from d in res select new string[] { d.IDModule, d.ModuleCode, d.ModuleName, d.ModuleDesc, d.IconClass, d.IconType, d.IconName, d.IDIcon, d.UserEntry, d.DateEntry.ToString(), d.UserLastMaintenance, d.DateLastMaintenance.ToString(), d.Sequence.ToString() }; return(Json(new { sEcho = sEcho, iTotalRecords = TotalRecords, //ModuleClass.ModuleSelect(orderby, dir).Count(), iTotalDisplayRecords = TotalRecords, // ModuleClass.ModuleSelect(orderby, dir).Count(), aaData = resutltnya }, JsonRequestBehavior.AllowGet)); }
// GET: Test public ActionResult Index() { //if (Session["UserName"] == null) { return RedirectToAction("Index", "Login"); } var ModuleClass = new TModuleClass(); var ModuleResultList = ModuleClass.ModuleSelect("", "", 1000, 0); var ModuleSelectList = new SelectList(ModuleResultList, "IDModule", "ModuleName"); ViewBag.ModuleSelect = ModuleSelectList; string baseUrl = System.Web.HttpContext.Current.Request.RequestContext.RouteData.GetRequiredString("action"); var rd = System.Web.HttpContext.Current.Request.RequestContext.RouteData.GetRequiredString("Controller"); var pt = "/" + rd + "/" + baseUrl; var rl = Session["IDRole"].ToString(); var RoelAc = FR.RoleAccess(pt, rl); ViewBag.Role = RoelAc.FirstOrDefault(); return(View()); }
public ActionResult GetDataModule(string sEcho, int Start, int Length) { if (Session["UserName"] == null) { return(RedirectToAction("Index", "Login")); } var filter = Convert.ToString(Request["search[value]"]); var orderby = Convert.ToString(Request["order[0][column]"]); var dir = Convert.ToString(Request["order[0][dir]"]); var ModuleClass = new TModuleClass(); var res = ModuleClass.ModuleSelect("", "", 1000, 0); //var displaytable = res.Skip(Start).Take(Length); Int32?TotalRecords; if (res.Count() > 0) { TotalRecords = res.FirstOrDefault().TotalRecords; } else { TotalRecords = 0; } var resutltnya = from d in res select new string[] { d.IDModule, d.ModuleName, d.ModuleCode }; return(Json(new { sEcho = sEcho, iTotalRecords = TotalRecords, iTotalDisplayRecords = TotalRecords, aaData = resutltnya }, JsonRequestBehavior.AllowGet)); }