/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIcipfetchprodresults(ref DataRow row, Icipfetchprodresults entity) { row.SetField("descrip1", entity.descrip1); row.SetField("cstatus", entity.cstatus); row.SetField("upc", entity.upc); row.SetField("reservety", entity.reservety); row.SetField("enterdt", entity.enterdt); row.SetField("reservedays", entity.reservedays); row.SetField("acquiredt", entity.acquiredt); row.SetField("whsestatus", entity.whsestatus); row.SetField("length", entity.length); row.SetField("priceonty", entity.priceonty); row.SetField("unitstock", entity.unitstock); row.SetField("weight", entity.weight); row.SetField("width", entity.width); row.SetField("termsdiscfl", entity.termsdiscfl); row.SetField("termspct", entity.termspct); row.SetField("unitsell", entity.unitsell); row.SetField("cubes", entity.cubes); row.SetField("height", entity.height); row.SetField("sellmult", entity.sellmult); row.SetField("unitcnt", entity.unitcnt); row.SetField("prodcat", entity.prodcat); row.SetField("prodcatdescrip", entity.prodcatdescrip); row.SetField("rentprodcat", entity.rentprodcat); row.SetField("rentprodcatdesc", entity.rentprodcatdesc); row.SetField("rentalwhse", entity.rentalwhse); row.SetField("dt852out", entity.dt852out); row.SetField("issuesytd", entity.issuesytd); row.SetField("lifo", entity.lifo); row.SetField("lifodesc", entity.lifodesc); row.SetField("lastinvdt", entity.lastinvdt); row.SetField("receiptsytd", entity.receiptsytd); row.SetField("slgroup", entity.slgroup); row.SetField("sldesc", entity.sldesc); row.SetField("lastrcptdt", entity.lastrcptdt); row.SetField("pbseqno", entity.pbseqno); row.SetField("lastpowtdt", entity.lastpowtdt); row.SetField("msdsfl", entity.msdsfl); row.SetField("msdssheetno", entity.msdssheetno); row.SetField("lastpricechgdt", entity.lastpricechgdt); row.SetField("returnsinytd", entity.returnsinytd); row.SetField("msdschgdt", entity.msdschgdt); row.SetField("lastcountdt", entity.lastcountdt); row.SetField("returnsoutytd", entity.returnsoutytd); row.SetField("descrip3", entity.descrip3); row.SetField("btnserlothidden", entity.btnserlothidden); row.SetField("btnserlotlbl", entity.btnserlotlbl); row.SetField("btnfifohidden", entity.btnfifohidden); row.SetField("btnbalanceshidden", entity.btnbalanceshidden); row.SetField("btnrentalhidden", entity.btnrentalhidden); row.SetField("cataloghidden", entity.cataloghidden); row.SetField("allowusageupdate", entity.allowusageupdate); row.SetField("ncnr", entity.ncnr); row.SetField("eccnclasscd", entity.eccnclasscd); row.SetField("countryoforigin", entity.countryoforigin); row.SetField("tariffcd", entity.tariffcd); row.SetField("brandcode", entity.brandcode); row.SetField("mfgprod", entity.mfgprod); row.SetField("vendprod", entity.vendprod); row.SetField("altprodprccd", entity.altprodprccd); row.SetField("altprodgrp", entity.altprodgrp); row.SetField("unspsc", entity.unspsc); row.SetField("userfield", entity.userfield); }
public static Icipfetchprodresults BuildIcipfetchprodresultsFromRow(DataRow row) { Icipfetchprodresults entity = new Icipfetchprodresults(); entity.descrip1 = row.IsNull("descrip1") ? string.Empty : row.Field <string>("descrip1"); entity.cstatus = row.IsNull("cstatus") ? string.Empty : row.Field <string>("cstatus"); entity.upc = row.IsNull("upc") ? string.Empty : row.Field <string>("upc"); entity.reservety = row.IsNull("reservety") ? string.Empty : row.Field <string>("reservety"); entity.enterdt = row.Field <DateTime?>("enterdt"); entity.reservedays = row.IsNull("reservedays") ? 0 : row.Field <int>("reservedays"); entity.acquiredt = row.Field <DateTime?>("acquiredt"); entity.whsestatus = row.IsNull("whsestatus") ? string.Empty : row.Field <string>("whsestatus"); entity.length = row.IsNull("length") ? decimal.Zero : row.Field <decimal>("length"); entity.priceonty = row.IsNull("priceonty") ? string.Empty : row.Field <string>("priceonty"); entity.unitstock = row.IsNull("unitstock") ? string.Empty : row.Field <string>("unitstock"); entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field <decimal>("weight"); entity.width = row.IsNull("width") ? decimal.Zero : row.Field <decimal>("width"); entity.termsdiscfl = row.IsNull("termsdiscfl") ? string.Empty : row.Field <string>("termsdiscfl"); entity.termspct = row.IsNull("termspct") ? decimal.Zero : row.Field <decimal>("termspct"); entity.unitsell = row.IsNull("unitsell") ? string.Empty : row.Field <string>("unitsell"); entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field <decimal>("cubes"); entity.height = row.IsNull("height") ? decimal.Zero : row.Field <decimal>("height"); entity.sellmult = row.IsNull("sellmult") ? 0 : row.Field <int>("sellmult"); entity.unitcnt = row.IsNull("unitcnt") ? string.Empty : row.Field <string>("unitcnt"); entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field <string>("prodcat"); entity.prodcatdescrip = row.IsNull("prodcatdescrip") ? string.Empty : row.Field <string>("prodcatdescrip"); entity.rentprodcat = row.IsNull("rentprodcat") ? string.Empty : row.Field <string>("rentprodcat"); entity.rentprodcatdesc = row.IsNull("rentprodcatdesc") ? string.Empty : row.Field <string>("rentprodcatdesc"); entity.rentalwhse = row.Field <bool>("rentalwhse"); entity.dt852out = row.Field <DateTime?>("dt852out"); entity.issuesytd = row.IsNull("issuesytd") ? decimal.Zero : row.Field <decimal>("issuesytd"); entity.lifo = row.IsNull("lifo") ? string.Empty : row.Field <string>("lifo"); entity.lifodesc = row.IsNull("lifodesc") ? string.Empty : row.Field <string>("lifodesc"); entity.lastinvdt = row.Field <DateTime?>("lastinvdt"); entity.receiptsytd = row.IsNull("receiptsytd") ? decimal.Zero : row.Field <decimal>("receiptsytd"); entity.slgroup = row.IsNull("slgroup") ? string.Empty : row.Field <string>("slgroup"); entity.sldesc = row.IsNull("sldesc") ? string.Empty : row.Field <string>("sldesc"); entity.lastrcptdt = row.Field <DateTime?>("lastrcptdt"); entity.pbseqno = row.IsNull("pbseqno") ? 0 : row.Field <int>("pbseqno"); entity.lastpowtdt = row.Field <DateTime?>("lastpowtdt"); entity.msdsfl = row.IsNull("msdsfl") ? string.Empty : row.Field <string>("msdsfl"); entity.msdssheetno = row.IsNull("msdssheetno") ? string.Empty : row.Field <string>("msdssheetno"); entity.lastpricechgdt = row.Field <DateTime?>("lastpricechgdt"); entity.returnsinytd = row.IsNull("returnsinytd") ? decimal.Zero : row.Field <decimal>("returnsinytd"); entity.msdschgdt = row.Field <DateTime?>("msdschgdt"); entity.lastcountdt = row.Field <DateTime?>("lastcountdt"); entity.returnsoutytd = row.IsNull("returnsoutytd") ? decimal.Zero : row.Field <decimal>("returnsoutytd"); entity.descrip3 = row.IsNull("descrip3") ? string.Empty : row.Field <string>("descrip3"); entity.btnserlothidden = row.Field <bool>("btnserlothidden"); entity.btnserlotlbl = row.IsNull("btnserlotlbl") ? string.Empty : row.Field <string>("btnserlotlbl"); entity.btnfifohidden = row.Field <bool>("btnfifohidden"); entity.btnbalanceshidden = row.Field <bool>("btnbalanceshidden"); entity.btnrentalhidden = row.Field <bool>("btnrentalhidden"); entity.cataloghidden = row.Field <bool>("cataloghidden"); entity.allowusageupdate = row.Field <bool>("allowusageupdate"); entity.ncnr = row.IsNull("ncnr") ? string.Empty : row.Field <string>("ncnr"); entity.eccnclasscd = row.IsNull("eccnclasscd") ? string.Empty : row.Field <string>("eccnclasscd"); entity.countryoforigin = row.IsNull("countryoforigin") ? string.Empty : row.Field <string>("countryoforigin"); entity.tariffcd = row.IsNull("tariffcd") ? string.Empty : row.Field <string>("tariffcd"); entity.brandcode = row.IsNull("brandcode") ? string.Empty : row.Field <string>("brandcode"); entity.mfgprod = row.IsNull("mfgprod") ? string.Empty : row.Field <string>("mfgprod"); entity.vendprod = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod"); entity.altprodprccd = row.IsNull("altprodprccd") ? string.Empty : row.Field <string>("altprodprccd"); entity.altprodgrp = row.IsNull("altprodgrp") ? string.Empty : row.Field <string>("altprodgrp"); entity.unspsc = row.IsNull("unspsc") ? string.Empty : row.Field <string>("unspsc"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }