/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromKitnonstocksingle(ref DataRow row, Kitnonstocksingle entity) { row.SetField("orderno", entity.orderno); row.SetField("ordersuf", entity.ordersuf); row.SetField("lineno", entity.lineno); row.SetField("hiddenwhse", entity.hiddenwhse); row.SetField("windowtitle", entity.windowtitle); row.SetField("price", entity.price); row.SetField("prodcost", entity.prodcost); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("tariffcd", entity.tariffcd); row.SetField("warrexchgfl", entity.warrexchgfl); row.SetField("ordertype", entity.ordertype); row.SetField("kitwhse", entity.kitwhse); row.SetField("functionname", entity.functionname); row.SetField("inquiryfl", entity.inquiryfl); row.SetField("shipprod", entity.shipprod); row.SetField("proddesc", entity.proddesc); row.SetField("proddescmodified", entity.proddescmodified); row.SetField("origprod", entity.origprod); row.SetField("vendno", entity.vendno); row.SetField("vendorname", entity.vendorname); row.SetField("vendnoentryfl", entity.vendnoentryfl); row.SetField("foreigncost", entity.foreigncost); row.SetField("currencyty", entity.currencyty); row.SetField("shortdesc", entity.shortdesc); row.SetField("exchgrate", entity.exchgrate); row.SetField("pricetype", entity.pricetype); row.SetField("pricetypedesc", entity.pricetypedesc); row.SetField("pricetypeentryfl", entity.pricetypeentryfl); row.SetField("prodline", entity.prodline); row.SetField("linedesc", entity.linedesc); row.SetField("arpwhse", entity.arpwhse); row.SetField("arpwhsedesc", entity.arpwhsedesc); row.SetField("arpwhseentryfl", entity.arpwhseentryfl); row.SetField("prodcat", entity.prodcat); row.SetField("catdesc", entity.catdesc); row.SetField("origprodcost", entity.origprodcost); row.SetField("costoverfl", entity.costoverfl); row.SetField("shipprodenabled", entity.shipprodenabled); row.SetField("priceenabled", entity.priceenabled); row.SetField("pricetypeenabled", entity.pricetypeenabled); row.SetField("prodcostenabled", entity.prodcostenabled); row.SetField("proddescenabled", entity.proddescenabled); row.SetField("prodcatenabled", entity.prodcatenabled); row.SetField("vendnoenabled", entity.vendnoenabled); row.SetField("prodlineenabled", entity.prodlineenabled); row.SetField("arpwhseenabled", entity.arpwhseenabled); row.SetField("countryoforiginenabled", entity.countryoforiginenabled); row.SetField("tariffcdenabled", entity.tariffcdenabled); row.SetField("btnlookupprodenabled", entity.btnlookupprodenabled); row.SetField("btnlookupprodcatenabled", entity.btnlookupprodcatenabled); row.SetField("btnlookuppricetypeenabled", entity.btnlookuppricetypeenabled); row.SetField("btnlookupvendnoenabled", entity.btnlookupvendnoenabled); row.SetField("btnlookupprodlineenabled", entity.btnlookupprodlineenabled); row.SetField("btnlookupwhseenabled", entity.btnlookupwhseenabled); row.SetField("btn_Cost-Calculatorenabled", entity.btnCostCalculatorenabled); row.SetField("currencytyhidden", entity.currencytyhidden); row.SetField("shortdeschidden", entity.shortdeschidden); row.SetField("exchgratehidden", entity.exchgratehidden); row.SetField("foreigncosthidden", entity.foreigncosthidden); row.SetField("btn_Cost-Calculatorhidden", entity.btnCostCalculatorhidden); row.SetField("forcespecactasked", entity.forcespecactasked); row.SetField("forcespecactanswer", entity.forcespecactanswer); row.SetField("forcespecinactasked", entity.forcespecinactasked); row.SetField("forcespecinactanswer", entity.forcespecinactanswer); row.SetField("quesanswer", entity.quesanswer); row.SetField("quesdescrip1", entity.quesdescrip1); row.SetField("quesdescrip2", entity.quesdescrip2); row.SetField("quespriceavail", entity.quespriceavail); row.SetField("quesprodcat", entity.quesprodcat); row.SetField("quesmessage", entity.quesmessage); row.SetField("userfield", entity.userfield); }
public static Kitnonstocksingle BuildKitnonstocksingleFromRow(DataRow row) { Kitnonstocksingle entity = new Kitnonstocksingle(); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.ordersuf = row.IsNull("ordersuf") ? 0 : row.Field <int>("ordersuf"); entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno"); entity.hiddenwhse = row.IsNull("hiddenwhse") ? string.Empty : row.Field <string>("hiddenwhse"); entity.windowtitle = row.IsNull("windowtitle") ? string.Empty : row.Field <string>("windowtitle"); entity.price = row.IsNull("price") ? decimal.Zero : row.Field <decimal>("price"); entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost"); entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin"); entity.tariffcd = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd"); entity.warrexchgfl = row.Field <bool>("warrexchgfl"); entity.ordertype = row.IsNull("ordertype") ? string.Empty : row.Field <string>("ordertype"); entity.kitwhse = row.IsNull("kitwhse") ? string.Empty : row.Field <string>("kitwhse"); entity.functionname = row.IsNull("functionname") ? string.Empty : row.Field <string>("functionname"); entity.inquiryfl = row.Field <bool>("inquiryfl"); entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc"); entity.proddescmodified = row.Field <bool>("proddescmodified"); entity.origprod = row.IsNull("origprod") ? string.Empty : row.Field <string>("origprod"); entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno"); entity.vendorname = row.IsNull("vendorname") ? string.Empty : row.Field <string>("vendorname"); entity.vendnoentryfl = row.Field <bool>("vendnoentryfl"); entity.foreigncost = row.IsNull("foreigncost") ? decimal.Zero : row.Field <decimal>("foreigncost"); entity.currencyty = row.IsNull("currencyty") ? string.Empty : row.Field <string>("currencyty"); entity.shortdesc = row.IsNull("shortdesc") ? string.Empty : row.Field <string>("shortdesc"); entity.exchgrate = row.IsNull("exchgrate") ? decimal.Zero : row.Field <decimal>("exchgrate"); entity.pricetype = row.IsNull("pricetype") ? string.Empty : row.Field <string>("pricetype"); entity.pricetypedesc = row.IsNull("pricetypedesc") ? string.Empty : row.Field <string>("pricetypedesc"); entity.pricetypeentryfl = row.Field <bool>("pricetypeentryfl"); entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline"); entity.linedesc = row.IsNull("linedesc") ? string.Empty : row.Field <string>("linedesc"); entity.arpwhse = row.IsNull("arpwhse") ? string.Empty : row.Field <string>("arpwhse"); entity.arpwhsedesc = row.IsNull("arpwhsedesc") ? string.Empty : row.Field <string>("arpwhsedesc"); entity.arpwhseentryfl = row.IsNull("arpwhseentryfl") ? string.Empty : row.Field <string>("arpwhseentryfl"); entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat"); entity.catdesc = row.IsNull("catdesc") ? string.Empty : row.Field <string>("catdesc"); entity.origprodcost = row.IsNull("origprodcost") ? decimal.Zero : row.Field <decimal>("origprodcost"); entity.costoverfl = row.Field <bool>("costoverfl"); entity.shipprodenabled = row.Field <bool>("shipprodenabled"); entity.priceenabled = row.Field <bool>("priceenabled"); entity.pricetypeenabled = row.Field <bool>("pricetypeenabled"); entity.prodcostenabled = row.Field <bool>("prodcostenabled"); entity.proddescenabled = row.Field <bool>("proddescenabled"); entity.prodcatenabled = row.Field <bool>("prodcatenabled"); entity.vendnoenabled = row.Field <bool>("vendnoenabled"); entity.prodlineenabled = row.Field <bool>("prodlineenabled"); entity.arpwhseenabled = row.Field <bool>("arpwhseenabled"); entity.countryoforiginenabled = row.Field <bool>("countryoforiginenabled"); entity.tariffcdenabled = row.Field <bool>("tariffcdenabled"); entity.btnlookupprodenabled = row.Field <bool>("btnlookupprodenabled"); entity.btnlookupprodcatenabled = row.Field <bool>("btnlookupprodcatenabled"); entity.btnlookuppricetypeenabled = row.Field <bool>("btnlookuppricetypeenabled"); entity.btnlookupvendnoenabled = row.Field <bool>("btnlookupvendnoenabled"); entity.btnlookupprodlineenabled = row.Field <bool>("btnlookupprodlineenabled"); entity.btnlookupwhseenabled = row.Field <bool>("btnlookupwhseenabled"); entity.btnCostCalculatorenabled = row.Field <bool>("btn_Cost-Calculatorenabled"); entity.currencytyhidden = row.Field <bool>("currencytyhidden"); entity.shortdeschidden = row.Field <bool>("shortdeschidden"); entity.exchgratehidden = row.Field <bool>("exchgratehidden"); entity.foreigncosthidden = row.Field <bool>("foreigncosthidden"); entity.btnCostCalculatorhidden = row.Field <bool>("btn_Cost-Calculatorhidden"); entity.forcespecactasked = row.Field <bool>("forcespecactasked"); entity.forcespecactanswer = row.Field <bool>("forcespecactanswer"); entity.forcespecinactasked = row.Field <bool>("forcespecinactasked"); entity.forcespecinactanswer = row.Field <bool>("forcespecinactanswer"); entity.quesanswer = row.IsNull("quesanswer") ? string.Empty : row.Field <string>("quesanswer"); entity.quesdescrip1 = row.IsNull("quesdescrip1") ? string.Empty : row.Field <string>("quesdescrip1"); entity.quesdescrip2 = row.IsNull("quesdescrip2") ? string.Empty : row.Field <string>("quesdescrip2"); entity.quespriceavail = row.IsNull("quespriceavail") ? string.Empty : row.Field <string>("quespriceavail"); entity.quesprodcat = row.IsNull("quesprodcat") ? string.Empty : row.Field <string>("quesprodcat"); entity.quesmessage = row.IsNull("quesmessage") ? string.Empty : row.Field <string>("quesmessage"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }