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