public ActionResult ListShoppingCartProducts() { ShoppingCartProductRepository scpr = new ShoppingCartProductRepository(ConstantUtil.MyConnectionString); IEnumerable <ShoppingCartProduct> shoppingCartProducts = scpr.GetAll(); return(View(shoppingCartProducts)); }
//public String CheckOut(IEnumerable<ShoppingCartProduct> Model) //{ // CustomerRepository customerRepo = new CustomerRepository(ConstantUtil.MyConnectionString); // Customer customer = customerRepo.GetById(1); // CustomerOrder co = new CustomerOrder(1, 25); // CustomerOrderRepository cor = new CustomerOrderRepository(ConstantUtil.MyConnectionString); // int orderId = cor.Insert(co); // List<CustomerOrderProduct> cops = new List<CustomerOrderProduct>(); // foreach (int scp in myModel.products) // { // CustomerOrderProduct temp = new CustomerOrderProduct(orderId, scp); // ProductRepository pr = new ProductRepository(ConstantUtil.MyConnectionString); // Product prod = pr.GetById(scp); // temp.Quantity = 100; // temp.UnitOfMeasure = prod.UnitOfMeasure; // temp.UnitPrice = prod.UnitPrice; // temp.CreatedBy = prod.CreatedBy; // temp.CreatedDate = prod.CreatedDate; // temp.LastModifiedBy = prod.LastModifiedBy; // temp.LastModifiedDate = prod.LastModifiedDate; // temp.Subtotal = 0; // cops.Add(temp); // } // return "Successfully"; //} public String CheckOut() { CustomerRepository customerRepo = new CustomerRepository(ConstantUtil.MyConnectionString); Customer customer = customerRepo.GetById(1); CustomerOrder co = new CustomerOrder(1, 25); CustomerOrderRepository cor = new CustomerOrderRepository(ConstantUtil.MyConnectionString); int orderId = cor.Insert(co); List <CustomerOrderProduct> cops = new List <CustomerOrderProduct>(); ShoppingCartProductRepository scpr = new ShoppingCartProductRepository(ConstantUtil.MyConnectionString); IEnumerable <ShoppingCartProduct> myModel = scpr.GetAll(); foreach (ShoppingCartProduct scp in myModel) { CustomerOrderProduct temp = new CustomerOrderProduct(orderId, scp.ProductId); //ProductRepository pr = new ProductRepository(ConstantUtil.MyConnectionString); //Product prod = pr.GetById(scp); temp.Quantity = scp.Quantity; temp.UnitOfMeasure = scp.UnitOfMeasure; temp.UnitPrice = scp.UnitPrice; temp.CreatedBy = scp.CreatedBy; temp.CreatedDate = scp.CreatedDate; temp.LastModifiedBy = scp.LastModifiedBy; temp.LastModifiedDate = scp.LastModifiedDate; temp.Subtotal = scp.SubTotal; //cops.Add(temp); CustomerOrderProductRepository copr = new CustomerOrderProductRepository(ConstantUtil.MyConnectionString); copr.Insert(temp); } return("Successfully"); }
public String AddToCart(int id) { //not supposed to be here, should be after login event customer = customerRepo.GetById(1); shoppingCart = new ShoppingCart(customer.Id); shoppingCart.CreatedBy = shoppingCart.LastModifiedBy = "Customer Name"; // create a ShoppingCartRepository scr object //use scr to save shoppingCart ShoppingCartRepository scr = new ShoppingCartRepository(ConstantUtil.MyConnectionString); int shoppingCartId = scr.Insert(shoppingCart); ProductRepository pr = new ProductRepository(ConstantUtil.MyConnectionString); Product p = pr.GetById(id); ShoppingCartProduct scp = new ShoppingCartProduct(shoppingCartId, id); scp.Quantity = 100; scp.UnitOfMeasure = p.UnitOfMeasure; scp.UnitPrice = p.UnitPrice; scp.CreatedBy = p.CreatedBy; scp.LastModifiedBy = p.LastModifiedBy; scp.CreatedDate = p.CreatedDate; scp.LastModifiedDate = p.LastModifiedDate; scp.SubTotal = scp.Quantity * scp.UnitPrice; //create a ShoppinngCartProductRepository scpr //use scpr to save scp ShoppingCartProductRepository scpr = new ShoppingCartProductRepository(ConstantUtil.MyConnectionString); scpr.Create(scp); return("Add product " + id + " to the cart successfully!"); }
public ConfigController() { brandRepository = new BrandRepository(); categoryRepository = new CategoryRepository(); productRepository = new ProductRepository(); customerRepository = new CustomerRepository(); shoppingCartRepository = new ShoppingCartRepository(); shoppingCartProductRepository = new ShoppingCartProductRepository(); }
public ShoppingCartProductController() { shoppingCartProductRepository = new ShoppingCartProductRepository(); includes = new string[] { "ShoppingCart", "ShoppingCart.Customer", "Product", "Product.Brand", "Product.Category" }; }