AbleCommerce Shopping Cart Software

Code: Select all

List<Product> products = ProductDataSource.FindProducts(string.Empty, "YOUR SKU HERE", 0, 0, 0);

Code: Select all

public Product GetProductForSku(string sku) 
    {
        ProductCollection products = ProductDataSource.LoadForCriteria(string.Format(" Sku = '{0}' ", sku));
        if (products.Count > 0)
            return products[0];
        return null;
    }

Code: Select all

public OrderCollection GetOrderForProductId(int productId)
    {
        OrderCollection orders = OrderDataSource.LoadForCriteria(string.Format(" ProductId = '{0}' ", productId));
return orders;
    }

Code: Select all

OrderCollection orders = OrderDataSource.LoadForCriteria(string.Format(" ProductId = '{0}' AND OrderStatusId = {1} ", productId,orderStatusId));

Code: Select all

							
// looking for orders with these two "statuses" and the productID of int ProdID

                                                        string StatProc = "7";
							string StatRFF = "2";
							int PROCqty = 0;
							// find the orders that have the correct order status and this product.
							OrderCollection orders = OrderDataSource.LoadForCriteria(string.Format(" ProductId = '{0}' AND OrderStatusId = {1}  AND OrderStatusId = {2} ", ProdID, StatProc, StatRFF));  

//Now I ought to have a collection of orders that have this product in them and the correct status.
							// Let's see if we have any?
							if (orders != null && orders.Count > 0) 	
							{
								// we get here because there are orders with the status and product we are worried about, so count 'em up.
								foreach (Order order in orders)
									{
										// put the add qty stuff here.
										 foreach (OrderItem item in order.Items)	
											{
												if (item.productID == ProdID) PROqty = PROqty + item.Quantity;
											}
									}


								// so now we have the qty deducted from AC but not WG, let's net it and save it
								ACqty = WGqty - PROCqty;
								product.InStock = ACqty; 
								product.Save();
							}
							else
								{
									product.InStock = WGqty;
            							        product.Save();
									// we got here by finding NO orders that had the status and product we are worried about.

								}

Code: Select all

OrderCollection orders = OrderDataSource.LoadForCriteria(string.Format(" ProductId = '{0}' AND OrderStatusId IN ({1},{2}) ", ProdID, StatProc, StatRFF));