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;
}
}
