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