public ActionResult GetOrders(JqGridRequest request, string keyword)
 {
   var searchCriteria = new OrderingSearchCriteria();
   var result = _orderingReportService.OrderingRetailOrders(searchCriteria, request.RecordsCount, request.PageIndex);
   var jsonData = new
   {
     total = (result.Count + request.RecordsCount - 1) / request.RecordsCount,
     page = request.PageIndex + 1,
     records = result.Count,
     rows = result.Items
   };
   return Json(jsonData, JsonRequestBehavior.AllowGet);
 }
    public SearchResult<OrderingDTO> OrderingRetailOrders(OrderingSearchCriteria searchCriteria, int pageSize, int pageIndex)
    {
      return _executor.Execute(new GetOrderingRetailOrdersDTOSearchCriteriaDbCommand(searchCriteria, pageIndex, pageSize));
 
    }