void BindExample() { ShoppingData ds = new ShoppingData(); var vrow = ds.Vendor.AddVendorRow("Kroger"); ds.Item.AddItemRow("", "Butter", vrow, new DateTime(2030, 1, 1), 4, false); ds.Item.AddItemRow("", "Eggs", vrow, new DateTime(2030, 1, 5), 12, true); this.Gridc.BindGrid(ds.Item); IEnumerable <Col> cols = new[] { new Col(ds.Item.QuantityColumn), new Col(ds.Item.NameColumn), new Col(ds.Item.StockColumn) { Tooltip = "have any in the pantry" }, new Col(ds.Item.DateColumn) { Format = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.LongDatePattern } }; this.Gridc.ConfigureColumns(cols); }
public static bool ValidateEmptyCart(int orderid) { if (OrderDataValidation.ValidateOrderExists(orderid)) { if (ShoppingData.OrderCart(orderid).Count() == 0) { return(true); } else { if (ShoppingData.OrderCart(orderid).Where(c => c.C_Count != 0).Count() == 0) { return(true); } else { return(false); } } } else { return(true); } }
public IHttpActionResult GetCartDetail() { if (ShoppingData.CartsList().Any()) { return(Ok(ShoppingData.CartsList())); } else { return(NotFound()); } }
public IHttpActionResult GetOrders() { if (ShoppingData.OrdersList().Any()) { return(Ok(ShoppingData.OrdersList())); } else { return(NotFound()); } }
public IHttpActionResult GetProducts() { if (ShoppingData.ProductList().Any()) { return(Ok(ShoppingData.ProductList())); } else { return(NotFound()); } }
public IHttpActionResult GetOrderDetails(int OrderID) { if (ShoppingData.CartsList().Any(c => c.C_OrderID == OrderID)) { return(Ok(ShoppingData.CartsList().Where(c => c.C_OrderID == OrderID).ToList())); } else { return(NotFound()); } }
public ActionResult ShopDetail() { ShoppingData shoppingData = (ShoppingData)Session["shopping_data"]; string code = (string)Session["random_code"]; ViewBag.code = code; if (shoppingData == null) { return(RedirectToAction("Index", "Home")); } else { return(View(shoppingData)); } }
public IHttpActionResult RemoveProductFromCart(int OrderID, int ProductID) { if (OrderDataValidation.ValidateOpenOrder(OrderID)) { if (ShoppingData.ProductList().Any(p => p.P_ID == ProductID)) { using (ShoppingEntities entities = new ShoppingEntities()) { if (entities.Cart.Any(c => c.C_OrderID == OrderID && c.C_ProductID == ProductID)) { int NoOfItems = entities.Cart.Where(c => c.C_OrderID == OrderID && c.C_ProductID == ProductID).First().C_Count; if (NoOfItems > 0) { NoOfItems = NoOfItems - 1; entities.Cart.First(c => c.C_OrderID == OrderID && c.C_ProductID == ProductID).C_Count = NoOfItems; entities.SaveChanges(); return(Ok("1 Item removed from Cart")); } else { return(BadRequest("0 items in Cart")); } } else { return(BadRequest("Items not present in Cart")); } } } else { return(BadRequest("Invalid Product ID")); } } else { return(BadRequest("Invalid OrderID")); } }
public ActionResult Buy(ShoppingData shoppingData) { Cart cart = (Session["cart"] == null) ? new Cart() : (Cart)Session["cart"]; String randomCode = RandomString(10, false); if (cart.lstBooksId != null && cart.lstBooksId.Count > 0) { foreach (int book_id in cart.lstBooksId) { db.Shops.Add(new Shop { Id_AspNetUsers = cart.User_Id, Id_Book = book_id, Code = randomCode }); } } var a = db.SaveChanges(); Session["cart"] = null; Session["shopping_data"] = shoppingData; Session["random_code"] = randomCode; return(RedirectToAction("ShopDetail")); }
public ActionResult Buy() { Cart cart = (Session["cart"] == null) ? new Cart() : (Cart)Session["cart"]; decimal total = (Session["total_shop"] == null) ? 0.0M : (decimal)Session["total_shop"]; ShoppingData shoppingData = new ShoppingData(); if (User.Identity.IsAuthenticated) { AspNetUser user = db.AspNetUsers.Where(x => x.UserName == User.Identity.Name).First(); cart.User_Id = user.Id; shoppingData.Address = user.Address; shoppingData.City = user.City; shoppingData.Country = user.Country; shoppingData.PostalCode = user.PostalCode; shoppingData.Name = user.UserName; shoppingData.Total = total; return(View(shoppingData)); } else { string returnUrl = Url.Action("Buy", "Cart"); return(RedirectToAction("Login", "Account", new { returnUrl = returnUrl })); } }
public async static Task <string> ShoppingListData(string query) { var conn = new NpgsqlConnection(connectionString); await conn.OpenAsync(); var shoppingData = new ShoppingData(); using (var cmd = new NpgsqlCommand(query, conn)) using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { shoppingData.UserId = reader["userid"].ToString(); shoppingData.ShoppingItems = reader["shoppinglist"].ToString(); shoppingData.TickedItems = reader["ticked"].ToString(); } } conn.Close(); var json = JsonConvert.SerializeObject(shoppingData); return(json); }
public IHttpActionResult AddProductToCart(int OrderID, int ProductID) { if (OrderDataValidation.ValidateOpenOrder(OrderID)) { if (ShoppingData.ProductList().Any(p => p.P_ID == ProductID)) { using (ShoppingEntities entities = new ShoppingEntities()) { if (entities.Cart.Any(c => c.C_OrderID == OrderID && c.C_ProductID == ProductID)) { int NoOfItems = entities.Cart.Where(c => c.C_OrderID == OrderID && c.C_ProductID == ProductID).First().C_Count; NoOfItems = NoOfItems + 1; entities.Cart.First(c => c.C_OrderID == OrderID && c.C_ProductID == ProductID).C_Count = NoOfItems; entities.SaveChanges(); } else { entities.Cart.Add(new Cart { C_OrderID = OrderID, C_ProductID = ProductID, C_Count = 1 }); entities.SaveChanges(); } return(Ok("Item added in Cart")); } } else { return(BadRequest("Invalid Product ID")); } } else { return(BadRequest("Invalid OrderID")); } }
public decimal TotalAfterDiscount(int orderid) { List <Cart> myOrderCart; List <Products> allProducts; List <Discount> allDiscounts; decimal totalAmount = 0; decimal itemCost = 0; myOrderCart = ShoppingData.OrderCart(orderid).ToList(); allDiscounts = ShoppingData.Discounts().ToList(); allProducts = ShoppingData.ProductList().ToList(); foreach (var item in myOrderCart) { itemCost = 0; if (CartDataValidation.ValidateEmptyCartProduct(item)) { itemCost = 0; } else { itemCost = itemCost + ItemCost(item, allProducts.First(p => p.P_ID == item.C_ProductID)); if (allDiscounts.Any(d => d.D_ProductID == item.C_ProductID)) { foreach (var discount in allDiscounts.Where(d => d.D_ProductID == item.C_ProductID)) { switch (discount.D_DiscountCode.ToUpper()) { case "3FOR2": itemCost = itemCost - ThreeForTwoDiscount(item, allProducts.First(p => p.P_ID == item.C_ProductID), discount); continue; default: itemCost = itemCost - ProductDiscount(item, allProducts.First(p => p.P_ID == item.C_ProductID), discount); continue; } } } } totalAmount = totalAmount + itemCost; } if (allDiscounts.Any(d => d.D_ProductID == 0)) { foreach (var discount in allDiscounts.Where(d => d.D_ProductID == 0)) { switch (discount.D_DiscountCode.ToUpper()) { case "ALL10": totalAmount = totalAmount - CommonDiscount(totalAmount, discount); continue; default: totalAmount = totalAmount - CommonDiscount(totalAmount, discount); continue; } } } return(totalAmount); }