public override List <ProductPackage> GetProductPackageList()
{
List <ProductPackage> list = new List <ProductPackage>();
using (SqlConnection connection = this.GetSqlConnection())
{
string cmdText = "select * from SuCommerce_ProductPackage";
SqlCommand command = new SqlCommand(cmdText, connection)
{
CommandType = CommandType.Text
};
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
ProductPackage package = null;
while (reader.Read())
{
package = new ProductPackage();
CommerceDataProvider.PopulateProductPackageList(reader, package);
list.Add(package);
}
reader.Close();
connection.Close();
}
}
return(list);
}