public ActionResult ShowGrid(JQgridParamData param) { try { var products = _productRepository.GetProductGrid(); var records = products.Count(); var PC = (double)records / param.rows; var pageCount = (int)Math.Ceiling(PC); var sk = (param.page * param.rows) - param.rows; var result = products.Skip(sk).Take(param.rows).ToList(); List <ProductGridVM> productsResult = new List <ProductGridVM>(); AutoMapper.Mapper.Map(result, productsResult); var jsonData = new JQgridJsonParamVM <ProductGridVM> { total = pageCount, page = param.page, records = records, rows = productsResult }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
public JsonResult ShowGrid(int truckID, JQgridParamData param) { try { var truckDetails = _truckDetailRepository.GetGridByTruckID(truckID); var records = truckDetails.Count(); var PC = (double)records / param.rows; var pageCount = (int)Math.Ceiling(PC); var sk = (param.page * param.rows) - param.rows; var result = truckDetails.Skip(sk).Take(param.rows).ToList(); List <TruckDetailVM> truckResult = new List <TruckDetailVM>(); AutoMapper.Mapper.Map(result, truckResult); var jsonData = new JQgridJsonParamVM <TruckDetailVM> { total = pageCount, page = param.page, records = records, rows = truckResult }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
public JsonResult OrderDetailShowGrid(int orderID, JQgridParamData param) { try { var orderDetail = _orderRepository.GetOrderDetailGrid(orderID); var records = orderDetail.Count(); var PC = (double)records / param.rows; var pageCount = (int)Math.Ceiling(PC); var sk = (param.page * param.rows) - param.rows; var result = orderDetail.Skip(sk).Take(param.rows).ToList(); List <OrderDetailVM> orderResult = new List <OrderDetailVM>(); AutoMapper.Mapper.Map(result, orderResult); var jsonData = new JQgridJsonParamVM <OrderDetailVM> { total = pageCount, page = param.page, records = records, rows = orderResult }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } catch (Exception) { Response.StatusCode = 400; throw; } }