public JsonResult getGroupSiteById(long id)
{
return(Json(groupService.GetGroupSite(id), JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandler(JQueryDataTableParamModel param)
{
var allLinked_Site = Linked_SiteService.GetAllLinked_Site();
IEnumerable <Linked_Site> filteredLinked_Site;
//Check whether the Linked_Site should be filtered by keyword
if (!string.IsNullOrEmpty(param.sSearch))
{
//Used if particulare columns are filtered
var nameFilter = Convert.ToString(Request["sSearch_1"]);
var addressFilter = Convert.ToString(Request["sSearch_2"]);
var townFilter = Convert.ToString(Request["sSearch_3"]);
//Optionally check whether the columns are searchable at all
var isNameSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
var isAddressSearchable = Convert.ToBoolean(Request["bSearchable_2"]);
var isTownSearchable = Convert.ToBoolean(Request["bSearchable_3"]);
filteredLinked_Site = Linked_SiteService.GetAllLinked_Site()
.Where(c => isNameSearchable && c.SiteName.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filteredLinked_Site = allLinked_Site;
}
var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]);
var isAddressSortable = Convert.ToBoolean(Request["bSortable_2"]);
var isTownSortable = Convert.ToBoolean(Request["bSortable_3"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <Linked_Site, string> orderingFunction = (c => sortColumnIndex == 1 && isNameSortable ? c.Id.ToString() :
sortColumnIndex == 2 && isAddressSortable ? GroupSiteService.GetGroupSite(c.GroupSiteId).GroupName :
sortColumnIndex == 3 && isAddressSortable ? c.SiteName.ToString() :
sortColumnIndex == 4 && isTownSortable ? c.Flag.ToString() :
"");
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredLinked_Site = filteredLinked_Site.OrderBy(orderingFunction);
}
else
{
filteredLinked_Site = filteredLinked_Site.OrderByDescending(orderingFunction);
}
var displayedLinked_Site = filteredLinked_Site.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedLinked_Site select new[] { Convert.ToString(c.Id), GroupSiteService.GetGroupSite(c.GroupSiteId).GroupName, Convert.ToString(c.SiteName), Convert.ToString(c.ModifyDate), Convert.ToString(c.Flag) };
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = allLinked_Site.Count(),
iTotalDisplayRecords = filteredLinked_Site.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
