/// <summary>
/// Create a new CAT_AdvCatProducts object.
/// </summary>
/// <param name="advCatProductID">Initial value of the AdvCatProductID property.</param>
/// <param name="advCatID">Initial value of the AdvCatID property.</param>
/// <param name="productID">Initial value of the ProductID property.</param>
public static CAT_AdvCatProducts CreateCAT_AdvCatProducts(global::System.Int32 advCatProductID, global::System.Int32 advCatID, global::System.Int32 productID)
{
CAT_AdvCatProducts cAT_AdvCatProducts = new CAT_AdvCatProducts();
cAT_AdvCatProducts.AdvCatProductID = advCatProductID;
cAT_AdvCatProducts.AdvCatID = advCatID;
cAT_AdvCatProducts.ProductID = productID;
return cAT_AdvCatProducts;
}
private static void InsertNewProduct(fanlive4Entities entity, DateTime yesterday, string stylenumber, int category)
{
var styleProducts = from f in entity.CAT_Products where f.EAN.Contains(stylenumber) && f.PublicationStart > yesterday select f;
foreach (var styleProduct in styleProducts)
{
if (entity.CAT_AdvCatProducts.Any(d => d.CAT_Products.ProductID != styleProduct.ProductID))
{
CAT_AdvCatProducts catproduct = new CAT_AdvCatProducts();
catproduct.AdvCatID = category;
catproduct.CAT_Products = styleProduct;
entity.CAT_AdvCatProducts.AddObject(catproduct);
Console.WriteLine(styleProduct.ProductID);
}
}
entity.SaveChanges();
}
/// <summary>
/// Deprecated Method for adding a new object to the CAT_AdvCatProducts EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToCAT_AdvCatProducts(CAT_AdvCatProducts cAT_AdvCatProducts)
{
base.AddObject("CAT_AdvCatProducts", cAT_AdvCatProducts);
}
