private static void CreateProductTable(DAConnect connection)
{
DoProductInsert("1 AII61036 Aquarium Air Pumps Hurricane Category 2 (deluxe Battery Operated Pump) <p>Hurricane Pumps from Deep Blue are designed to help your aquarium residents survive a temporary power loss&#046; Our deluxe Category 2 pump features </p><ul><li>"Compact design makes it ideal for fish transportation, as well as, back up aeration during temporary power loss&#046;"</li><li>Water Resistant &#045; A rubber seal for both the battery compartment and power switch&#046;</li><li>Comes with a length of silicone air tubing and an airstone&#046;</li><li>"Has two &#040;2&#041; ""D"" cell battery slots&#046; Batteries are not included&#046;"</li><li>Made of high quality impact plastic for durability and quiet operation&#046;</li><li>Single outlet design&#046;</li></ul> 1882_pid.jpg 5.45 0 749729610366", connection);
DoProductInsert("1 AII61037 Aquarium Air Pumps Hurricane Category 5 (professional Ac/dc Battery Operated Pump) Hurricane category 5 (professional ac/dc battery operated pump) 1883_pid.jpg 75.3 0 749729610373", connection);
DoProductInsert("1 AAP702A Aquarium Air Pumps Rena Air 50 Pump (for Up To 10gal Tanks) Rena air 50 pump (for up to 10gal tanks) 1884_pid.jpg 11.75 0 17163507024", connection);
DoProductInsert("1 AAP702B Aquarium Air Pumps Rena Air 100 Pump (for Up To 20gal Tanks) Rena air 100 pump (for up to 20gal tanks) 1885_pid.jpg 18.17 0 17163107026", connection);
DoProductInsert("1 AAP702C Aquarium Air Pumps Rena Air 200 Pump (for Up To 30gal Tanks) Rena air 200 pump (for up to 30gal tanks) 1886_pid.jpg 27.95 0 17163207023", connection);
DoProductInsert("1 AAP702D Aquarium Air Pumps Rena Air 300 Pump (for Up To 75gal Tanks) Rena air 300 pump (for up to 75gal tanks) 1887_pid.jpg 39.04 0 17163307020", connection);
DoProductInsert("1 AAP702E Aquarium Air Pumps Rena Air 400 Pump (for Up To 150gal Tanks) Rena air 400 pump (for up to 150gal tanks) 1888_pid.jpg 60.47 0 17163407027", connection);
DoProductInsert("1 ABLVF1 Aquarium Air Pumps Vibra Flow Air Pump 1 Single <p>Single outlet air pump for fish bowls, 5 galllon and 10 gallon aquariums</p><ul></ul> 2320_pid.jpg 6.47 0 30157004989", connection);
DoProductInsert("1 ABLVF2 Aquarium Air Pumps Vibra Flow Air Pump 2 Double Outlet <p>Double outlet air pump &#045; ideal for all aquariums</p><ul></ul> 2321_pid.jpg 9.36 0 30157004996", connection);
DoProductInsert("1 ABLVF3 Aquarium Air Pumps Vibra Flow Air Pump 3 Double Outlet <p>Double outlet air pump &#045; ideal for all aquariums</p><ul></ul> 2322_pid.jpg 10.92 0 30157005009", connection);
DoProductInsert("1 ABLVFB1 Aquarium Air Pumps Vibra Flow Battery Air Pump <p>"Portable battery operated air pump is safe and convenient to use&#046; Ideal for holding tanks, fish transport&#046;"Portable battery operated air pump is safe and convenient to use&#046; </p><ul><li>"Belt clip, tubing & air stone included"</li><li>1<br></li></ul> 2323_pid.jpg 8.51 0 30157001469", connection);
DoProductInsert("1 ABLVFMINI Aquarium Air Pumps Vibra Flow Air Pump Mini Single <p>Mini size air pump &#045; ideal for bowls and small aquariums</p><ul></ul> 2324_pid.jpg 5.17 0 30157004972", connection);
DoProductInsert("1 ACL01655 Aquarium Air Pumps Coralife Luft Pump <UL><LI>Luft Pump (Air Pump)</LI></UL><ul> 2892_pid.jpg 70.04 0 96316016552", connection);
DoProductInsert("1 ACL01656 Aquarium Air Pumps Super Luft High Pressure Air Pump Sl - 38 Super luft high pressure air pump sl-38 2893_pid.jpg 70.27 0 96316016569", connection);
DoProductInsert("1 ACL01657 Aquarium Air Pumps Super Luft High Pressure Air Pump Sl - 65 Super luft high pressure air pump sl-65 2894_pid.jpg 77.38 0 96316016576", connection);
DoProductInsert("1 ATS77846 Aquarium Air Pumps Whisper 10 Air Pump (new Design Ul Approved) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7194_pid.jpg 9.52 0 46798778462", connection);
DoProductInsert("1 ATS77847 Aquarium Air Pumps Whisper 20 Air Pump (new Design Ul Approved) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7195_pid.jpg 12.87 0 46798778479", connection);
DoProductInsert("1 ATS77848 Aquarium Air Pumps Whisper 40 Air Pump (new Design Ul Approved) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7196_pid.jpg 13.99 0 46798778486", connection);
DoProductInsert("1 ATS77849 Aquarium Air Pumps Whisper 60 Air Pump (new Design Ul Approved) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7197_pid.jpg 18.64 0 46798778493", connection);
DoProductInsert("1 ATS77851 Aquarium Air Pumps Whisper 10 Air Pump (new Design) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7198_pid.jpg 6.91 0 46798778516", connection);
DoProductInsert("1 ATS77852 Aquarium Air Pumps Whisper 20 Air Pump (new Design) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7199_pid.jpg 9.02 0 46798778523", connection);
DoProductInsert("1 ATS77853 Aquarium Air Pumps Whisper 40 Air Pump (new Design) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7200_pid.jpg 11.39 0 46798778530", connection);
DoProductInsert("1 ATS77854 Aquarium Air Pumps Whisper 60 Air Pump (new Design) <p>The new Whisper air pump was redesigned from the ground up for silence and performance&#046; It has many patented features that minimize noise yet allows for a powerful flow of air&#046;</p><ul></ul> 7201_pid.jpg 16.59 0 46798778547", connection);
DoProductInsert("1 ATO1032 Aquarium Air Pumps Stellar S - 10 Air Pump (1 Device) <p>Air Pump: Stellar S&#045;10 </p><p>Tank up to 10 Gallons</p><ul></ul> 7489_pid.jpg 9.05 0 33153010329", connection);
DoProductInsert("1 ATO1040 Aquarium Air Pumps Stellar S - 20 Air Pump (2 Devices) <p>Air Pump: StellarS&#045;20 </p><p>Tank up to 15 gallons</p><ul></ul> 7490_pid.jpg 10.08 0 33153010404", connection);
DoProductInsert("1 ATO1042 Aquarium Air Pumps Stellar S - 30 Air Pump (3 Devices) <p>Air Pump: StellarS&#045;30 </p><p>Tank up to 20 Gallons</p><ul></ul> 7491_pid.jpg 14.05 0 33153010428", connection);
DoProductInsert("1 ATO1050 Aquarium Air Pumps Stellar W - 40 Twin Outlet Air Pump (4 Devices) <p>Air Pump: StellarW&#045;40 (2 Outlets) </p><p>Tank up to 40 Gallons</p><ul></ul> 7492_pid.jpg 14.97 0 33153010503", connection);
DoProductInsert("1 ATO1052 Aquarium Air Pumps Stellar W - 60 Twin Outlet Air Pump (6 Devices) <p>Air Pump: StellarW&#045;60 (2 Outlets) </p><ul></ul> 7493_pid.jpg 19.94 0 33153010527", connection);
DoProductInsert("1 ATO1248 Aquarium Air Pumps Mini - 8 Air Pump (1 Outlet) Mini-8 air pump (1 outlet) 7494_pid.jpg 6.32 0 33153012484", connection);
DoProductInsert("1 ACA17557 Aquarium Air Pumps Million Air Ma - 200 Air Pump With Variable Flow Control Knob <p> Simply the best pump for your dollar&#046; A strong, reliable, safe and quiet air pump yet affordable&#046; Available models for virtually any aquatic environment&#046; </p><p> Model&#045; MA200</p><p>Aquarium Size&#045; 10&#045;30 gallon</p><p>Outlet&#045; Single </p><p>Control&#045; yes&#045; variable</p><p>Power&#045; 2&#046;3 watts</p><p>Air output&#045; 1666 cc&#047;m</p><p></p><ul></ul> 21725_pid.jpg 8.26 0 6903717557", connection);
DoProductInsert("1 ACA17595 Aquarium Air Pumps Million Air Ma - 600 Double Outlet Air Pump With Variable Flow Control Knob <p> Simply the best pump for your dollar&#046; A strong, reliable, safe and quiet air pump yet affordable&#046; Available models for virtually any aquatic environment&#046; </p><p> Model&#045; MA600</p><p>Aquarium Size&#045; 60 and up gallon</p><p>Outlet&#045; Dual</p><p>Control&#045;yes&#045;varaible</p><p> Power&#045; 3&#046;4 watts</p><p>Air output&#045; 2666 cc&#047;m</p><p></p><ul></ul> 21735_pid.jpg 11.18 0 6903717595", connection);
DoProductInsert("1 ACA17588 Aquarium Air Pumps Million Air Ma - 500 Double Outlet Air Pump Million air ma-500 double outlet air pump 21730_pid.jpg 10.58 0 6903717588", connection);
DoProductInsert("1 ACA17571 Aquarium Air Pumps Million Air Ma - 400 Double Outlet Air Pump With Variable Flow Control Knob <p> Simply the best pump for your dollar&#046; A strong, reliable, safe and quiet air pump yet affordable&#046; Available models for virtually any aquatic environment&#046; </p><p> Model&#045; MA400</p><p>Aquarium Size&#045; 30&#045;50 gallon</p><p>Outlet&#045; Dual</p><p>Control&#045; yes&#045;variable</p><p>Power&#045; 2&#046;4 watts</p><p>Air output&#045; 2000 cc&#047;m</p><p></p><ul></ul> 21729_pid.jpg 9.21 0 6903717571", connection);
DoProductInsert("1 ACA17564 Aquarium Air Pumps Million Air Ma - 300 Double Outlet Air Pump <p> Simply the best pump for your dollar&#046; A strong, reliable, safe and quiet air pump yet affordable&#046; Available models for virtually any aquatic environment&#046; </p><p> Model&#045; MA300</p><p>Aquarium Size&#045; 25&#045;40 gallon</p><p>Outlet&#045; Dual</p><p>Control&#045; </p><p>Power&#045; 2&#046;4 watts</p><p>Air output&#045; 2000 cc&#047;m</p><p></p><ul></ul> 21726_pid.jpg 8.78 0 6903717564", connection);
DoProductInsert("1 AHYKB2101 Aquarium Air Pumps Ario Geyser Kit (ornament & Ario 2 Blue) Medium Ario geyser kit (ornament & ario 2 blue) 22645_pid.jpg 39.66 0 841421005263", connection);
DoProductInsert("1 AHYKB1101 Aquarium Air Pumps Ario Volcano Kit (ornament & Ario 2 Red) Medium Ario volcano kit (ornament & ario 2 red) 22644_pid.jpg 39.66 0 841421005249", connection);
DoProductInsert("1 ACA17175 Aquarium Air Pumps Million Air Ma - 80 Air Pump <html><head></head><body><h2> Million Air&#047;Commodity Axis Inc&#046; - ACA17175</h2><p> Simply the best pump for your dollar&#046; A strong, reliable, safe and quiet air pump yet affordable&#046; Available models for virtually any aquatic environment&#046; </p><p> Model&#045; MA80</p><p>Aquarium Size&#045; 5&#045;10 gallon</p><p>Outlet&#045; Single </p><p>Control&#045; </p><p>Power&#045; 2&#046;4 watts</p><p>Air output&#045; 833 cc&#047;m</p><p></p><ul></ul></body></html> 24624_pid.jpg 7.14 0 6903717175", connection);
DoProductInsert("1 AJW21502 Aquarium Air Pumps Fusion Air Pump 300 Fusion air pump 300 24635_pid.jpg 6.89 0 618940215028", connection);
DoProductInsert("1 AJW21510 Aquarium Air Pumps Fusion Air Pump 700 Fusion air pump 700 24639_pid.jpg 20.68 0 618940215103", connection);
DoProductInsert("1 AJW21508 Aquarium Air Pumps Fusion Air Pump 600 Fusion air pump 600 24638_pid.jpg 17.24 0 618940215080", connection);
DoProductInsert("1 AJW21506 Aquarium Air Pumps Fusion Air Pump 500 Fusion air pump 500 24637_pid.jpg 11.72 0 618940215066", connection);
DoProductInsert("1 AJW21504 Aquarium Air Pumps Fusion Air Pump 400 Fusion air pump 400 24636_pid.jpg 8.61 0 618940215042", connection);
DoProductInsert("1 ACA17540 Aquarium Air Pumps Million Air Ma - 100 Air Pump <html><head></head><body><h2> Million Air&#047;Commodity Axis Inc&#046; - ACA17540</h2><p> Simply the best pump for your dollar&#046; A strong, reliable, safe and quiet air pump yet affordable&#046; Available models for virtually any aquatic environment&#046; </p><p> Model&#045; MA100</p><p>Aquarium Size&#045; 5&#045;20 gallon</p><p>Outlet&#045; Single </p><p>Control&#045; </p><p>Power&#045; 2&#046;3 watts</p><p>Air output&#045; 1666 cc&#047;m</p><p></p><ul></ul></body></html> 24626_pid.jpg 8.01 0 6903717540", connection);
DoProductInsert("1 AHYKB3201 Aquarium Air Pumps Ario Log Kit (ornament & Ario 4 Green) Large <html><head><LINK REL="stylesheet" HREF="/VIA/RES/Settings/PreloginCatalog.css" TYPE="text/css"></head><body><h2>HYDOR USA INC - HYDOR ARIO LOG KIT GREEN LG</h2><ul><li>Beautiful Deco aquarium ornament kit features a large log/stump ornament and a green Ario #4. For aquariums 20"+- deep.</li></ul></body></html> 25719_pid.jpg 60.37 0 841421005294", connection);
DoProductInsert("1 ATS26075 Aquarium Air Pumps Tetra 150 Air Pump Formally Deep Water <html><head><LINK REL="stylesheet" HREF="/VIA/RES/Settings/PreloginCatalog.css" TYPE="text/css"></head><body><h2>Tetra - TETRA AP 150 AIR PUMP</h2><p>These Whisper® air Pumps are Tetra&#039;s most powerful line of air pumps&#046; The pumps are designed for situations that produce greater back&#045;pressure, such as deep tanks &#040;up to 8 feet deep&#041;, long decorator air stones, multiple air stones in one or more tanks, and protein skimmers for saltwater&#046;</p><p>AP 150</p><ul></ul></body></html> 25812_pid.jpg 42.27 0 46798260752", connection);
DoProductInsert("1 ATS77855 Aquarium Air Pumps Whisper 100 Air Pump (new Design) <html><head><LINK REL="stylesheet" HREF="/VIA/RES/Settings/PreloginCatalog.css" TYPE="text/css"></head><body><h2>Tetra - TETRA WHISP 100 AIR PUMP</h2><p>Whisper 100 Air Pump</p><p>The New Shape of Silence&#033; Designed From the Ground Up for Silence and Performance&#046;</p><p>Minimal noise, maximum air flow&#046; The Whisper® Air Pump&#039;s dome shape actually flattens sound wave frequencies&#046; In addition, each model features sound&#045;dampening chambers designed specifically for that model&#046; And the air pump&#039;s rubber feet and suspended motor prevent sound waves from reflecting off surfaces such as tables and shelves&#046; </p><ul><li>Whisper® 100</li></ul></body></html> 25814_pid.jpg 22.79 0 46798778554", connection);
DoProductInsert("1 AHYKB3101 Aquarium Air Pumps Ario Log Kit (ornament & Ario 2 Green) Medium <html><head><LINK REL="stylesheet" HREF="/VIA/RES/Settings/PreloginCatalog.css" TYPE="text/css"></head><body><h2>HYDOR USA INC - HYDOR ARIO LOG KIT GRN MD</h2><ul><li>Beautiful Deco aquarium ornament kit features a medium log/stump ornament and a green Ario #2. For aquariums 15"+- deep.</li></ul></body></html> 25718_pid.jpg 39.66 0 841421005287", connection);
DoProductInsert("1 AHYKB2201 Aquarium Air Pumps Ario Geyser Kit (ornament & Ario 4 Blue) Large <html><head><LINK REL="stylesheet" HREF="/VIA/RES/Settings/PreloginCatalog.css" TYPE="text/css"></head><body><h2>HYDOR USA INC - HYDOR ARIO GEYSER KIT BLUE LG</h2><ul><li>Beautiful deco aquarium ornament kit features a large guyser ornament and a blue Ario #4. For aquariums 20"+- deep.</li></ul></body></html> 25717_pid.jpg 60.37 0 841421005270", connection);
DoProductInsert("1 AHYKB1201 Aquarium Air Pumps Ario Volcano Kit (ornament & Ario 4 Red) Large <html><head><LINK REL="stylesheet" HREF="/VIA/RES/Settings/PreloginCatalog.css" TYPE="text/css"></head><body><h2>HYDOR USA INC - HYDOR ARIO VOLCANO KIT RED LG</h2><ul><li>Beautiful Deco aquarium ornament kit features a large volcano ornament and a red Ario #4. For aquariums 20"+- deep.</li></ul></body></html> 25716_pid.jpg 60.37 0 841421005256", connection);
DoProductInsert("1 ATS26076 Aquarium Air Pumps Tetra 300 Air Pump (tanks To 96" Or Multi Applications) Formally Deep Water <html><head><LINK REL="stylesheet" HREF="/VIA/RES/Settings/PreloginCatalog.css" TYPE="text/css"></head><body><h2>TETRA AP 300 AIR PUMP - These Whisper® air Pumps are Tetra&#039;s most powerful line of air pumps&#046; The pumps are designed for situations that produce greater back&#045;pressure, such as deep tanks &#040;up to 8 feet deep&#041;, long decorator air stones, multiple air stones in one or more tanks, and protein skimmers for saltwater&#046;</h2><p>AP 300</p><ul></ul></body></html> 25813_pid.jpg 73.97 0 46798260769", connection);
DoProductInsert("1 AHY14201 Aquarium Air Pumps Ario 4 Color Venturi Submersible Air Pump Red Ario 4 color venturi submersible air pump red 28102_pid.jpg 29.15 0 0", connection);
DoProductInsert("1 AHY22101 Aquarium Air Pumps Ario 2 Color Venturi Submersible Air Pump Blue Ario 2 color venturi submersible air pump blue 28103_pid.jpg 26.89 0 0", connection);
DoProductInsert("1 AAP704C Aquarium Air Stones & Wands Rena Micro Bubbler Ceramic Airstone 2" Rena micro bubbler ceramic airstone 2" 1889_pid.jpg 4.1 0 17163037040", connection);
}
private static void DoProductInsert(string P_line, DAConnect P_connection)
{
string[] parts = P_line.Split('\t');
var item = new ProductItem {VendorID = 1};
if (parts[1].Length < 50)
{
item.ItemID = parts[1];
item.ProductCode = parts[1];
}
else
{
item.ItemID = parts[1].Substring(0, 50);
item.ProductCode = parts[1].Substring(0, 50);
}
if (parts[2].Length < 50)
{
item.Category = parts[2];
}
else
{
item.Category = parts[2].Substring(0, 50);
}
if (parts[4].Length < 50)
{
item.ProductName = parts[4];
}
else
{
item.ProductName = parts[4].Substring(0, 50);
}
if (parts[5].Length < 50)
{
item.ProductDescription = parts[5];
}
else
{
item.ProductDescription = parts[5].Substring(0, 50);
}
if (parts[6].Length < 50)
{
item.Picture = parts[6];
}
else
{
item.Picture = parts[6].Substring(0, 50);
}
if (parts[7].Length < 50)
{
item.ProductSize = parts[7];
}
else
{
item.ProductSize = parts[7].Substring(0, 50);
}
item.Cost = Convert.ToDecimal(parts[8]);
item.UPC = parts[10];
var itemDA = new ProductItemDA {WorkingItem = item, InsertUpdateData = true};
itemDA.SetupConnectionString(P_connection.GetConnectionString());
itemDA.Execute();
}
/// <summary>
/// This method will get a list of products. Any attributes set
/// will be use for the where clause. If no attributes are selected
/// then all products will be returned.
/// </summary>
/// <returns>
/// List of products selected
/// </returns>
public List<ProductItem> GetProductList(DAConnect P_connection)
{
var retVal = new List<ProductItem>();
string whereClause = "";
var parmList = new ParmList();
if (VendorID != -1)
{
parmList.Add(ProductItem.ParmVendorID, VendorID);
AddToWhereClause(ref whereClause, ProductItem.VendorColumn,
ProductItem.ParmVendorID);
}
if (ProductCode != null)
{
parmList.Add(ProductItem.ParmProdCode, ProductCode);
AddToWhereClause(ref whereClause, ProductItem.ProdCodeColumn,
ProductItem.ParmProdCode);
}
if (Section != null)
{
parmList.Add(ProductItem.ParmSection, Section);
AddToWhereClause(ref whereClause, ProductItem.SectionColumn,
ProductItem.ParmSection);
}
if (Category != null)
{
parmList.Add(ProductItem.ParmCategory, Category);
AddToWhereClause(ref whereClause, ProductItem.CategoryColumn,
ProductItem.ParmCategory);
}
if (ProductName != null)
{
parmList.Add(ProductItem.ParmProductName, ProductName);
AddToWhereClause(ref whereClause, ProductItem.ProdNameColumn,
ProductItem.ParmProductName);
}
if (ProductDescription != null)
{
parmList.Add(ProductItem.ParmDescription, ProductDescription);
AddToWhereClause(ref whereClause, ProductItem.DescriptionColumn,
ProductItem.ParmDescription);
}
if (Picture != null)
{
parmList.Add(ProductItem.ParmPicture, Picture);
AddToWhereClause(ref whereClause, ProductItem.PictureColumn,
ProductItem.ParmPicture);
}
if (ProductSize != null)
{
parmList.Add(ProductItem.ParmProductSize, ProductSize);
AddToWhereClause(ref whereClause, ProductItem.SizeColumn,
ProductItem.ParmProductSize);
}
if (Cost != -1M)
{
parmList.Add(ProductItem.ParmCost, Cost);
AddToWhereClause(ref whereClause, ProductItem.CostColumn,
ProductItem.ParmCost);
}
if (ShippingSurcharge != -1M)
{
parmList.Add(ProductItem.ParmShippingSurcharge, ShippingSurcharge);
AddToWhereClause(ref whereClause, ProductItem.ShippingChargeColumn,
ProductItem.ParmShippingSurcharge);
}
if (UPC != null)
{
parmList.Add(ProductItem.ParmUPC, UPC);
AddToWhereClause(ref whereClause, ProductItem.UPCColumn,
ProductItem.ParmUPC);
}
if (whereClause != "")
{
whereClause = String.Format(" Where {0}", whereClause);
}
string cmd = String.Format("Select * from Product{0}", whereClause);
DataTable data = P_connection.ReturnSQLDataReader(cmd, parmList);
foreach (DataRow row in data.Rows)
{
var item = new ProductItem();
item.Category = row[ProductItem.CategoryColumn].ToString().Trim();
item.Cost = (decimal)row[ProductItem.CostColumn];
item.Picture = row[ProductItem.PictureColumn].ToString().Trim();
item.ProductCode = row[ProductItem.ProdCodeColumn].ToString().Trim();
item.ProductDescription = row[ProductItem.DescriptionColumn].ToString().Trim();
item.ProductName = row[ProductItem.ProdNameColumn].ToString().Trim();
item.ProductSize = row[ProductItem.SizeColumn].ToString().Trim();
item.Section = row[ProductItem.SectionColumn].ToString().Trim();
item.ShippingSurcharge = (decimal) row[ProductItem.ShippingChargeColumn];
item.UPC = row[ProductItem.UPCColumn].ToString().Trim();
retVal.Add(item);
}
return(retVal);
}