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()); }