public ActionResult DeliveryFilter(int x, string deliveryOpt) { List <OrderDetailsViewModel> od = new List <OrderDetailsViewModel>(); CakesPosRepository cpr = new CakesPosRepository(_connectionString); DateTime today = DateTime.Today; if (x == -1) { IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.deliveryOpt == deliveryOpt && o.requiredDate >= today.AddDays(x) && o.requiredDate < today && o.invoice == false); foreach (OrderHistoryViewModel o in orders) { od.Add(cpr.GetOrderDetails(o.customerId, o.id)); } return(Json(od, JsonRequestBehavior.AllowGet)); } else if (x <= 0) { IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.deliveryOpt == deliveryOpt && o.requiredDate >= today.AddDays(x) && o.requiredDate <= today && o.invoice == false); foreach (OrderHistoryViewModel o in orders) { od.Add(cpr.GetOrderDetails(o.customerId, o.id)); } return(Json(od, JsonRequestBehavior.AllowGet)); } else if (x == 1) { IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.deliveryOpt == deliveryOpt && o.requiredDate == today.AddDays(x) && o.invoice == false); foreach (OrderHistoryViewModel o in orders) { od.Add(cpr.GetOrderDetails(o.customerId, o.id)); } return(Json(od, JsonRequestBehavior.AllowGet)); } else if (x == 8) { IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.deliveryOpt == deliveryOpt && o.invoice == false); foreach (OrderHistoryViewModel o in orders) { od.Add(cpr.GetOrderDetails(o.customerId, o.id)); } return(Json(od, JsonRequestBehavior.AllowGet)); } else { IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.deliveryOpt == deliveryOpt && o.requiredDate <= today.AddDays(x) && o.requiredDate >= today && o.invoice == false); foreach (OrderHistoryViewModel o in orders) { od.Add(cpr.GetOrderDetails(o.customerId, o.id)); } return(Json(od, JsonRequestBehavior.AllowGet)); } }
public ActionResult OrderHistoryFilter(int x) { CakesPosRepository cpr = new CakesPosRepository(_connectionString); DateTime today = DateTime.Today; if (x == -1) { IEnumerable <OrderHistoryViewModel> yesterdaysOrders = cpr.GetOrders().Where(o => o.requiredDate >= today.AddDays(x) && o.requiredDate < today); return(Json(yesterdaysOrders.ToList(), JsonRequestBehavior.AllowGet)); } else if (x <= 0) { IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.requiredDate >= today.AddDays(x) && o.requiredDate <= today); return(Json(orders.OrderByDescending(o => o.requiredDate).ToList(), JsonRequestBehavior.AllowGet)); } else { IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.requiredDate <= today.AddDays(x) && o.requiredDate >= today); return(Json(orders.OrderByDescending(o => o.requiredDate).ToList(), JsonRequestBehavior.AllowGet)); } }
public ActionResult OrderList() { List <OrderDetailsViewModel> od = new List <OrderDetailsViewModel>(); CakesPosRepository cpr = new CakesPosRepository(_connectionString); IEnumerable <OrderHistoryViewModel> orders = cpr.GetOrders().Where(o => o.requiredDate == DateTime.Today && o.invoice == false); foreach (OrderHistoryViewModel o in orders) { od.Add(cpr.GetOrderDetails(o.customerId, o.id)); } return(View(od)); }