public ActionResult GetOrderReportData() { int MenCategory = (productorder.GetAll()).Where(x => x.CustomerID == (int)Session["LoginId"] && x.ProductHistory.MainCategory.Category_name == "Men").Count(); int WomenCategory = (productorder.GetAll()).Where(x => x.CustomerID == (int)Session["LoginId"] && x.ProductHistory.MainCategory.Category_name == "Women").Count(); int LifeStyleCategory = (productorder.GetAll()).Where(x => x.CustomerID == (int)Session["LoginId"] && x.ProductHistory.MainCategory.Category_name == "Life Style").Count(); Ratio obj = new Ratio(); obj.MenCategory = MenCategory; obj.WomenCategory = WomenCategory; obj.LifeStyleCategory = LifeStyleCategory; return(Json(obj, JsonRequestBehavior.AllowGet)); }
public ActionResult codVSpaypal() { var chartData = new object[3]; chartData[0] = new object[] { "Payment Type", "Count" }; int paypal = productorder.GetAll().Where(x => x.Order.PayMentMethod == "PayPal").Count(); int cashOnDelivery = productorder.GetAll().Where(x => x.Order.PayMentMethod == "Cash On Delivery").Count(); chartData[1] = new object[] { "Cash On Delivery Payment", cashOnDelivery }; chartData[2] = new object[] { "PayPal Payment", paypal }; return(Json(chartData)); }
public ActionResult PostprofitbyCategory() { var chartData = new object[4]; chartData[0] = new object[] { "Category Type", "Count" }; int ManCategory = productorder.GetAll().Where(x => x.Order.PayMentMethod == "PayPal").Count(); int WomenCategory = productorder.GetAll().Where(x => x.Order.PayMentMethod == "Cash On Delivery").Count(); int LifeStyleCategory = productorder.GetAll().Where(x => x.Order.PayMentMethod == "Cash On Delivery").Count(); chartData[1] = new object[] { "Cash On Delivery Payment", cashOnDelivery }; chartData[2] = new object[] { "PayPal Payment", paypal }; return(Json(chartData)); }
public ActionResult COnfirmOrder() { var UserName = User.Identity.GetUserName(); ViewBag.Total = cart_Service.GetCartTotal(cart_Service.GetCartID()); ViewBag.TotalQTY = cart_Service.GetCartItems().FindAll(x => x.cartId == cart_Service.GetCartID()).Sum(q => q.quantity); var confirm = _productOrdersRepository.GetAll(); //db.productrders.ToList(); var cart = _productOrdersRepository.GetAll(); //db.Cart_Items.ToList(); CustomerOrder mealOrder = new CustomerOrder(); mealOrder.OrderNumber = mealOrder.GenVoucher(); mealOrder.Total = ViewBag.Total; mealOrder.UserOrder = UserName; mealOrder.Status = "Paid"; mealOrder.OrderDate = DateTime.Now.Date.ToLongDateString(); _CustomerOrderRepository.Insert(mealOrder); //db.MealOrders.Add(mealOrder); //db.SaveChanges(); ProductOrder foodOrder = new ProductOrder(); foreach (var item in confirm) { foreach (var i in cart) { if (UserName == item.UserEmail && item.cart_id == i.cart_id) { var statusUpdate = _productOrdersRepository.GetById(item.cart_item_id); //db.productrders.Find(item.cart_item_id); statusUpdate.OrderStatus = "Checked Out"; statusUpdate.OrderId = mealOrder.OrderId; _productOrdersRepository.Update(statusUpdate); //db.Entry(statusUpdate).State = EntityState.Modified; //db.SaveChanges(); cart_Service.EmptyCart(); } } } return(RedirectToAction("OnceOff", new { tot = mealOrder.Total })); }
public IHttpActionResult GetOrderReportData(int id) { try { var c = productorder.GetAll(); var x2 = c.Where(x1 => x1.CustomerID == id && x1.ProductHistory.MainCategory.Category_name == "Men").Count(); }catch (Exception exc) { } int MenCategory = (productorder.GetAll()).Where(x => x.CustomerID == id && x.ProductHistory.MainCategory.Category_name == "Men").Count(); int WomenCategory = (productorder.GetAll()).Where(x => x.CustomerID == id && x.ProductHistory.MainCategory.Category_name == "Women").Count(); int LifeStyleCategory = (productorder.GetAll()).Where(x => x.CustomerID == id && x.ProductHistory.MainCategory.Category_name == "Life Style").Count(); Ratio obj = new Ratio(); obj.MenCategory = MenCategory; obj.WomenCategory = WomenCategory; obj.LifeStyleCategory = LifeStyleCategory; return(Json(obj)); }
public ActionResult GetAllProductOrders() { var productOrders = _productOrderRepository.GetAll(); return(Ok(productOrders)); }