public JsonResult Search([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, ProgramPdtCtrl programPdtCtrl)
{
//DataTables.
int pageSize = requestModel.Length != 0 ? requestModel.Length : 10;
int pageNumber = requestModel.Start / requestModel.Length + 1;
//ReturnProgramPdtCtrl searchProgrampdtCtrl = new ReturnProgramPdtCtrl();
//searchProgrampdtCtrl.aProgramPdtCtrl = programPdtCtrl;
ReturnProgramPdtCtrl _returnProgramPdtCtrl = (new ProgramPdtCtrlDB()).SearchProgramPdtCtrl(programPdtCtrl, pageNumber, pageSize);
//_returnProgramPdtCtrl.TotalPage = (_returnProgramPdtCtrl.Total + pageSize - 1) / pageSize;
//_returnProgramPdtCtrl.TotalPage = _returnProgramPdtCtrl.TotalPage == 0 ? 1 : _returnProgramPdtCtrl.TotalPage;
// DataTables.
// Avoid from datatables.net getting stuck (if data=null).
if (_returnProgramPdtCtrl.lstProgramPdtCtrl == null)
{
_returnProgramPdtCtrl.lstProgramPdtCtrl = new List <ProgramPdtCtrl>();
}
//Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
if (column.Data.Contains("Action"))
{
continue;
}
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
IEnumerable <ProgramPdtCtrl> IEnum_MachineMtn = _returnProgramPdtCtrl.lstProgramPdtCtrl.OrderBy(orderByString ==
string.Empty ? "ID asc" : orderByString);
_returnProgramPdtCtrl.lstProgramPdtCtrl = IEnum_MachineMtn.ToList <ProgramPdtCtrl>();
//Permission.
_returnProgramPdtCtrl.permisionControllerVM = this.getPermisionControllerViewModel();
//DataTables.
//return View.
var DataTablesResponse = new
{
draw = requestModel.Draw,
data = _returnProgramPdtCtrl,
recordsFiltered = _returnProgramPdtCtrl.Total,
recordsTotal = _returnProgramPdtCtrl.Total
};
return(Json(DataTablesResponse, JsonRequestBehavior.AllowGet));
//return Json(_returnProgramPdtCtrl, JsonRequestBehavior.AllowGet);
}
public JsonResult GetbyKey(ProgramPdtCtrl p)
{
return(Json(programPdtCtrl.GetbyKey(p), JsonRequestBehavior.AllowGet));
}
public JsonResult Add(ProgramPdtCtrl p)
{
return(Json(programPdtCtrl.Insert(p), JsonRequestBehavior.AllowGet));
}
public JsonResult CountbyID(ProgramPdtCtrl p)
{
return(Json(programPdtCtrl.GetbyKey(p).Total, JsonRequestBehavior.AllowGet));
}
public JsonResult Delete(ProgramPdtCtrl p)
{
//ReturnToolList x = toolDB.DeleteByID(ID);
//return Json(toolDB.DeleteByID(ID), JsonRequestBehavior.AllowGet);
return(Json(programPdtCtrl.DeleteByKey(p), JsonRequestBehavior.AllowGet));
}
