public dynamic GetList(string _search, long nd, int rows, int?page, string sidx, string sord, string filters = "") { // Construct where statement string strWhere = GeneralFunction.ConstructWhere(filters); // Get Data var query = _deliveryOrderService.GetAll().Where(d => d.IsDeleted == false); var list = query as IEnumerable <DeliveryOrder>; var pageIndex = Convert.ToInt32(page) - 1; var pageSize = rows; var totalRecords = query.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize); // default last page if (totalPages > 0) { if (!page.HasValue) { pageIndex = totalPages - 1; page = totalPages; } } list = list.Skip(pageIndex * pageSize).Take(pageSize); return(Json(new { total = totalPages, page = page, records = totalRecords, rows = ( from model in list select new { id = model.Id, cell = new object[] { model.Id, model.Code, model.SalesOrderId, _salesOrderService.GetObjectById(model.SalesOrderId).Code, model.DeliveryDate, model.WarehouseId, _warehouseService.GetObjectById(model.WarehouseId).Name, model.IsConfirmed, model.ConfirmationDate, model.CreatedAt, model.UpdatedAt, } }).ToArray() }, JsonRequestBehavior.AllowGet)); }
public ActionResult Search(DeliveryOrderViewModel model) { isAdminLogged(); ViewBag.Parent = "Quản lý giao hàng"; ViewBag.Child = "Tìm kiếm"; try { if (model.idDeliveryOrder > 0) { var t = _deliveryOrderService.SearchById(model.idDeliveryOrder); if (t != null) { IList <DeliveryOrder> temp = new List <DeliveryOrder>(); temp.Add(t); model.listDeliveryOrder = temp.ToList(); } return(View("List", model)); } else if (model.deliveryDate != null) { DateTime delivery_date = Convert.ToDateTime(model.deliveryDate); model.listDeliveryOrder = _deliveryOrderService.SearchByDeliveryDate(delivery_date); return(View("List", model)); } else if (model.status != 0) { //byte status = Convert.ToByte(dOrder.status); model.listDeliveryOrder = _deliveryOrderService.SearchByStatus(model.status); View("List", model); } else { model.listDeliveryOrder = _deliveryOrderService.GetAll(); return(View("List", model)); } } catch (FormatException e) { throw; } return(View("List")); }