public override List <ParentCategory> GetParentCategoryList(int categoryID)
{
List <ParentCategory> list = new List <ParentCategory>();
using (SqlConnection connection = this.GetSqlConnection())
{
using (SqlCommand command = new SqlCommand("SuCommerce_ParentCategoriesByID_Get", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@categoryID", SqlDbType.Int, 4).Value = categoryID;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
ParentCategory category = null;
while (reader.Read())
{
category = new ParentCategory();
CommerceDataProvider.PopulateParentCategoryList(reader, category);
list.Add(category);
}
reader.Close();
connection.Close();
}
return(list);
}
}
}