public void Add(PlacedOrderRows placedOrderRows) { using (var connection = new SqlConnection(this.connectionString)) { connection.Execute("INSERT INTO PlacedOrderRows (OrderId, ProductId, Name, Price) VALUES(@orderId, @productId, @name, @price)", placedOrderRows); } }
public int CreateOrderRowFromCart(int cartId) { if (cartId == 0) { return(0); } else { List <Cart> cartItems = this.cartRepository.Get(cartId); int orderIdForThisCart = this.GetRandomOrderId(); foreach (var cartItem in cartItems) { var productId = cartItem.ProductId; var productData = this.productRepository.Get(productId); PlacedOrderRows tmpOrderRow = new PlacedOrderRows { OrderId = orderIdForThisCart, ProductId = productData.ProductId, Name = productData.Name, Price = productData.Price }; this.placedOrderRowsRepository.Add(tmpOrderRow); } this.cartRepository.Delete(cartId); return(orderIdForThisCart); } }