/// <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);
}
