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