public static void PopulatePurchaseTypeItemList(IDataReader dr, PurchaseTypeItem _purchaseTypeItem) { _purchaseTypeItem.PurchaseTypeID = (int)dr["purchasetypeid"]; _purchaseTypeItem.PurchaseTypeCode = dr["purchasetypecode"] as string; _purchaseTypeItem.PurchaseTypeDescription = dr["purchasetypedescription"] as string; _purchaseTypeItem.IsDisplayed = (bool)dr["isdisplayed"]; }
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); }