public void FindByCustomerTest() { ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository(); var shoppingcar = repository.FindByCustomer(1); Assert.IsTrue(shoppingcar.Count() > 0); }
public void FindByIdTest() { ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository(); var shoppingcar = repository.FindById(1, 3); Assert.IsTrue(shoppingcar == null); }
public void GetAllTest() { ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository(); var shoppingcar = repository.GetAll(); Assert.IsTrue(shoppingcar.Count() > 0); }
public void GetProductTotalTest() { ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository(); var shoppingcar = repository.GetProductTotal(1); Assert.IsTrue(shoppingcar > 0); }
public bool AddProducttoShoppingcar(ShoppingcartDetails model) { var shoppingcarRepository = new ShoppingcartDetailsRepository(); var productsRepository = new ProductsRepository(); var stock = productsRepository.CheckStock(model.ProductID, model.Quantity); if (stock) { var product = shoppingcarRepository.FindById(model.CustomerID, model.ProductID); if (product == null) { shoppingcarRepository.Create(model); } else { shoppingcarRepository.Update(model); } return(true); } else { return(false); } }
public void DeleteOneForUserTest() { ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository(); ShoppingcartDetails model = new ShoppingcartDetails { CustomerID = 1, ProductID = 1 }; var shoppingcar = repository.GetAll(); Assert.IsTrue(shoppingcar.Count() > 0); }
public void UpdateminusTest() { ShoppingcartDetailsRepository repository = new ShoppingcartDetailsRepository(); ShoppingcartDetails model = new ShoppingcartDetails { CustomerID = 1, ProductID = 1, Quantity = 1 }; repository.Updateminus(model); var shoppingcar = repository.GetAll(); Assert.IsTrue(shoppingcar.Count() > 0); }
public string ConfirmOrders(List <ShoppingcartDetails> shoppingcar, Order order)//新增訂單 { var shoppingcarRepository = new ShoppingcartDetailsRepository(); var productsRepository = new ProductsRepository(); var orderRepository = new OrderRepository(); var orderDetailsRepository = new OrderDetailsRepository(); SqlConnection connection = new SqlConnection(sqlstr); connection.Open(); var transactition = connection.BeginTransaction(); try { foreach (var item in shoppingcar)//每一件是否都有庫存 { var stock = productsRepository.CheckStock(item.ProductID, item.Quantity); if (!stock) { return($"{item.ProductID}"); } } orderRepository.Create(order);//新增訂單 var orderid = orderRepository.FindLastOrderByCustomerID(order.CustomerID); foreach (var item in shoppingcar)//新增訂單明細 { var orderDetails = new OrderDetails() { OrderID = orderid, ProductID = item.ProductID, Quantity = item.Quantity }; orderDetailsRepository.Create(orderDetails); } //扣庫存 foreach (var item in shoppingcar) { var product = new Products() { ProductID = item.ProductID }; productsRepository.UpdateStockPminus(product, item.Quantity); } //刪購物車內容 //先判斷購物車商品數量與訂單商品數量 shoppingcarRepository.DeleteAllForUser(order.CustomerID); transactition.Commit(); } catch (SqlException e) { transactition.Rollback(); return(e.Message); } connection.Close(); return("OrderSuccess"); }
public IEnumerable <ShoppingcartDetails> FindByCustomer(int CustomerID) { var shoppingcarRepository = new ShoppingcartDetailsRepository(); return(shoppingcarRepository.FindByCustomer(CustomerID)); }
public decimal GetProductTotal(int Cid) { var shoppingcarRepository = new ShoppingcartDetailsRepository(); return(shoppingcarRepository.GetProductTotal(Cid)); }
public IEnumerable <ShoppingcartDetails> GetAll() { var shoppingcarRepository = new ShoppingcartDetailsRepository(); return(shoppingcarRepository.GetAll()); }
public ShoppingcartDetails FindById(int CustomerID, int ProductID) { var shoppingcarRepository = new ShoppingcartDetailsRepository(); return(shoppingcarRepository.FindById(CustomerID, ProductID)); }
public void DeleteOneForUser(ShoppingcartDetails model) { var shoppingcarRepository = new ShoppingcartDetailsRepository(); shoppingcarRepository.DeleteOneForUser(model); }
public void DeleteAllForUser(int CustomerID) { var shoppingcarRepository = new ShoppingcartDetailsRepository(); shoppingcarRepository.DeleteAllForUser(CustomerID); }
public void Update(ShoppingcartDetails model) { var shoppingcarRepository = new ShoppingcartDetailsRepository(); shoppingcarRepository.Update(model); }