public override List <SueetieProduct> GetSueetieProductsByCategoryTree(int categoryID)
{
List <SueetieProduct> list = new List <SueetieProduct>();
using (SqlConnection connection = this.GetSqlConnection())
{
using (SqlCommand command = new SqlCommand("SuCommerce_ProductsByCategory_Get", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@categoryID", SqlDbType.Int, 4).Value = categoryID;
command.Parameters.Add("@contentTypeID", SqlDbType.Int, 4).Value = 0x12;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
SueetieProduct product = null;
while (reader.Read())
{
product = new SueetieProduct();
CommerceDataProvider.PopulateSueetieProductList(reader, product);
list.Add(product);
}
reader.Close();
connection.Close();
}
return(list);
}
}
}