public JsonResult GetSalesOrderDetailerRecords(JQGridSettings JQGrid) { int TotapPages = 0; int TotalRecords = 0; int SalesOrderID = int.Parse(Request.QueryString["SalesOrderID"]); IEnumerable <SalesOrderDetail> SOHIE = null; IQueryable <SalesOrderDetail> SOHIQ = null; using (SalesEntities DB = new SalesEntities()) { DB.Configuration.LazyLoadingEnabled = false; DB.Configuration.ProxyCreationEnabled = false; SOHIQ = DB.SalesOrderDetails.AsQueryable().Where(d => d.SalesOrderID == SalesOrderID).Select(d => d); #region :::Soring-Searching::: if (JQGrid._search) { JQGridFilters _filters = JsonConvert.DeserializeObject <JQGridFilters>(JQGrid.filters); SOHIQ = SOHIQ.JQGridToolBarSearch(_filters); } else { SOHIQ = SOHIQ.JQGridSorting(JQGrid.sidx, JQGrid.sord); } #endregion #region :::Pagination SOHIE = SOHIQ.AsEnumerable(); try { TotapPages = Convert.ToInt32(Math.Ceiling((double)SOHIE.Count() / (double)JQGrid.rows)); TotalRecords = SOHIE.Count(); SOHIE = SOHIE.Skip((JQGrid.page - 1) * JQGrid.rows).Take(JQGrid.rows).ToList(); } catch (Exception e) { throw; } #endregion } var jsonReader = new { root = SOHIE, page = JQGrid.page, total = TotapPages, records = TotalRecords }; return(Json(jsonReader, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEmployeeCollection(JQGridSettings JQGrid) { int TotapPages = 0; int TotalRecords = 0; IEnumerable <Employee> IEEmployee = null; IQueryable <Employee> IQEmployee = null; using (Employee DB = new Employee()) { #region :::Soring-Searching::: if (JQGrid._search) { //for Filter Toolbar JQGridFilters _filters = JsonConvert.DeserializeObject <JQGridFilters>(JQGrid.filters); IQEmployee = DB.GetEmployeeColection().AsQueryable().JQGridToolBarSearch(_filters); //for Advanced Search //JQGridAdvanceFilter _filters1 = JsonConvert.DeserializeObject<JQGridAdvanceFilter>(JQGrid.filters); //IQEmployee = DB.GetEmployeeColection().AsQueryable().JQGridAdvancedSearch(_filters1); } else { IQEmployee = DB.GetEmployeeColection().AsQueryable().JQGridSorting(JQGrid.sidx, JQGrid.sord); } #endregion #region :::Pagination IEEmployee = IQEmployee.AsEnumerable(); try { TotapPages = Convert.ToInt32(Math.Ceiling((double)IEEmployee.Count() / (double)JQGrid.rows)); TotalRecords = IEEmployee.Count(); IEEmployee = IEEmployee.Skip((JQGrid.page - 1) * JQGrid.rows).Take(JQGrid.rows).ToList(); } catch (Exception) { throw; } #endregion } var jsonReader = new { root = IEEmployee, page = JQGrid.page, total = TotapPages, records = TotalRecords }; return(Json(jsonReader, JsonRequestBehavior.AllowGet)); }