//GetEventCategories public object GetEventCategories(string sidx, string sord, int page, int rows, long event_id, int maincat_id, long?cat_id, string title) { int?totalrecords = 0; int pageindex = (page > 0) ? page - 1 : 0; dataContext.CommandTimeout = 600000; var res = dataContext.spCategory_View_CategoryByMCandE(event_id, maincat_id, cat_id, String.IsNullOrEmpty(title) ? String.Empty : title.Replace(" ", "%"), sidx.ToLower(), sord == "desc", pageindex, rows, ref totalrecords); if (totalrecords.GetValueOrDefault(0) == 0) { return new { total = 0, page = page, records = 0 } } ; return(new { total = (int)Math.Ceiling((float)totalrecords.GetValueOrDefault(0) / (float)rows), page = page, records = totalrecords.GetValueOrDefault(0), rows = ( from query in res select new { i = query.Category_ID, cell = new string[] { query.Category_ID.ToString(), query.CategoryTitle } }).ToArray() }); }