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