/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromPdspcustprodinitresults(ref DataRow row, Pdspcustprodinitresults entity)
{
row.SetField("enddt", entity.enddt);
row.SetField("statusty", entity.statusty);
row.SetField("reference", entity.reference);
row.SetField("promofl", entity.promofl);
row.SetField("jobno", entity.jobno);
row.SetField("quoteno", entity.quoteno);
row.SetField("termsdiscfl", entity.termsdiscfl);
row.SetField("termspct", entity.termspct);
row.SetField("commtype", entity.commtype);
row.SetField("prctyperb", entity.prctyperb);
row.SetField("prctypesv", entity.prctypesv);
row.SetField("pricesheet", entity.pricesheet);
row.SetField("priceeffdt", entity.priceeffdt);
row.SetField("prcontyli", entity.prcontyli);
row.SetField("prcontypd", entity.prcontypd);
row.SetField("prcontysv", entity.prcontysv);
row.SetField("prcontyshli", entity.prcontyshli);
row.SetField("prcontyshpd", entity.prcontyshpd);
row.SetField("qtytyli", entity.qtytyli);
row.SetField("qtytypd", entity.qtytypd);
row.SetField("qtytysv", entity.qtytysv);
row.SetField("qtybrktyli", entity.qtybrktyli);
row.SetField("qtybrktypd", entity.qtybrktypd);
row.SetField("qtybrktysv", entity.qtybrktysv);
row.SetField("contractno", entity.contractno);
row.SetField("modifier", entity.modifier);
row.SetField("modrebfl", entity.modrebfl);
row.SetField("userfield", entity.userfield);
}
public static Pdspcustprodinitresults BuildPdspcustprodinitresultsFromRow(DataRow row)
{
Pdspcustprodinitresults entity = new Pdspcustprodinitresults();
entity.enddt = row.Field <DateTime?>("enddt");
entity.statusty = row.IsNull("statusty") ? string.Empty : row.Field <string>("statusty");
entity.reference = row.IsNull("reference") ? string.Empty : row.Field <string>("reference");
entity.promofl = row.Field <bool>("promofl");
entity.jobno = row.IsNull("jobno") ? string.Empty : row.Field <string>("jobno");
entity.quoteno = row.IsNull("quoteno") ? string.Empty : row.Field <string>("quoteno");
entity.termsdiscfl = row.Field <bool>("termsdiscfl");
entity.termspct = row.IsNull("termspct") ? decimal.Zero : row.Field <decimal>("termspct");
entity.commtype = row.IsNull("commtype") ? string.Empty : row.Field <string>("commtype");
entity.prctyperb = row.IsNull("prctyperb") ? string.Empty : row.Field <string>("prctyperb");
entity.prctypesv = row.IsNull("prctypesv") ? string.Empty : row.Field <string>("prctypesv");
entity.pricesheet = row.IsNull("pricesheet") ? string.Empty : row.Field <string>("pricesheet");
entity.priceeffdt = row.Field <DateTime?>("priceeffdt");
entity.prcontyli = row.IsNull("prcontyli") ? string.Empty : row.Field <string>("prcontyli");
entity.prcontypd = row.IsNull("prcontypd") ? string.Empty : row.Field <string>("prcontypd");
entity.prcontysv = row.IsNull("prcontysv") ? string.Empty : row.Field <string>("prcontysv");
entity.prcontyshli = row.IsNull("prcontyshli") ? string.Empty : row.Field <string>("prcontyshli");
entity.prcontyshpd = row.IsNull("prcontyshpd") ? string.Empty : row.Field <string>("prcontyshpd");
entity.qtytyli = row.IsNull("qtytyli") ? string.Empty : row.Field <string>("qtytyli");
entity.qtytypd = row.IsNull("qtytypd") ? string.Empty : row.Field <string>("qtytypd");
entity.qtytysv = row.IsNull("qtytysv") ? string.Empty : row.Field <string>("qtytysv");
entity.qtybrktyli = row.IsNull("qtybrktyli") ? string.Empty : row.Field <string>("qtybrktyli");
entity.qtybrktypd = row.IsNull("qtybrktypd") ? string.Empty : row.Field <string>("qtybrktypd");
entity.qtybrktysv = row.IsNull("qtybrktysv") ? string.Empty : row.Field <string>("qtybrktysv");
entity.contractno = row.IsNull("contractno") ? string.Empty : row.Field <string>("contractno");
entity.modifier = row.IsNull("modifier") ? string.Empty : row.Field <string>("modifier");
entity.modrebfl = row.Field <bool>("modrebfl");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
