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