Cases, Cases, Cases

Paul R. shows us a classic example of the sort of case statement that maybe, you know, never should've been implemented as a case statement:

It is cut and paste to the extreme. Even worse, as fields were added, someone would have to go in and update this block of code. This massive block was replaced with...

var fieldName = reader["TemplateFieldName"].ToString();
theCommands = theCommands.Replace(
    fieldName, WashTheValue(reader["FieldValue"].ToString(), 
    reader["OrderingFieldID"].ToString(), 
    reader["PriceFormat"].ToString()));

Below, you'll find the original code. Don't sprain your scrolling finger!

                    switch (reader["TemplateFieldName"].ToString())
                    {
                        case "<2yr.Guarantee>":
                            theCommands = theCommands.Replace("<2yr.Guarantee>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Address>":
                            theCommands = theCommands.Replace("<Address>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<ADDRESS>":
                            theCommands = theCommands.Replace("<ADDRESS>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<address1>":
                            theCommands = theCommands.Replace("<address1>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<address2>":
                            theCommands = theCommands.Replace("<address2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<AddressLine2>":
                            theCommands = theCommands.Replace("<AddressLine2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<BareRoot>":
                            theCommands = theCommands.Replace("<BareRoot>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Blank>":
                            theCommands = theCommands.Replace("<Blank>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<BLANK>":
                            theCommands = theCommands.Replace("<BLANK>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<BlankBack>":
                            theCommands = theCommands.Replace("<BlankBack>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<BulbSize>":
                            theCommands = theCommands.Replace("<BulbSize>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<BulbSizeSpanish>":
                            theCommands = theCommands.Replace("<BulbSizeSpanish>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CanadianTireCode>":
                            theCommands = theCommands.Replace("<CanadianTireCode>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Certified>":
                            theCommands = theCommands.Replace("<Certified>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CLEMATIS>":
                            theCommands = theCommands.Replace("<CLEMATIS>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<COLOR_BAR>":
                            theCommands = theCommands.Replace("<COLOR_BAR>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CompanyAddress>":
                            theCommands = theCommands.Replace("<CompanyAddress>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CompanyName>":
                            theCommands = theCommands.Replace("<CompanyName>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CONTAINER_SIZE>":
                            theCommands = theCommands.Replace("<CONTAINER_SIZE>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<ContainerSize>":
                            theCommands = theCommands.Replace("<ContainerSize>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CTC>":
                            theCommands = theCommands.Replace("<CTC>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Cust.Stock#>":
                            theCommands = theCommands.Replace("<Cust.Stock#>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CustomerAddress>":
                            theCommands = theCommands.Replace("<CustomerAddress>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<customerCode>":
                            theCommands = theCommands.Replace("<customerCode>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CustomerStock#>":
                            theCommands = theCommands.Replace("<CustomerStock#>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<CustStockNum>":
                            theCommands = theCommands.Replace("<CustStockNum>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<DeerIcon>":
                            theCommands = theCommands.Replace("<DeerIcon>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<description>":
                            theCommands = theCommands.Replace("<description>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<DisplayStakeHole>":
                            theCommands = theCommands.Replace("<DisplayStakeHole>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GADD>":
                            theCommands = theCommands.Replace("<GADD>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Gallons>":
                            theCommands = theCommands.Replace("<Gallons>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GNAME>":
                            theCommands = theCommands.Replace("<GNAME>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Grade>":
                            theCommands = theCommands.Replace("<Grade>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Grower>":
                            theCommands = theCommands.Replace("<Grower>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrowerAddress>":
                            theCommands = theCommands.Replace("<GrowerAddress>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<growerAddress>":
                            theCommands = theCommands.Replace("<growerAddress>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<growerName>":
                            theCommands = theCommands.Replace("<growerName>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrowerName>":
                            theCommands = theCommands.Replace("<GrowerName>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownBy>":
                            theCommands = theCommands.Replace("<GrownBy>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<grownBy>":
                            theCommands = theCommands.Replace("<grownBy>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownBy1>":
                            theCommands = theCommands.Replace("<GrownBy1>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownBy2>":
                            theCommands = theCommands.Replace("<GrownBy2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownBy3>":
                            theCommands = theCommands.Replace("<GrownBy3>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownByLine2>":
                            theCommands = theCommands.Replace("<GrownByLine2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownByLine3>":
                            theCommands = theCommands.Replace("<GrownByLine3>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownIn>":
                            theCommands = theCommands.Replace("<GrownIn>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrowninCanada>":
                            theCommands = theCommands.Replace("<GrowninCanada>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<GrownInCanada>":
                            theCommands = theCommands.Replace("<GrownInCanada>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<HagenCode>":
                            theCommands = theCommands.Replace("<HagenCode>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<HasPrice>":
                            theCommands = theCommands.Replace("<HasPrice>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Inches>":
                            theCommands = theCommands.Replace("<Inches>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<InsidersLogo>":
                            theCommands = theCommands.Replace("<InsidersLogo>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<InsidersReport>":
                            theCommands = theCommands.Replace("<InsidersReport>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<ItemNumber>":
                            theCommands = theCommands.Replace("<ItemNumber>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Licensed>":
                            theCommands = theCommands.Replace("<Licensed>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<LicensedGrower>":
                            theCommands = theCommands.Replace("<LicensedGrower>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Liters>":
                            theCommands = theCommands.Replace("<Liters>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Logo>":
                            theCommands = theCommands.Replace("<Logo>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Logo2>":
                            theCommands = theCommands.Replace("<Logo2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<MultiPrice>":
                            theCommands = theCommands.Replace("<MultiPrice>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<NAME>":
                            theCommands = theCommands.Replace("<NAME>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<NewLogo>":
                            theCommands = theCommands.Replace("<NewLogo>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<NotPlantedRetail>":
                            theCommands = theCommands.Replace("<NotPlantedRetail>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<OnSaleFor>":
                            theCommands = theCommands.Replace("<OnSaleFor>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Origin>":
                            theCommands = theCommands.Replace("<Origin>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<OSHLocation>":
                            theCommands = theCommands.Replace("<OSHLocation>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<OwnRoot>":
                            theCommands = theCommands.Replace("<OwnRoot>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Page_Number>":
                            theCommands = theCommands.Replace("<Page_Number>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PBS>":
                            theCommands = theCommands.Replace("<PBS>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PC>":
                            theCommands = theCommands.Replace("<PC>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PICASCode>":
                            theCommands = theCommands.Replace("<PICASCode>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PinkDot>":
                            theCommands = theCommands.Replace("<PinkDot>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Plant1>":
                            theCommands = theCommands.Replace("<Plant1>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Plant2>":
                            theCommands = theCommands.Replace("<Plant2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Plant3>":
                            theCommands = theCommands.Replace("<Plant3>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Plant4>":
                            theCommands = theCommands.Replace("<Plant4>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Plant5>":
                            theCommands = theCommands.Replace("<Plant5>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PlantCount>":
                            theCommands = theCommands.Replace("<PlantCount>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PlantedRetail>":
                            theCommands = theCommands.Replace("<PlantedRetail>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PotSize>":
                            theCommands = theCommands.Replace("<PotSize>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PotSizeIcon>":
                            theCommands = theCommands.Replace("<PotSizeIcon>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Premium>":
                            theCommands = theCommands.Replace("<Premium>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Price>":
                            theCommands = theCommands.Replace("<Price>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<price>":
                            theCommands = theCommands.Replace("<price>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<PricePoint>":
                            theCommands = theCommands.Replace("<PricePoint>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<ProductOfUSA>":
                            theCommands = theCommands.Replace("<ProductOfUSA>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<ProductofUSA>":
                            theCommands = theCommands.Replace("<ProductofUSA>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Retail>":
                            theCommands = theCommands.Replace("<Retail>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<RetailPrice>":
                            theCommands = theCommands.Replace("<RetailPrice>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<RetailPricePoint>":
                            theCommands = theCommands.Replace("<RetailPricePoint>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Season>":
                            theCommands = theCommands.Replace("<Season>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<ShippingCode>":
                            theCommands = theCommands.Replace("<ShippingCode>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Size>":
                            theCommands = theCommands.Replace("<Size>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<SIZE>":
                            theCommands = theCommands.Replace("<SIZE>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<SizeCode>":
                            theCommands = theCommands.Replace("<SizeCode>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<SKU>":
                            theCommands = theCommands.Replace("<SKU>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<SKU2>":
                            theCommands = theCommands.Replace("<SKU2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<SKU3>":
                            theCommands = theCommands.Replace("<SKU3>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Slot_For_Pixie>":
                            theCommands = theCommands.Replace("<Slot_For_Pixie>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<SpecialPricing>":
                            theCommands = theCommands.Replace("<SpecialPricing>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Supplier>":
                            theCommands = theCommands.Replace("<Supplier>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<TagDate>":
                            theCommands = theCommands.Replace("<TagDate>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<TargetLocation>":
                            theCommands = theCommands.Replace("<TargetLocation>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Type>":
                            theCommands = theCommands.Replace("<Type>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<UPC>":
                            theCommands = theCommands.Replace("<UPC>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<UPC_Readable>":
                            theCommands = theCommands.Replace("<UPC_Readable>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<UPCBackground>":
                            theCommands = theCommands.Replace("<UPCBackground>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<UPCCanadian>":
                            theCommands = theCommands.Replace("<UPCCanadian>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WaM>":
                            theCommands = theCommands.Replace("<WaM>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WAM>":
                            theCommands = theCommands.Replace("<WAM>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<wam>":
                            theCommands = theCommands.Replace("<wam>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WaM2>":
                            theCommands = theCommands.Replace("<WaM2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Website>":
                            theCommands = theCommands.Replace("<Website>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Weights>":
                            theCommands = theCommands.Replace("<Weights>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Weights1>":
                            theCommands = theCommands.Replace("<Weights1>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<Weights2>":
                            theCommands = theCommands.Replace("<Weights2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WeightsAndMeasures>":
                            theCommands = theCommands.Replace("<WeightsAndMeasures>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WeightsAndMeasures2>":
                            theCommands = theCommands.Replace("<WeightsAndMeasures2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WeightsMeasures>":
                            theCommands = theCommands.Replace("<WeightsMeasures>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WeightsMeasures1>":
                            theCommands = theCommands.Replace("<WeightsMeasures1>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<WeightsMeasures2>":
                            theCommands = theCommands.Replace("<WeightsMeasures2>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<No_DDD_Logo>":
                            theCommands = theCommands.Replace("<No_DDD_Logo>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        case "<NGcode>":
                            theCommands = theCommands.Replace("<NGcode>", WashTheValue(reader["FieldValue"].ToString(), reader["OrderingFieldID"].ToString(), reader["PriceFormat"].ToString()));
                            break;
                        default:
                            break;
                    }

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!