public static RelatedProductCollection LoadForProduct(Int32 productId)
{
RelatedProductCollection RelatedProducts = new RelatedProductCollection();
//CREATE THE DYNAMIC SQL TO LOAD OBJECT!
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT " + RelatedProduct.GetColumnNames(string.Empty));
selectQuery.Append(" FROM ac_RelatedProducts");
selectQuery.Append(" WHERE ProductId = @productId");
selectQuery.Append(" ORDER BY OrderBy");
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@productId", System.Data.DbType.Int32, productId);
//EXECUTE THE COMMAND
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read())
{
RelatedProduct relatedProduct = new RelatedProduct();
RelatedProduct.LoadDataReader(relatedProduct, dr);
RelatedProducts.Add(relatedProduct);
}
dr.Close();
}
return(RelatedProducts);
}
/// <summary>
/// Loads the given RelatedProduct object from the given database data reader.
/// </summary>
/// <param name="relatedProduct">The RelatedProduct object to load.</param>
/// <param name="dr">The database data reader to read data from.</param>
public static void LoadDataReader(RelatedProduct relatedProduct, IDataReader dr)
{
//SET FIELDS FROM ROW DATA
relatedProduct.ProductId = dr.GetInt32(0);
relatedProduct.OrderBy = dr.GetInt16(1);
relatedProduct.ChildProductId = dr.GetInt32(2);
relatedProduct.IsDirty = false;
}
public static bool Delete(Int32 productId, Int32 childProductId)
{
RelatedProduct relatedProduct = new RelatedProduct();
if (relatedProduct.Load(productId, childProductId))
{
return(relatedProduct.Delete());
}
return(false);
}
public static SaveResult Insert(RelatedProduct relatedProduct)
{
return(relatedProduct.Save());
}
public static bool Delete(RelatedProduct relatedProduct)
{
return(relatedProduct.Delete());
}
public static SaveResult Update(RelatedProduct relatedProduct)
{
return(relatedProduct.Save());
}
){kind=link}