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 GetOrderHistory(int orderId, int customerId) { CakesPosRepository cpr = new CakesPosRepository(_connectionString); OrderDetailsViewModel orderHistory = cpr.GetOrderDetails(orderId, customerId); return(Json(orderHistory, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateInvoice(int customerId, int orderId) { CakesPosRepository cpr = new CakesPosRepository(_connectionString); OrderDetailsViewModel o = cpr.GetOrderDetails(customerId, orderId); InvoiceManager i = new InvoiceManager(); i.CreateInvoicePDF(o); return(null); }
public ActionResult CreateInvoiceOtherEmail(int customerId, int orderId, string email) { CakesPosRepository cpr = new CakesPosRepository(_connectionString); OrderDetailsViewModel o = cpr.GetOrderDetails(customerId, orderId); InvoiceManager i = new InvoiceManager(); i.CreateInvoicePDF(o); i.EmailInvoice(@"C:\inetpub\sites\CakesPos\InvoicesPdf\" + orderId + ".pdf", email); return(null); }
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)); }
//[HttpPost] //public ActionResult Order(int customerId, int orderId) //{ // CakesPosRepository cpr = new CakesPosRepository(_connectionString); // OrdersViewModel ovm = new OrdersViewModel(); // ovm.categories = cpr.GetAllCategories(); // ovm.products = cpr.GetProductsByCategory(1); // ovm.order = cpr.GetOrderById(orderId); // ovm.orderDetails = cpr.GetOrderDetailsById(orderId); // return View(ovm); //} //[HttpPost] public ActionResult EditOrder(int customerId, int orderId) { CakesPosRepository cpr = new CakesPosRepository(_connectionString); EditOrdersViewModel ovm = new EditOrdersViewModel(); ovm.categories = cpr.GetAllCategories(); ovm.products = cpr.GetProductsByCategory(1); //ovm.order = cpr.GetOrderById(orderId); //ovm.orderDetails = cpr.GetOrderDetailsById(); //ovm.customer = cpr.GetCustomerById(customerId); //ovm.orderedProducts=cpr. ovm.productAvailability = cpr.GetProductAvailability(DateTime.Today.AddMonths(-1), DateTime.Today.AddDays(3), 1); ovm.orderDetails = cpr.GetOrderDetails(customerId, orderId); return(View(ovm)); }