internal static void FillFromReader(Product Product, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_PRODUCT_ID);
if (!reader.IsDBNull(colIndex))
Product.ID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_SUPPLIER_ID);
if (!reader.IsDBNull(colIndex))
Product.SupplierID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_EAN13_OR_JAN);
if (!reader.IsDBNull(colIndex))
Product.Ean13OrJan = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_UPC);
if (!reader.IsDBNull(colIndex))
Product.UPC = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_LOCATION);
if (!reader.IsDBNull(colIndex))
Product.Location = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_IS_DOWNLODABLE);
if (!reader.IsDBNull(colIndex))
Product.IsDownloadable = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_DISPLAY_ON_SALE_ICON);
if (!reader.IsDBNull(colIndex))
Product.DisplayOnSaleIcon = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_INITIAL_STOCK);
if (!reader.IsDBNull(colIndex))
Product.InitialStock = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_MINIMUM_QUANTITY);
if (!reader.IsDBNull(colIndex))
Product.MinimumQuantity = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_ADDITIONAL_SHIPPING_COST);
if (!reader.IsDBNull(colIndex))
Product.AdditionalShippingCost = reader.GetDecimal(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_MANUFACTURER_ID);
if (!reader.IsDBNull(colIndex))
Product.ManufacturarID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_IS_ENABLED);
if (!reader.IsDBNull(colIndex))
Product.IsEnabled = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_PORTAL_ID);
if (!reader.IsDBNull(colIndex))
Product.PortalID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_TAX_ID);
if (!reader.IsDBNull(colIndex))
Product.TaxID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_NAME);
if (!reader.IsDBNull(colIndex))
Product.Name = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_MESSAGE1);
if (!reader.IsDBNull(colIndex))
Product.DisplayTextInStockText = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_MESSAGE2);
if (!reader.IsDBNull(colIndex))
Product.DisplayTextInBackOrderText = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_DESC);
if (!reader.IsDBNull(colIndex))
Product.Description = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_DESC2);
if (!reader.IsDBNull(colIndex))
Product.ShortDescription = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_DETAILS);
if (!reader.IsDBNull(colIndex))
Product.SizeChart = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_KEYWORD);
if (!reader.IsDBNull(colIndex))
Product.Tags = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(ECommerceDataMapperBase.CN_ECO_LAN_LAN_ID);
if (!reader.IsDBNull(colIndex))
Product.LanguageID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PRODUCT_IS_ENABLED);
if (!reader.IsDBNull(colIndex))
Product.IsDeleted = reader.GetBoolean(colIndex);
}