public override List <PurchaseTypeItem> GetPurchaseTypeItemList()
{
List <PurchaseTypeItem> list = new List <PurchaseTypeItem>();
using (SqlConnection connection = this.GetSqlConnection())
{
string cmdText = "select * from SuCommerce_PurchaseTypes where IsDisplayed = 1";
SqlCommand command = new SqlCommand(cmdText, connection)
{
CommandType = CommandType.Text
};
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
PurchaseTypeItem item = null;
while (reader.Read())
{
item = new PurchaseTypeItem();
CommerceDataProvider.PopulatePurchaseTypeItemList(reader, item);
list.Add(item);
}
reader.Close();
connection.Close();
}
}
return(list);
}