public ActionResult GetMyCart(int?page, int?pageSize, DateTime?dateStart, DateTime?dateEnd) { if (clsConnect.DB_OpenConnection(DBHost, DBName, DBUser, DBPassword)) { int PageNumber = page ?? 1; int PageSizeVal = pageSize ?? 12; DateTime now = DateTime.Now.Date; List <ORDER_CLIENT> lstDataOrder = ORDER_CLIENT.ParseListFromDataTable <ORDER_CLIENT>(cls_2018_ORDERS.m2018_GetallOrders((Guid)Session["KeyUserLogin"])); if (dateStart != null) { lstDataOrder = lstDataOrder.Where(a => a.DAY_ORDER_CLIENT >= dateStart.Value.Date).ToList(); } if (dateEnd != null) { var dateEndVal = dateEnd.Value.Date.AddHours(23).AddMinutes(59).AddSeconds(59); lstDataOrder = lstDataOrder.Where(a => a.DAY_ORDER_CLIENT <= dateEndVal).ToList(); } var dataResult = lstDataOrder.Select(a => new { KEY_ORDER_CLIENT = a.KEY_ORDER_CLIENT, KEY_CARD_CLIENT = a.KEY_CARD_CLIENT, DAY_ORDER_CLIENT = a.DAY_ORDER_CLIENT.Value.ToString("dd-MM-yyyy HH:mm:ss"), COD_ORDER_CLIENT = a.COD_ORDER_CLIENT, TONG_TIEN_HANG = a.TONG_TIEN_HANG, TONG_GIAM_GIA = a.TONG_GIAM_GIA, TONG_TIEN_TOAN = a.TONG_TIEN_TOAN, STA_ORDER_CLIENT = a.STA_ORDER_CLIENT }).ToPagedList(PageNumber, PageSizeVal); return(Json(new { success = true, result = dataResult, currentPage = dataResult.PageNumber, totalPage = dataResult.PageCount, firstItemOnPage = dataResult.FirstItemOnPage, lastItemOnPage = dataResult.LastItemOnPage }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); }